Click here to Skip to main content
11,584,612 members (63,159 online)
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 430
1 Sergey Alexandrovich Kryukov 367
2 Dave Kreskowiak 260
3 Richard Deeming 220
4 virusstorm 194
0 OriginalGriff 1,703
1 Sergey Alexandrovich Kryukov 1,267
2 Abhinav S 711
3 Dave Kreskowiak 687
4 Suvendu Shekhar Giri 568


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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100