How to split the particular data table from data set?

Question

i have multiple data table in data set. Example i have 8 data tables in data set i want split the particular data table and stored to another data table using c#. how to do it.

Midhun T P · Answer

Hi Suppose you have a Dataset ds with with multiple tables in it. Now you need to remove one table from that dataset and copy that table to another datatable. So here is the code for that- DataTable dtnew = ds.Tables[0]; //copy specific table to one datatable dtnew ds.Tables.Remove(dtnew); // Now that table is removed from dataset.

Rohitash Kumar Dixit · Answer

Hi Raja Below is the code to copy the table from the dataset and sort it on the basis of ID column: DataView d1t=ds.Tables[2].Copy().DefaultView; d1t.Sort = ID; DataTable finalNewTable=d1t.ToTable(); Remove that table from the dataset: dsNominations.Tables.RemoveAt(2); dsNominations.AcceptChanges()

Francis · Answer

Try this: //consideryourolddatasetcontains2datatable DataSetolddataset= new DataSet(); olddataset.Tables.Add( new DataTable( Tabl1 )); olddataset.Tables.Add( new DataTable( Tabl2 )); //getthedatatablefromolddataset DataTableolddatatable=olddataset.Tables[ Tabl1 ]; //removethedatatablefromolddataset olddataset.Tables.Remove(olddatatable); olddataset.AcceptChanges(); //committhechanges //createanewdataset DataSetnewDataset= new DataSet(); //Addtheolddatatable newDataset.Tables.Add(olddatatable); newDataset.AcceptChanges(); //committhechanges

Midhun T P · Answer

Hi You can try below code - DataTable dtnew = ds.Tables[0]; ds.Tables.Remove(dtnew); Above code will remove first datatable from dataset and add it to dtnew datatable.

Tejas Trivedi · Answer

Hello Raja You can use below method to split your datatable in the multiples. private static List SplitTable(DataTableoriginalTable int batchSize) { List tables= new List (); int i=0; int j=1; DataTablenewDt=originalTable.Clone(); newDt.TableName= Table_ +j; newDt.Clear(); foreach (DataRowrow in originalTable.Rows) { DataRownewRow=newDt.NewRow(); newRow.ItemArray=row.ItemArray; newDt.Rows.Add(newRow); i++; if (i==batchSize) { tables.Add(newDt); j++; newDt=originalTable.Clone(); newDt.TableName= Table_ +j; newDt.Clear(); i=0; } } if (newDt.Rows.Count>0) { tables.Add(newDt); j++; newDt=originalTable.Clone(); newDt.TableName= Table_ +j; newDt.Clear(); } return tables; } in the above example you should pass the maximum data table rows as an parameter batchsize. Hope this will help you out. Feel free to write if more information is required. Don't forget to mark as answer if this helps.

Midhun T P · Answer

Hi Do you need to just remove one datatable from a dataset and copy it as another datatable? or do you need to split columns from a datatable and create a new datatable?

Raja · Answer

Midhun T P Tejas Trivedi Francis Rohitash Kumar Dixit Sorry For Late Reply Thanks To All!

Raja · Answer

HI Midhun T P I don't understand can you please elaborate.

Raja · Answer

Hi Tejas Trivedi I want to split particular data table from data set and stored into another data table.

Raja · Answer

Hi Midhun T P i need to just remove one datatable from a dataset and copy it as another datatable