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

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...

now here I want to give Dataset1 Datasource = Quary1

How to give

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 :

Finally you can add dtatable to dataset.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.