asp.net - Data Table loads only last record of mysqlDataReader -

in page mysqldatareader returns 4 records.whenever load mysqldatareader datatable using

datatable dt = new datatable(); dt.clear(); dt.load(dr); 

datatable shows last record.

my code is:

datatable dt = new datatable(); (int = 0; < gvdemobatches.rows.count; i++) {      checkbox cb = (checkbox)gvdemobatches.rows[i].findcontrol("checkselect");      if (cb.checked == true)      {          panel2.visible = true;          objbebatch.batchid = convert.toint32(((label)gvdemobatches.rows[i].cells[0].findcontrol("lblbatchid")).text);           mysqldatareader dr = objbladdnewdemo.getparticulardemodata(objbebatch);          dt.clear();          dt.load(dr);       }  } 

"getparticulardemodata" stored procedure returns 7 rows.but datatable shows last record.

thanks in advance, ratnam.

first please write proper/full code 1 can understand ! according code, dr data row,and dr contain single row @ time, seems may have taken dr in loop,so @ last contain last record only.

so data table displays last record.!