If it is because of reading the first record as was explained, you can try a
loop like this:
if(SqlDataReader.Read)
{
do
{
//Do processing of the individual row here
}
while(SqlDataReader.Read);
}
else
{
//NO rows in SqlDataReader
}
With this you can check the existence of rows and still loop them one by
one(including the first one)
--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
http://blogs.aspadvice.com/joteke
"branton ellerbee" <bl**@sbcglobal.net> wrote in message
news:ld****************@newssvr23.news.prodigy.com ...
I am looping through a datareader and building a table. However, no matter
what the resultset, the datareader skips the first row of data, then
builds the rest of the resultset.
I have seen this occur in a lot of different places since using .Net.
HAs anyone else found this problem before?