LINQ to DataSet – Data Binding

re: LINQ to DataSet – Data Binding

Jonathan Carter — Tue, 28 Aug 2007 05:55:52 GMT

Excellent post Erick. I look forward to seeing more specifics about the LinqDataView.

re: LINQ to DataSet – Data Binding

Ashraf ElSwify — Thu, 20 Sep 2007 01:19:11 GMT

Thanks a lot for the post. It was really great.

I have started to learn and read about data binding and forms in .Net 2.0. I also jumped with excitement to learn about Linq and specially Linq-to-Dataset and the only reason I was hoping for great and seamless integration of the latter with forms and data binding.

I will be waiting on more of your posts to around this topic.

LINQ to DataSet Data Binding – Introducing LinqDataView

ADO.NET, LINQ, DataSet and other fun .NET technology — Fri, 05 Oct 2007 23:24:05 GMT

It's long overview, but I finally was able to finish a few more posts on this series. Let me know if

LINQ to DataSet DataBinding

ADO.NET team blog — Fri, 12 Oct 2007 18:05:31 GMT

Interested in hearing more? Check out this great post by Erick Thompson our DataSet PM on his blog .

re: LINQ to DataSet – Data Binding

speed — Sat, 13 Oct 2007 06:17:22 GMT

did you do any speed tests between the various ways to see which would be most optmal?

Izindaba #14

From the software development trenches — Fri, 19 Oct 2007 07:52:50 GMT

Time for another weekly roundup of news that focuses on .NET, agile and general development content:

re: LINQ to DataSet – Data Binding

GMA Bill — Wed, 16 Jan 2008 23:06:49 GMT

CopyToDataTable or ToDataTable does not exist in the released version of VB9!!!

re: LINQ to DataSet – Data Binding

Howie — Wed, 30 Jul 2008 23:12:48 GMT

This page also gives a useful alternative way to adapt LINQ query results to a DataTable:

http://www.c-sharpcorner.com/UploadFile/VIMAL.LAKHERA/LINQResultsetToDatatable06242008042629AM/LINQResultsetToDatatable.aspx

sample copied here:

public static DataTable LINQToDataTable<T>(IEnumerable<T> varlist)

{

DataTable dtReturn = new DataTable();

// column names

PropertyInfo[] oProps = null;

if (varlist == null) return dtReturn;

foreach (T rec in varlist)

{

// Use reflection to get property names, to create table, Only first time, others

will follow

if (oProps == null)

{

oProps = ((Type)rec.GetType()).GetProperties();

foreach (PropertyInfo pi in oProps)

{

Type colType = pi.PropertyType;

if ((colType.IsGenericType) && (colType.GetGenericTypeDefinition()

==typeof(Nullable<>)))

{

colType = colType.GetGenericArguments()[0];

}

dtReturn.Columns.Add(new DataColumn(pi.Name, colType));

}

DataRow dr = dtReturn.NewRow();

foreach (PropertyInfo pi in oProps)

{

dr[pi.Name] = pi.GetValue(rec, null) == null ?DBNull.Value :pi.GetValue

(rec,null);

}

dtReturn.Rows.Add(dr);

}

return dtReturn;

}

---------------------------------------------------------------

Example: To use this method, just use the following code sample:

---------------------------------------------------------------

var vrCountry = from country in objEmpDataContext.CountryMaster

select new {country.CountryID,country.CountryName};

DataTable dt = LINQToDataTable(vrCountry);