Steve Sloka

See Andrew Conrad's code: blogs.msdn.com/.../science-project.aspx

A VB version can be found here: blogs.msdn.com/.../pathetic-plea-for-help.aspx

We also have C# and VB versions of this source code in the samples' source code of the LINQ in Action book (http://LinqInAction.net).

Here is the complete archive: linqinaction.net/.../entry1952.aspx

See the files DataSetLinqOperators.vb and ObjectShreder.vb in Chapter14.VB\Chapter14.

Note: In our version, we kept the original names of the query operators for clarity (ToDataTable and LoadSequence).

Link Listing - January 28, 2008

WPF How can I debug WPF bindings? [Via: Bea ] Code Camps South Florida Code Camp this weekend [Via:...

Here is the changed code, coz above code will run into error..IENUMERABLE varlist can not be enumerated more than once

public static class ConvertDataTable

   {

       public static DataTable ToADOTable<T>(this IEnumerable<T> varlist, CreateRowDelegate<T> fn)

       {

           DataTable dtReturn = new DataTable();

           // column names

           PropertyInfo[] oProps = null;

           // Could add a check to verify that there is an element 0

           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);

       }

       public delegate object[] CreateRowDelegate<T>(T t);

   }

Thanks Steve.  

I was looking for something clean that does just this.  

Can you give a brief sample of how this is called?

What if my datacontext is a datatable instead of a database? I have to append the asEnumerable()  method  to the datatable in the linq statement so that it doesn't throw an error on build.

The results contain rowerrors and fail.

Module ConvertDataTable

<System.Runtime.CompilerServices.Extension()> _

Public Function ToDataTable(Of T)(ByVal value As IEnumerable(Of T)) As DataTable

 Dim returnTable As New DataTable

 Dim firstRecord = value.First

 For Each pi In firstRecord.GetType.GetProperties

  returnTable.Columns.Add(pi.Name, pi.GetValue(firstRecord, Nothing).GetType)

 Next

 For Each result In value

  Dim nr = returnTable.NewRow

  For Each pi In result.GetType.GetProperties

   nr(pi.Name) = pi.GetValue(result, Nothing)

  Next

  returnTable.Rows.Add(nr)

 Next

 Return returnTable

End Function

End Module

I am getting a CTE of...

Error 1 The non-generic type 'System.Collections.IEnumerable' cannot be used with type arguments C:\Code\Team\Clear\Web\App_Code\Business\Components\ConvertDataTable.cs 20 45 C:\...\Web\

...when I try to compile...

...my using statements are...

using System;

using System.Data;

using System.Collections;

using System.Configuration;

using System.Linq;

using System.Linq.Expressions;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml;

using System.Xml.Linq;

...and the class is exactly as you pasted it above.

Ideas?

Thank you.

-- Mark Kamoski

These using statements work...

using System;

using System.Data;

using System.Collections;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using System.Collections.Specialized;

using System.Configuration;

using System.Linq;

using System.Reflection;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

awesome man. saved me a ton of work!

You Rock!  Code works great, and saved me a lot of heart ache!

This is just fantastic. For ASP.NET stuff when you want to bind to tabular information it is just perfect.

Thanks!

Thats great!

It's help me resolved my problem.

thanks