Populate DataTable from db using Linq to entities

Question

1.00/5 (2 votes)

See more:

I'm developping a windows form application with ADO .Net entity data model , how can i fill a DataTable

C#

DataTable dt = new DataTable()

from the data base using dataBaseEntities?
here is my query:

SQL

from data in db.Sources
where data.IdTheme==idtheme
select data.Url;

Posted 19-May-13 15:26pm

Nnorss

Updated 19-May-13 20:33pm

v9

Add a Solution

1 solution

Add a Solution

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

Guirec · Accepted Answer · 2013-05-19T21:07:00

Solution 1

Is there any specific reason why you would want to transform your IEnumerable<string> into a DataTable?

Anyway you can probably do something like this (untested):

C#

var queryResult = from data in db.Sources
where data.IdTheme==idtheme
select data.Url;


var dt = new DataTable();
dt.Columns.Add("Url");
foreach (var url in queryResult)
{
    var newRow = dt.NewRow();
    newRow["Url"] = url;
    dt.Rows.Add(newRow);
}

Posted 19-May-13 21:07pm

Guirec

Comments

Nnorss 20-May-13 3:13am

Thank you Guirec! I want to put the results into a listBox thats why i used a dataTable.

Guirec 20-May-13 3:15am

then you don't need to transform into a datatable...
you just have to bind your result to the listBox.

Populate DataTable from db using Linq to entities

1 solution

Solution 1

Add your solution here

Preview 0

Populate DataTable from db using Linq to entities

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us