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 27-Dec-12 0:06am
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 Sergey Alexandrovich Kryukov 504
1 Maciej Los 349
2 Kornfeld Eliyahu Peter 325
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,303
1 DamithSL 4,764
2 Maciej Los 4,306
3 Kornfeld Eliyahu Peter 3,914
4 Sergey Alexandrovich Kryukov 3,538


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2014
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