How to Convert Linq Query into DataTable

Question

hello guys once again.

i have an problem in this code i wanna cast linq query into datatable but its giving error..
My Code is below:

var searchData = from search in context.PersonInformations

where search.p_ID == Convert.ToInt32(txtPId.Text)

select search;
DataTable dt = ((DataTable)searchData);

Reply Soon ...

Thanks .

Soft Corner · Answer

Hi Faisal, If you have to bind linq query data to DataGridView then i have one e.g , try this DataClasses1DataContext db = new DataClasses1DataContext(); var custQuery = from cust in db.schoolinfos select cust; BindingSource bs = new BindingSource(); bs.DataSource = custQuery; DataGridView1.DataSource = bs; and the requirement you are asking , m not sure with it but look it at MSDN article

kamal jasuja · Answer

use this solution to getting the result becouse another result isn't solution for this question. public DataSet ViewDesignation() { try { using (DataClassesDataContext db = new DataClassesDataContext()) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataRow dr; var result = (from Desig in db.tblDesignations select Desig).AsEnumerable(); if (result.Any()) { for (int i = 0; i { if (dt.Rows.Count >= 1) { dr = dt.NewRow(); dr["DesignationId"] = result.ToList()[i].DesignationId; dr["DesignationNm"] = result.ToList()[i].DesignationNm; dt.Rows.Add(dr); } else { dr = dt.NewRow(); DataColumn dtcolumn = new DataColumn(); dtcolumn = new DataColumn(); dtcolumn.DataType = Type.GetType("System.Int32"); dtcolumn.ColumnName = "DesignationId"; dt.Columns.Add(dtcolumn); dtcolumn = new DataColumn(); dtcolumn.DataType = Type.GetType("System.String"); dtcolumn.ColumnName = "DesignationNm"; dt.Columns.Add(dtcolumn); dr["DesignationId"] = result.ToList()[i].DesignationId; dr["DesignationNm"] = result.ToList()[i].DesignationNm; dt.Rows.Add(dr); } } ds.Tables.Add(dt); } return ds; } } catch { throw; } finally { } }

Raja Krishnamurthy · Answer

You can use CopyToDataTable() like this: DataTable dt = searchData.CopyToDataTable(); Check out this link for more information. Update: Just realized that it is the same link as Shrikant (+1). HTH

Suthish Nair · Answer

what error its giving?