How to get the data set returned during the stored procedure !!!

cllc49

How to get the data set returned by the stored procedure?
E.g:
In stored procedure, there is select @aa as a
Ha ha put the returned value into the dataset?
Please master teaching
Thank you!

3521565

1. Return DataReader directly;
   
2. Return DATATABLE in a DATASET

The same usage as using SQL statements

与血有关

When reading a class of information unconditionally and simply, the stored procedure without parameters can be satisfied. In the application, SqlDataReader can be used in conjunction with it. SqlDataReader can quickly obtain the results of the query and provide a read-only row stream from the database A way. Can also be used with SqlDataAdapter and DataSet.
SqlDataReader dr = myCommand.ExcuteReader (CommandBehavior.CloseConnection);
// Execute the database access command. When the command is executed, if the associated DataReader object is closed, the associated Connection object will also be closed.

冷雨雪

Can refer here,
Analysis of multi-table operation in ADO.NET
http://blog.csdn.net/Leng Yuxue / archive / 2004/08/06 / 67016.aspx
http://blog.csdn.net/Leng Yuxue / archive / 2004/08/06 / 67037.aspx