How to populate Data to Dataset1 using Linq quary in C#

Question

Hi I am trying to set data to Dataset1 using Linq query But the data source how to give I don't know can anyone help me.. What I did.. 1. I had created Dataset1 and given some column names 2. In Form1 write a Linq query to assign data to Dataset1 table like below... DataClasses1DataContext DB = new DataClasses1DataContext(); var Quary1 = (from Gv in DB.Salses join gi in DB.Items on Gv.Item_ID equals gi.ID join Gp in DB.Item_Groups on Gv.Product_Group_ID equals Gp.ID where Gv.Sno == txsno.Text select new { ID = Gv.ID Group_Name = Gp.Item_Group_Name Item_Name = gi.Item_Name Qntity = Gv.Unit Price = Gv.Rate Total = Gv.Total_Amount gid = Gv.Product_Group_ID }).ToList(); now here I want to give Dataset1 Datasource = Quary1 How to give

Mukesh Nayak · Answer

Hi Wenkett I think we can create an generic extension method which will convert any list of object to datatable. public static DataTable ToDataTable ( this List dataList) { PropertyDescriptorCollection properties = TypeDescriptor.GetProperties( typeof (T)); DataTable dataTable = new DataTable(); foreach (PropertyDescriptor propDes in properties) { dataTable.Columns.Add(propDes.Name Nullable.GetUnderlyingType(propDes.PropertyType) ?? propDes.PropertyType); } foreach (T data in dataList) { DataRow row = dataTable.NewRow(); foreach (PropertyDescriptor prop in properties) { row[prop.Name] = prop.GetValue(data) ?? DBNull.Value; } dataTable.Rows.Add(row); } return dataTable; } Now we call the same as floowing : List usrDocList = (from usrDoc in dbContext.UserDocuments where usrDoc.UserID == new Guid( 5C335355-1E0A-4AAB-B2BA-98D2F39A846B ) select usrDoc).ToList(); ; DataTable dataTbl = new DataTable(); dataTbl = usrDocList.ToDataTable(); Finally you can add dtatable to dataset.