how to connect bind a control to database by writing a
stored procedure?
Answer Posted / badrinath
dim con as sqlconncetion
dim cmd as sqlcommand
dim parm as sqlparameter
con=new sqlconnection
("server=localhost;database=Database1;username=sa;password=s
a")
cmd=new sqlcommand
con.open()
cmd.commandtype=commandtype.storedprocedure
cmd.commandtext="StoredprocedureName"
cmd.parmaeters.add("@Name",txtname.txt)
cmd.parameters.add("@sal",txtname.txt)
cmd.excutenonquery()
con.close()
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to update and insert from datagridview at run time in excel database?
how to insert fname,lname,designation values into database while click on the submit button using windows authentication mode?
How we work on N tire architecture in asp.net Please give me Examle...
Give me some tips in c#?