Binding the two girdviews using single dataset

Question

how to bind first 10 rows of dataset of one table to one gridview 

and another 10 rows of same dataset of same table to another girdview...

Plz send code to my a/c:

[e-mail]

Thanks

Answer 1

Use Linq to datatable, refer sample.

DataTable dtMain = new DataTable();
DataTable dt1 = new DataTable();
//bind datatable

var rows1_10 = from item in dt1.AsEnumerable()
     select item;
var top1_10 = rows1_10.Take(10);

//do a for-loop and insert into dtMain

DataTable dt2 = new DataTable();
//bind datatable
var rows2_10 = from item in dt2.AsEnumerable()
     select item;
var top2_10 = rows2_10.Take(10);

//do a for-loop and insert into dtMain

Answer 2

Hi Purna,
Try to create  two temp datasets with a datatable containing 10 rows. and bind these two dataset to gridviews seperately.
Thanks
Rajesh