HELP! What I am trying to do is just check my data reader for the existance of data before binding. The following code works with the exception of it is leaving off the first record of the group. It is almost like the myDataReader.Read()) function that I am checking is not only returning True for the existance of data but moving forward one record in the reader. Here is the code, assume sqlstr has already been defined with a SQL String.<BR><BR>myConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))<BR>myConnection.Open()<BR>myCommand = New SQLCommand(sqlstr, myConnection)<BR>myDataReader = myCommand.ExecuteReader()<BR>if (myDataReader.Read()) then<BR> campaignsRP.Datasource = myDataReader<BR> campaignsRP.DataBind()<BR>else<BR> campaignsLabel.Text = "No records Found"<BR> end if<BR>myDataReader.close()<BR>myConnection.close()<BR>End Sub<BR><BR><BR>Any help would be appreciated! I can't find an answer anywhere.. 
<BR><BR>Thanks,<BR>Eugene<BR><BR>try myDataReader.IsClosedThanks for the response! That works partially. Apparently even with an empty recordset with no values, IsClosed is still false. So, it will not leave any rows out, but it will not print the "No Records Returned" prompt either. <BR><BR>Thanks though!<BR><BR>Eugene<BR>
<BR><BR>Thanks,<BR>Eugene<BR><BR>try myDataReader.IsClosedThanks for the response! That works partially. Apparently even with an empty recordset with no values, IsClosed is still false. So, it will not leave any rows out, but it will not print the "No Records Returned" prompt either. <BR><BR>Thanks though!<BR><BR>Eugene<BR>