problem with linq in datatable. RSS

• • Reply
  

  abhijithmani...

  Member

  398 Points

  169 Posts

  problem with linq in datatable.

  Feb 28, 2012 08:25 AM|LINK

  Hi,

  Can i get the query which gives me the comma separated value of the datarows of the datatable in LINQ????

• • Reply
  

  karthicks

  All-Star

  31328 Points

  5411 Posts

  Re: problem with linq in datatable.

  Feb 28, 2012 08:40 AM|LINK

  if you does not know column names then you can use index like below 

  var values = from val in dataTable.AsEnumerable() select val[0].ToString() + "," + val[1].ToString();

  hi, refer below code

  	DataTable dataTable = new DataTable();
  		dataTable.Columns.Add("Id");
  		dataTable.Columns.Add("Name");
  		dataTable.Rows.Add(new object[] { "1", "A" });
  		dataTable.Rows.Add(new object[] { "2", "B" });
  		dataTable.Rows.Add(new object[] { "3", "C" });
  
  
  		var values = from val in dataTable.AsEnumerable() select val.Field<String>("Id") + "," + val.Field<String>("Name");
  
  		foreach (String value in values)
  		{
  			Response.Write(value);
  			Response.Write("</br>");
  		}

  Thanks,
  Karthick S
  • Edited by karthicks on Feb 28, 2012 08:44 AM
  • Edited by karthicks on Feb 28, 2012 10:39 AM
  • Edited by karthicks on Feb 28, 2012 10:40 AM
  • Marked as answer by decker dong - msft on Mar 05, 2012 12:40 AM
• • Reply
  

  abhijithmani...

  Member

  398 Points

  169 Posts

  Re: problem with linq in datatable.

  Feb 28, 2012 10:25 AM|LINK

  column names are dynamic in your case its static right???

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: problem with linq in datatable.

  Mar 01, 2012 12:23 AM|LINK

  abhijithmanipal

  column names are dynamic in your case its static right???

  Yes，you can also try to assign columns as what the sample gives you。Generally speaking it's fixed。