Convert a LINQ Query Resultset to a DataTable

Good code thank you

Thanks. It work for me. DataClasses1DataContext db = new DataClasses1DataContext(); //dataGridView1.DataSource = db.BoxSelectAll(); //Call a storeprocedul DataTable dt = LINQToDataTable(db.DocumentSelectAll().ToList()); dataGridView1.DataSource = dataTableDoc;

Please feel free to use it

Hi VIMAL LAKHERA, Thanks for sharing this code.. Its very useful. I would like to use this code in my commercial application. can i use it? looking for license terms.. Thanks, Gopinath

Thanks, if I want to fill pageddatasource with all table data, Could you please help

I got following error "Specified cast is not valid." my code is var groupbySort = from row in processNewData.AsEnumerable() group row by new { DueDate = row.Field<DateTime>("Duedate"), Familycode = row.Field<string>("Familycode") } into grp select new { Familycode=grp.Key.Familycode, DueDate=grp.Key.DueDate, PremiumSum=grp.Sum(r=>r.Field<decimal>("Premium")) }; DataTable output1 = LINQToDataTable(groupbySort);

I used your first method.It works just fine.Thnaks alot for a wonderfull code sinppet.

Great code, and very useful... Thks

Hi, there i m using your sample II example code. I m getting this error : Value cannot be null. Parameter name: query when i debug it line by line error comes at line IDbCommand cmd = ctx.GetCommand(query as IQueryable); here is my code.....as i have done some modification in there: public DataTable ToDataTable(System.Data.Linq.DataContext ctx, int id) { DataClasses1DataContext objData = new DataClasses1DataContext(); var q = from s in objData.employees where s.id == id select s; object query = new object(); query = q.ToList(); if (query == null) { throw new ArgumentNullException("query"); } IDbCommand cmd = ctx.GetCommand(query as IQueryable); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = (SqlCommand)cmd; DataTable dt = new DataTable("sd"); try { cmd.Connection.Open(); adapter.FillSchema(dt, SchemaType.Source); adapter.Fill(dt); } finally { cmd.Connection.Close(); } return dt; } and here is the way i call function: DataClasses1DataContext db = new DataClasses1DataContext(); DataTable dt = new DataTable(); dt = ToDataTable(db, Convert.ToInt32(e.CommandArgument.ToString())); please help!!!!!!!!

i am using store procedure in linq when it convert query to IQueryable. it is null. but why?

very usefull code. Thanks Rajesh

Thanks you guys for your comments. Mr. Vincent my god bless you and give you a nice heart in your next life

Thanks for the article. The LINQToDataTable function has been very helpful!

I think those functions most be included in .net freamwork.

Thanks for those ready to use functions.

Gr8 work... Saved me a lot of time!!

thank you so much. it is 2 days that i've been searching for a solution which be able to fill a datatable with linq to query resultset.but couldn't find a workable and nice solution. But don't you think that microsoft should predict and prevent it!!

Hi there, Do you have any method where, instead of using IQueryable in sample 2, I can use ISingleResult?

public DataTable SqlLinqToDataTable(DataContext context, IQueryable queryResult) { DataTable table = new DataTable(); SqlCommand cmd = (SqlCommand)context.GetCommand(queryResult); new SqlDataAdapter(cmd).Fill(table); return table; }

The Linq2Dataset dll extension has already been included in net framework 3.5, I can't see why you need to create something to convert linq result to DataTable