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?