How to merge the datatable in dataset? Asp.net C#

Raja

i have one excel document and multiple sheets.sheets have many columns and row.i upload the document into my project.and the multiple sheets is bind to tables(sheet name is set as table name) using for loop.after the bind i change the table name to source1,source2,source3 (three sheets). Now how to bind(merge) the three tables in single table (source1).

I have Tried:

i have tried to rename the all tables to same name but the duplicate table is not allowed.how to bind the same table.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Hi
check the link
http://stackoverflow.com/questions/12278978/combining-n-datatables-into-a-single-datatable
Bhuvanesh Mohankumar10y ago
DataSet is a collection of DataTable,
you can add each of DataTable to the DataSet.
Raja10y ago
I have used below code to convert Excelsheet to Dataset and named table as table1,table2,table3. and generate xml xml tags have combined all three tables.i have add column in table and start tag and tag as <table1></table1>... <table n></table n> now the starting and ending tag must be same.then only back end sql is get the value so how to merge the table.i try this code if any other method is available pls suggest me.sorry for the late reply and same question ask again and again.

for (int k = 0; k < ds.Tables.Count; k++)
{
int c = k + 1;
string sheetname = ds.Tables[k].ToString();
if (ds.Tables[k].ToString() == "ExcelSheetName" + c)
{
ds.DataSetName = "Search"; ds.Tables[k].TableName = "Table" + c; ds.Tables["Table" + c].AcceptChanges();
}
}
Raja10y ago
Bikesh Srivastava
Can you Please elaborate.I have little bit confusion so only.
Bikesh Srivastava10y ago
You can add n number of datatable inside single dataset.
using this code .
DataSet dataset =newDataSet();
dataset .Tables.Add("tbl1");// Add datatable
............................
............................
//fetching datatable from dataset...........
DataTabletblResult=dataset .Tables["tbl1"];//fetchby datatable name
Try...
Raja10y ago
Sorry For late reply. Midhun
I have used the merge method.but excel document have multiple sheets.not only 3 sheets.how to merge this.Confused Lot.
Midhun Tp10y ago
Hi Raja,
You can use Datatable.Merge() method.
Suppose you got 3 DataTables d1, d2, d3 then you can merge all in to a single one -
d1.Merge(d2);
d1.Merge(d3);
Now d1 will have data of all three datatables.
Midhun Tp10y ago
Hi,
I assume you have saved that 3 sheets in to 3 datatables. Right?
Now you want 3 tables to be merged into a single datatable?
So is all the datatables are having same structure?
Raja10y ago
I have three separate table(three excel sheet) like d1,d2,d3.then how to merge.
Midhun Tp10y ago
Hi,
If you want to add 3 datatables to a dataset, just do the following -
DataSet ds=new DataSet();
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);
ds.Tables.Add(dt3);