Split datatable into multiple datatable

Posted by mareesnectar-12158 under ASP.NET on 1/21/2013 | Points: 10 | Views : 2821 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

Latest Posts