nextresult

Question

Can you show me how to use nextresult in method private string get id. I want this method to return multiple values with Datareader. Thanks.

Manas Mohapatra · 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.

Upendra Pratap Shahi · Answer

use with dataset where you switch between two or more tables data.

abdujalil chuliev · Answer

Can you show me this code in asp.net.

Upendra Pratap Shahi · Answer

Try to convert tis in asp.net code