How to Fill Directly a DataTable using LINQ

[VenkataRamana Gali]

Hi all, i created database.dbml file along with table1, table2. now i wanted to fill result set of table1 into a DataTable (ex: select * from table1 where table1Id=100) please help me

Ramana

[Julianne_juju]

var result = (from myData in databaseDataContext.table1 where myData.table1Id = 100 select myData) Then you can convert result into your datatable. Here's an example how you can convert it: http://www.c-sharpcorner.com/UploadFile/VIMAL.LAKHERA/LINQResultsetToDatatable06242008042629AM/LINQResultsetToDatatable.aspx[^]

[Pete OHanlon]

I blogged about a DataSet/DataTable extension for Linq here[^].

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx