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


Please Help Members By Posting Answers For Below Questions

What is difference between executenonquery and executequery?

721


What is Data Provider?

816


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?

788


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

697


Explian About DataAdapters

805


Which is faster entity framework or ado.net?

715


What are the parameters that control most of connection pooling behaviors?

776


Explain the two fundamental objects in ado.net?

699


Explain the differences between oledb sql server, oledbdotnet provider?

773


What are the ado.net components?

777


Define data access layer?

731


How can we serialize the dataset object?

759


What is connected architecture in ado.net?

713


What are the ado.net objects?

713


Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

787