How can you retrieve output values from a stored procedure in ADO.NET?
- Using the Close() method, Using the Open() method, Using the Dispose() method, Using the Cancel() method
- Using the ExecuteNonQuery() method, Using the ExecuteScalar() method, Using the ExecuteReader() method, Using the Execute() method
- Using the ExecuteStoredProc() method, Using the ExecuteStoredProcedure() method, Using the ExecuteSP() method, Using the CallStoredProc() method
- Using the Parameters collection of the SqlCommand object, Using the ConnectionString property, Using the Transaction property, Using the CommandTimeout property
You can retrieve output values from a stored procedure in ADO.NET by using the Parameters collection of the SqlCommand object. You need to specify the parameter direction as Output or ReturnValue in the stored procedure, and then retrieve the output values from the Parameters collection after executing the stored procedure.
Loading...
Related Quiz
- The "DataSource" property of a DataGrid or DataGridView control is typically set to a ___________.
- In Entity Framework, optimistic concurrency control helps prevent ___________ conflicts.
- When working with DataViews, what is the significance of the Sort property?
- Which ADO.NET method is used to add parameters to a SqlCommand object?
- Your application involves updating records across different databases. How would you implement distributed transaction management in ADO.NET?