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 ? | 3 Yes | 0 No |
Post New Answer View All Answers
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#?
How to update and insert from datagridview at run time in excel database?