DataReader is a one using which you can iterate through forward direction only. Once used
dReader.Read();
, then first row will be fetched and if you use it again, you can get only second row, but you cannot get the first row values.
here also you used like this..
dReader = cmd.ExecuteReader();
dReader.Read();
SqlConnection sqlcon=new SqlConnection (Constring);
sqlcon.Open ();
string aa= dReader[0].ToString();
string aa1=dReader[1].ToString();
string aa2=dReader[2].ToString();
so, here you got first row, but again in while loop you have used
dReader.Read();
, so you missing the first row.
just comment or remove these lines and check..
dReader.Read();
string aa= dReader[0].ToString();<br />
string aa1=dReader[1].ToString();<br />
string aa2=dReader[2].ToString();
hope it works..