I am using SqlDataReader.NextResult method in one of my pages and it's not displaying exactly what I'm looking for. If I have a result batch of, let's say, 5 Select statement, the SqlDataReader.NextResult method means any any result after the first result, correct? Another word, statement 2, 3, and 4, correct? Here's my code.
1 if (strCommText.Length > 0)
2 {
3 sqlComm.CommandText = strCommText.ToString();
4 sqlConn.Open();
5 SqlDataReader reader = sqlComm.ExecuteReader();
6 //Response.Write("SQL Command: " + sqlComm.CommandText + "<br />");
7 //if there is any datas from the query above
8 Go to the complete details ...