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


Please Help Members By Posting Answers For Below Questions

how to insert fname,lname,designation values into database while click on the submit button using windows authentication mode?

2195


How we work on N tire architecture in asp.net Please give me Examle...

16582


Give me some tips in c#?

2160


How to update and insert from datagridview at run time in excel database?

2759