Hi,
i have 4 datatable. I need to make it one single table and I need to keep all duplicate columns also.Merge methode missing some data.I need to join all tables and to a single one and should keep duplicate columns also.I used below codes but i am missing some coloumn (duplicates also)
DataTable dtFinal = new DataTable();
for (int i = 0; i < resultDS.Tables.Count; i++)
{
if (i == 0)
dtFinal = resultDS.Tables[i].Copy();
else
dtFinal.Merge(resultDs.Tables[i]);
}
var ds = new DataSet();
ds.Tables.Add(dtFinal);
Muhammad Imran AnsariPosted Feb 2, 2022, 8:53 PM
Sujeet RamanPosted Feb 2, 2022, 6:40 PM
Muhammad Imran AnsariPosted Feb 2, 2022, 6:22 PM
Sujeet RamanPosted Feb 2, 2022, 6:13 PM
Muhammad Imran AnsariPosted Feb 2, 2022, 6:04 PM
Sujeet RamanPosted Feb 2, 2022, 5:59 PM
not working as expected.. here am getting only 3 columns.I dont need to remove duplicates.below am trying
var Dset = new DataSet();
DataTable dt1 = new DataTable();
dt1.Columns.Add("Name", typeof(string));
dt1.Columns.Add("Age", typeof(int));
// Create a DataRow, add Name and Age data, and add to the DataTable
DataRow dr1 = dt1.NewRow();
dr1["Name"] = "Mohammadsd"; // or dr[0]="Mohammad";
dr1["Age"] = 24; // or dr[1]=24;
dt1.Rows.Add(dr1);
Dset.Tables.Add(dt1);
DataTable dt2 = new DataTable();
dt2.Columns.Add("Name", typeof(string));
dt2.Columns.Add("Age", typeof(int));
// Create a DataRow, add Name and Age data, and add to the DataTable
DataRow dr2 = dt2.NewRow();
dr2["Name"] = "Mohammad"; // or dr[0]="Mohammad";
dr2["Age"] = 24; // or dr[1]=24;
dt2.Rows.Add(dr2);
Dset.Tables.Add(dt2);
DataTable dt3 = new DataTable();
dt3.Columns.Add("Name", typeof(string));
dt3.Columns.Add("sex", typeof(int));
// Create a DataRow, add Name and Age data, and add to the DataTable
DataRow dr3 = dt3.NewRow();
dr3["Name"] = "last"; // or dr[0]="Mohammad";
dr3["sex"] = 24; // or dr[1]=24;
dt3.Rows.Add(dr3);
Dset.Tables.Add(dt3);
DataTable dtFinal = new DataTable("dtEmployee");
for (int i = 0; i < Dset.Tables.Count; i++)
{
dtFinal.Merge(Dset.Tables[i]);
}
var ds = new DataSet();
ds.Tables.Add(dtFinal);//here i need to get 6 colms
Sujeet RamanPosted Feb 2, 2022, 5:24 PM
Muhammad Imran AnsariPosted Feb 2, 2022, 4:51 PM
Sachin SinghPosted Feb 2, 2022, 4:11 PM
Adrian Nufc TetherPosted Feb 2, 2022, 3:49 PM