Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# LINQ DataTable
Hi Iam using vs2010. While I wish to select multiple columns from datatable and wish to convert it as DataTable, Iam not able to use the CopyToDataTable() statement.
 
Does anybody can give the right directions pls...
 
var MyVehListQry = (from DR1 in MyDataTable.AsEnumerable() where DR1.Field<string>("Field1") == MyValue select new { Field1 = DR1.Field<string>("Field1"), Field2 = DR1.Field<string>("Field2") }).ToList();
The below is not working....?
 
DataTable MyDtb2 = MyVehListQry.CopyToDataTable(); ??????????????
Thanks for the guidences...
Thanks & Regards
Paramu
Posted 26-Dec-12 23:06pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Your collection is not a DataRow IEnumerable collection, so CopyToDataTable is not appearing
Solution :
http://msdn.microsoft.com/en-us/library/bb669096.aspx[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Why so complicated ?)
 
Try like this,
 
DataTable newTable = oldTable.Copy();
newTable.Columns.Remove("ColumnName");
You remove the unwanted columns here.
 
Here is the best Solution for your Question:
 
DataTable dt = new DataTable();
string [] column = {"Column1", "Column2"};
dt = DTItem.DefaultView.ToTable("dd", false, column);
//DTItem is the Existing Table and "dd" is the temporary tablename, u give whatever U want
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

vmhjyhjtfyjhkjhkyuyrjrteyvyfe
DataTable dt = new DataTable();
string [] column = {"Column1", "Column2"};
dt = DTItem.DefaultView.ToTable("dd", false, column);
//DTItem is the Existing Table and "dd" is the temporary tablename, u give whatever U want
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

DataTable dt = new DataTable();
string [] column = {"Column1", "Column2"};
dt = DTItem.DefaultView.ToTable("dd", false, column);
//DTItem is the Existing Table and "dd" is the temporary tablename, u give whatever U want
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 279
1 Maciej Los 168
2 George Jonsson 154
3 Sarvesh Kumar Gupta 130
4 Dave Kreskowiak 130


Advertise | Privacy | Mobile
Web01 | 2.8.140709.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid