In Foreach loop i am looping through the each object and getting each DatatTable object. So Finally I want to add these each DataTable into a final DataTable object. Here DataTable is of same type.
var dt1 = new DataTable();
dt1.Columns.Add("Col1", typeof(int));
dt1.Columns.Add("Col2", typeof(string));
var dt2 = dt1.Clone(); // just to ensure structure is identical. You will probably have different way to initialise your tables
// fill both tables as you do
// create result table with matching column layout
var result = dt1.Clone();
result.Load(dt1.CreateDataReader()); // read first table into result
result.Load(dt2.CreateDataReader()); // read second table into result
In Foreach loop i am looping through the each object and getting each DatatTable object. So Finally I want to add these each DataTable into a final DataTable object. Here DataTable is of same type.
According to your description, I am not clear about your requirement.
Do you means you want to add a datatable to another datatable?
If so, you can try to use datatable.Merge() method.
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id"), new DataColumn("Name"), new DataColumn("Age") });
dt.Rows.Add(1, "name1", "age1");
dt.Rows.Add(2, "name2", "age2");
dt.Rows.Add(3, "name3", "age3");
DataTable dt1 = new DataTable();
dt1.Columns.AddRange(new DataColumn[3] { new DataColumn("Id"), new DataColumn("Name"), new DataColumn("Age") });
dt1.Rows.Add(4, "name4", "age4");
dt1.Rows.Add(5, "name5", "age5");
dt1.Rows.Add(6, "name6", "age6");
dt.Merge(dt1);
If you want to use the foreach loop to traverse the datatable, you can try belwo code:
DataTable dt = new DataTable();
foreach (DataRow row in dt.Rows)
{
}
If I misunderstand your requirement, please post more details information about your requirement.
Best regards,
Sam
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
6 Points
16 Posts
Need Final DataTable object of ForEach loop DataTable object
May 05, 2020 10:09 AM|Learning Rocks|LINK
Hello Everyone,
In Foreach loop i am looping through the each object and getting each DatatTable object. So Finally I want to add these each DataTable into a final DataTable object. Here DataTable is of same type.
How to do it. any example, pls share me
Thanks,
Member
170 Points
96 Posts
Re: Need Final DataTable object of ForEach loop DataTable object
May 05, 2020 11:56 PM|timur.kh|LINK
You could probably utilise DataTable.Load for this:
var dt1 = new DataTable(); dt1.Columns.Add("Col1", typeof(int)); dt1.Columns.Add("Col2", typeof(string)); var dt2 = dt1.Clone(); // just to ensure structure is identical. You will probably have different way to initialise your tables // fill both tables as you do // create result table with matching column layout var result = dt1.Clone(); result.Load(dt1.CreateDataReader()); // read first table into result result.Load(dt2.CreateDataReader()); // read second table into resultContributor
2810 Points
1192 Posts
Re: Need Final DataTable object of ForEach loop DataTable object
May 06, 2020 02:22 AM|samwu|LINK
Hi Learning,
According to your description, I am not clear about your requirement.
Do you means you want to add a datatable to another datatable?
If so, you can try to use datatable.Merge() method.
DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id"), new DataColumn("Name"), new DataColumn("Age") }); dt.Rows.Add(1, "name1", "age1"); dt.Rows.Add(2, "name2", "age2"); dt.Rows.Add(3, "name3", "age3"); DataTable dt1 = new DataTable(); dt1.Columns.AddRange(new DataColumn[3] { new DataColumn("Id"), new DataColumn("Name"), new DataColumn("Age") }); dt1.Rows.Add(4, "name4", "age4"); dt1.Rows.Add(5, "name5", "age5"); dt1.Rows.Add(6, "name6", "age6"); dt.Merge(dt1);If you want to use the foreach loop to traverse the datatable, you can try belwo code:
DataTable dt = new DataTable(); foreach (DataRow row in dt.Rows) { }If I misunderstand your requirement, please post more details information about your requirement.
Best regards,
Sam
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.