How do I transform a List into a DataSet?

by

You can do it through reflection and generics, inspecting the properties of the underlying type.

Consider this extension method that I use:

    public static DataTable ToDataTable<T>(this IEnumerable<T> collection)
    {
        DataTable dt = new DataTable("DataTable");
        Type t = typeof(T);
        PropertyInfo[] pia = t.GetProperties();

        //Inspect the properties and create the columns in the DataTable
        foreach (PropertyInfo pi in pia)
        {
            Type ColumnType = pi.PropertyType;
            if ((ColumnType.IsGenericType))
            {
                ColumnType = ColumnType.GetGenericArguments()[0];
            }
            dt.Columns.Add(pi.Name, ColumnType);
        }

        //Populate the data table
        foreach (T item in collection)
        {
            DataRow dr = dt.NewRow();
            dr.BeginEdit();
            foreach (PropertyInfo pi in pia)
            {
                if (pi.GetValue(item, null) != null)
                {
                    dr[pi.Name] = pi.GetValue(item, null);
                }
            }
            dr.EndEdit();
            dt.Rows.Add(dr);
        }
        return dt;
    }

More Related Contents:

  1. Find index of returned list result C#
  2. How do I clone a generic list in C#?
  3. Remove duplicates from a List in C#
  4. Check whether an array is a subset of another
  5. How to create List of open generic type of class?
  6. Remove items from one list in another
  7. A method to count occurrences in a list
  8. Select distinct using linq [duplicate]
  9. Getting all file names from a folder using C# [duplicate]
  10. Inheriting from List
  11. ICollection Vs List in Entity Framework
  12. Getting unique items from a list [duplicate]
  13. Fast way to convert a two dimensional array to a List ( one dimensional )
  14. Differences between IQueryable, List, IEnumerator?
  15. Class List Keeps Printing Out As Class Name In Console?
  16. Are 2 dimensional Lists possible in c#?
  17. Create list of variable type
  18. Check if all items are the same in a List
  19. How do I get a list of installed updates and hotfixes?
  20. Datatable vs Dataset
  21. How do I check if a given value is a generic list?
  22. Stored procedure return into DataSet in C# .Net
  23. Why is a SQL float different from a C# float
  24. Count property vs Count() method?
  25. How to Quickly Remove Items From a List
  26. Casting IEnumerable to List
  27. List.Except is not working
  28. Parallel.ForEach with adding to list
  29. What is the best way to check two List lists for equality in C#
  30. Eliminate consecutive duplicates of list elements

Leave a Comment