Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 help w/ .NextResult

Author  Topic 

nflor001
Starting Member

2 Posts

Posted - 2007-07-05 : 00:27:06
I have 2 select queries. For some reason its only gettting the results of the second query and skipping the first


SqlConnection conn = new SqlConnection("xxxxxxxx;");
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from glcuexercise;select * from glcuexerciselog;";


SqlDataReader therdr=cmd.ExecuteReader();

DataGrid1.DataSource = therdr;
DataBind();


therdr.NextResult();
DataGrid2.DataSource = therdr;
DataBind();



therdr.Close();
conn.Close();
   

- Advertisement -