Datareader not displaying first row

Question

I am looping through my database to display a list of leagues a player is associated with. If a player is not a member of any leagues then a message displays to tell them.

Here is the code

if (dReader.Read())
{          
    while (dReader.Read())
    {
        usersLeagues.Text += "<li class=\"li-myLeagues\"><a  href=\"leagueDetails.aspx?leagueID=" + (dReader["leagueID"].ToString()) + "\">" + (dReader["leagueName"].ToString()) + "</a></li>";
    }
}
else
{
    usersLeagues.Text = "You are currently not a part of any leagues";
}
dReader.Close();
conn.Close();

The issue is that the data reader is not displaying the first league in the query.

Any idea why this is?

Although this is purely a guess, I'll have to check the documentation for the method, I imagine you're losing the first row with your "if" conditional. You will probably need another method to see if data was returned. — pwdst
– pwdst, Commented Mar 16, 2013 at 11:28
Remove this if (dReader.Read()) it will work fine, no need to write this, if there is no data it will not enter while loop. — Sharique Hussain Ansari
– Sharique Hussain Ansari, Commented Mar 16, 2013 at 11:29

Moha Dehghan · Accepted Answer · 2013-03-16 11:31:28Z

12

Change

if (dReader.Read()){

to

if (dReader.HasRows){

By calling the Read() in the if statement, you actually are reading the first row of data. Calling Read() again in the while statement, skips the first read row.

You can use HasRows property to check if the reader contains any data.

edited Mar 16, 2013 at 11:31

answered Mar 16, 2013 at 11:25

Moha Dehghan

18.5k3 gold badges60 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dean Roulston · Accepted Answer · 2013-03-16 11:26:55Z

1

The if statement is reading the first record, so when you hit the while statement it has moved onto the second result.

answered Mar 16, 2013 at 11:26

Dean Roulston

791 gold badge2 silver badges5 bronze badges

Collectives™ on Stack Overflow

Datareader not displaying first row

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related