nextresult

Try below code:

string connetionString = null;

SqlConnection sqlCnn ;

SqlCommand sqlCmd ;

string sql = null;

connetionString = "**************";

sql = "Select top 2 * from product; select top 2 * from ordermaster; ";

sqlCnn = new SqlConnection(connetionString);

try

{

sqlCnn.Open();

sqlCmd = new SqlCommand(sql, sqlCnn);

SqlDataReader sqlReader = sqlCmd.ExecuteReader();

while (sqlReader.Read())

{

MessageBox.Show ("From first SQL - " + sqlReader.GetValue(0) + " - " + sqlReader.GetValue(1));

}

sqlReader.NextResult();

while (sqlReader.Read())

{

MessageBox.Show("From second SQL - " + sqlReader.GetValue(0) + " - " + sqlReader.GetValue(1));

}

sqlReader.Close();

sqlCmd.Dispose();

sqlCnn.Close();

}

catch (Exception ex)

{

MessageBox.Show("Can not open connection ! ");

}

If it doesn't solve your problem or you are getting any exception please provide details.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
Accepted answer
Try below code:

string connetionString = null;
SqlConnection sqlCnn ;
SqlCommand sqlCmd ;
string sql = null;
connetionString = "**************";
sql = "Select top 2 * from product; select top 2 * from ordermaster; ";
sqlCnn = new SqlConnection(connetionString);
try
{
   sqlCnn.Open();
   sqlCmd = new SqlCommand(sql, sqlCnn);
   SqlDataReader sqlReader = sqlCmd.ExecuteReader();

   while (sqlReader.Read())
   {
      MessageBox.Show ("From first SQL - " + sqlReader.GetValue(0) + " - " +       sqlReader.GetValue(1));
   }

   sqlReader.NextResult();
   while (sqlReader.Read())
   {
      MessageBox.Show("From second SQL - " + sqlReader.GetValue(0) + " - " +       sqlReader.GetValue(1));
   }

   sqlReader.Close();
   sqlCmd.Dispose();
   sqlCnn.Close();
}
catch (Exception ex)
{
   MessageBox.Show("Can not open connection ! ");
}

If it doesn't solve your problem or you are getting any exception please provide details.
+1
Upendra Pratap Shahi11y ago
Try to convert tis in asp.net code
-1
abdujalil chuliev11y ago
Can you show me this code in asp.net.
0
Upendra Pratap Shahi11y ago
use with dataset where you switch between two or more tables data.
+1