C # Notes for using executereader to return datareader with both query result set and output parameters or return values

The command object exposes several execute methods that can be used to execute the required operations. When returning results in the form of data streams, you can use executereader to return the datareader object. You can use executescalar to return a single value. Executenonquery can be used to execute commands that do not return rows.

When you use a command object for a stored procedure, you can set the commandtype attribute of the command object to storedprocedure. When commandtype is storedprocedure, you can use the parameters attribute of command to access input and output parameters and return values. The parameters attribute can be accessed no matter which execute method is called.However, when executereader is called, the return value and output parameters cannot be accessed before datareader is disabled..