Hi everybody,
I have one problem... I read 20000 rows at a time, but I use only one row and after processing, I use another row.
How can I do this?
Please reply.
See here:
con = new SqlConnection(nrdet);
SqlDataAdapter da = new SqlDataAdapter("select E1,SM1,R1,E2,SM2,R2,E3,SM3,R3,E4,SM4,R4,E5,SM5,R5,E6,SM6,R6,E7,SM7,R7,E8,SM8,R8,E9,SM9,R9,E10,SM10,R10 From TOTAL_NR WHERE SCHEME='" + DropDownList1.SelectedItem.Text + "' AND YR='" + DropDownList2.SelectedItem.Text + "' AND RESULT=3", con);
DataSet ds = new DataSet();
da.Fill(ds);
Actually, here there are 2000 rows, but I compare rows one after another.
I use E1,SM1,R1 values first I compare those results after E2,SM2,R2.....