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


Please Help Members By Posting Answers For Below Questions

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

2765


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

2199


Give me some tips in c#?

2164


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

16592