Access a specific row in DataReader

I find it easier to use a DataTable or DataSet. Something like this:

DataTable dt = new DataTable(); dt.Load(dreader) 

Then you can more easily reach a certain row using the DataTable.Rows property.

If I got you correctly, you can just count reader reads like this. Then when the count suits you, you can add something different:

int count = 0; if (dReader.HasRows) { while (dReader.Read()) { if(count == 1) //add special row gameweekList.Text += "something special " + dReader["gameweekID"].ToString(); else gameweekList.Text += "<div class=\"item\"><h4>Gameweek " + (dReader["gameweekID"].ToString()) + "</h4></div>"; count++; } } else { gameweekList.Text = "Error Finding Gameweeks"; } dReader.Close(); conn.Close(); 

But if you want to have current and subsequent read at the same time you should firs read onceand then start reading in a loop like this:

if (dReader.HasRows) { string previousRead = string.Empty; dReader.Read(); previousRead = dReader["gameweekID"].ToString(); while (dReader.Read()) { //use current and previous read //dReader["gameweekID"].ToString() //previousRead //update previousRead for the next read previousRead = dReader["gameweekID"].ToString(); } } else { gameweekList.Text = "Error Finding Gameweeks"; } dReader.Close(); conn.Close(); 

To get the first row, start from 0 and always put it into a Data Tables because you always get problems reading directly from Data Readers;

if (dReader.HasRows) { DataTable dt = new DataTable(); dt.Load(dreader) gameweekList.Text = dt.Rows[0]["gameweekID"] }