Call a stored procedure from ado.net and pass parameter to it ?
Answer Posted / guest
create con as connection object,cmd as command object
cmd.CommandType=CommandType.Storedprocedure
cmd.CommandText="storedprecedurename"
cmd.ExecuteNonQuery()
Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
What is difference between executenonquery and executequery?
What is Data Provider?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Explian About DataAdapters
Which is faster entity framework or ado.net?
What are the parameters that control most of connection pooling behaviors?
Explain the two fundamental objects in ado.net?
Explain the differences between oledb sql server, oledbdotnet provider?
What are the ado.net components?
Define data access layer?
How can we serialize the dataset object?
What is connected architecture in ado.net?
What are the ado.net objects?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?