Split datatable into multiple datatable

Posted by mareesnectar-12158 under ASP.NET on 1/21/2013 | Points: 10 | Views : 3011 | Status : [Member] | Replies : 2
I have DataTable having 250,000 rows. Is there any way I can split DataTable to 5 different datatables(dt[0],dt[1],dt[3]dt[4],dt[5] ) with each having 50,000 rows? To be more specific I want to split DataTable based on row number and also bind the data's in grid.




Responses

Posted by: Sourabh07 on: 1/22/2013 [Member] Starter | Points: 25

Up
0
Down
hi..

you can do it...try this in the stored procedure...

which returns the dataset and you can bind it accordingly...because dataset is the collection of various datatables.....:-)

Sourabh07

mareesnectar-12158, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pavanandey on: 1/23/2013 [Member] Bronze | Points: 25

Up
0
Down
loop through the dataset and break down the records

Thanks
Pavan Kumar
Mark Answer if this fits the need

mareesnectar-12158, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response