Reply

Md. Elias Hossain Posted: 01-02-2010 12:50 PM

rated by 0 users

   While using Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 SqlDataAdapter, we can fill dataset with the Fill() method passing dataset object which contains tables collection as multiple result according to the CommandText.

   We can retrieve/traverse among the result set using Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 SqlDataReader as bellow:

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

        using (SqlConnection objConnection = new SqlConnection(ConnectionString))

        {

            objConnection.Open();

            using (SqlCommand sqlCmd = new SqlCommand("sp_Custom_GetMultipleResultSet", objConnection))

            {

                SqlDataReader objFirstResultSet = sqlCmd.ExecuteReader();

                if (objFirstResultSet.NextResult())

                {

                    // Other operation code block here

                }

            }

        }

Reply

Md Nazmul Ahsan replied on 01-04-2010 4:51 AM

rated by 0 users

"sp_Custom_GetMultipleResultSet" is this a store procedure name?

Reply

Md. Elias Hossain replied on 01-04-2010 5:36 AM

rated by 0 users

Yes, "sp_Custom_GetMultipleResultSet" is a stored procedure which contain multiple select statement.

Thanks