CODEWITHSUNDEEP
c#asp.netsql-serversql-server-2008sql-server-2005
SRJ
SRJ

Reputation: 198

How can i return more than one results from a single stored procedure?

I am Getting a list of selected rows from two or more tables in a single procedure. How can i return the result to process in c# code.

eg. here I get 2 set of resultsenter image description here

Upvotes: 0

Views: 314

Answers (2)

Adil
Adil

Reputation: 148120

You use DataSet to get the mulitple tables from stored procedure. You need multiple select statements in the stored procedure.

using (SqlConnection conn = new SqlConnection(connection))
{
    DataSet dataset = new DataSet();
    SqlDataAdapter adapter = new SqlDataAdapter();
    adapter.SelectCommand = new SqlCommand("YourStoredProcedure", conn);
    adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
    adapter.Fill(dataset);
    return dataset;
}

Upvotes: 1

Kain
Kain

Reputation: 273

It very easy. If your sp return one more record set ,your can do this:

IDataReader rd =null;//todo:
do
{
    while (rd.Read())
    {
        ///todo:
    }
} while (rd.NextResult());

Upvotes: 1

Related Questions