Append the output of query into DataTable RSS

• • Reply
  dipakprodhan...

  None

  0 Points

  5 Posts

  Append the output of query into DataTable

  Dec 19, 2018 11:30 AM|dipakprodhan.kol|LINK

  Hi, I have a requirement to check if DataTable is null then copy the row to DataTable otherwise need to append the row to the DataTable. 

  if (dtTable == null)
      {
          dtTable = (from DataRow dr in dtDetails.Rows
                     where dr["ID"].ToString() == Id
                     select dr).CopyToDataTable();
      }
      else
      {
         // Here Need to Add a new row in DataTable and append the output of 
           query into DataTable ie dtTable.
  
         DataRow row = selectedTable.NewRow();
  
          dtTable  = (from DataRow dr in dtDetails.Rows
          where dr["ID"].ToString() == Id
          select dr)
          // Need help here
  
      }
  Thanks.

• • Reply
  Nan Yu

  All-Star

  18815 Points

  3831 Posts

  Re: Append the output of query into DataTable

  Dec 20, 2018 07:25 AM|Nan Yu|LINK

  Hi dipakprodhan.kol ,

  You can refer to below code sample :

  if (dtTable == null)
  {
      dtTable = (from DataRow dr in dtDetails.Rows
                  where dr["ID"].ToString() == Id
                  select dr).CopyToDataTable();
  }
  else
  {
      var result = from DataRow dr in dtDetails.Rows
                      where dr["ID"].ToString() == Id
                      select dr;
  
      foreach (var item in result)
      {   
              
          dtTable.Rows.Add(item.ItemArray);
      }
  }

  Best Regards,

  Nan Yu

• • Reply
  jayakumarvin...

  Member

  583 Points

  265 Posts

  Re: Append the output of query into DataTable

  Dec 28, 2018 07:26 AM|jayakumarvinayagam|LINK

  Hi,

  if (dtTable == null)
  {
     dtTable = dtDetails.Copy();
  }
  else
  {
      var filterResponse = dtDetails.AsEnumerable().Where(x => x.Field<string>("ID") == Id);
      if(filterResponse.Count()>0)
         dtTable.Merge(filterResponse.CopyToDataTable());
  }
  dtTable.AcceptChanges();

  Note: if you wanna unique rows in dtTable, then compare and remove duplicate before start merge.

  Thanks,