Call a stored procedure from ado.net and pass parameter to it ?
- 7 Answers
- 23473 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
Answer Posted / narayansahu
create a connection object
create a command object like so
SqlCommand comm=new SqlCommand("storedprocname",conn)
comm.commandtype=cmmandtype.storedprocedure
and then add parameters like:
comm.parameters.addwithvale("@userid",textbox1.text)
comm.parameters.addwithvalue(@username",textbox2.text)
that's it
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
What is the difference between Optimistic and Pessimistic locking?
What is adodb dll?
Describe connection object in ado.net
What is ado circle?
Explain the difference in an abstract class and an interface?
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What are the data providers used in ado.net
How to retrieve the user id which is provided while windows authentication?
What is the usage of the dataset object in ado.net?
What are two types of transaction supported by ado.net?
What is ado in agriculture?
What is the use of sqldatareader class?
Why do we serialize data?
What are the objects of ado.net?
Define bubbled event?
