List of C# class objects to .NET DataTable

Here is the code snippet to convert a List of C# Objects to DataTable.

Enjoy.

Happy Coding.

Cheers
Adam



public DataTable GetDataTable<T>(IList<T> list, string tableName)

        {

            PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(T));

            DataTable table = new DataTable(tableName);

            for (int i = 0; i < props.Count; i++)

            {

                PropertyDescriptor prop = props[i];

                table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);

            }

            object[] values = new object[props.Count];

            foreach (T item in list)

            {

                for (int i = 0; i < values.Length; i++)

                    values[i] = props[i].GetValue(item) ?? DBNull.Value;

                table.Rows.Add(values);

            }

            return table;

        }