Need Final DataTable object of ForEach loop DataTable object[Answered] RSS

• • Reply
  Learning Roc...

  Member

  8 Points

  21 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,

• • Reply
  timur.kh

  Member

  160 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 result	

• • Reply
  samwu

  Contributor

  3340 Points

  1409 Posts

  Re: Need Final DataTable object of ForEach loop DataTable object

  May 06, 2020 02:22 AM|samwu|LINK

  Hi Learning,

  Learning Rocks

  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.