using System;

using System.Data;

using System.Collections.Generic;

using System.Reflection;

using System.Xml;

​

public class Program

{

    public static void Main()

    {       

        var people = new List<Person>();

        people.Add(new Person() { FirstName = "Bill", LastName = "Clinton", Age = 101 });

        people.Add(new Person() { FirstName = "John", LastName = "Doe", Age = 102 });

        people.Add(new Person() { FirstName = "George", LastName = "Washington", Age = 300 });  

        // convert people List type to dynamic type

        dynamic newPeople = people;

        // convert people dynamic type to DataTable

        /*DataTable dataTable = ToDataTable(newPeople);             

        Console.WriteLine("end of dynamic type to newPeople");

        Console.WriteLine(dataTable.Columns.Count);*/

        /***********************************************************************************/

        var dataParam = new List<DataParam>();

        dataParam.Add(new DataParam{ ParamName = "RegistryID", ParamType = "number", ParamValue = 1});

        dataParam.Add(new DataParam{ ParamName = "ShortDescription", ParamType = "string", ParamValue = "My brief description"});

        dataParam.Add(new DataParam{ ParamName = "QueryBuilderParam", ParamType = "object", ParamValue = new List<dynamic>() { 

            new QueryParam {

                QueryParamId = 1,

                QueryId = "",

                ParamName = "",

                ParamType = "",

                ParamLength = 0,

                ParamValue = "0047",

                ValueList = "",

                Required = false,

                ParamOrder = 0

            },

            new QueryParam {

                QueryParamId = 3,

                QueryId = "",

                ParamName = "",

                ParamType = "",

                ParamLength = 0,

                ParamValue = "VA",

                ValueList = "",

                Required = false,

                ParamOrder = 0

            }

        }});

        // convert people dynamic type to DataTable

        DataTable dataTableParam = ToDataTable(dataParam[2].ParamValue);                

        Console.WriteLine("end of dynamic type to dataTableParam");

        Console.WriteLine(dataTableParam.Columns.Count);

        // using extension to convert people dynamic type to DataTable

        // newPeople.ToDataTable();

        // Console.WriteLine("end of extension List to DataTable");

    }

    // DYNAMIC OBJECT TO DATATABLE

    public static DataTable ToDataTable(dynamic dynamicObject)

    {

        string colType = string.Empty,

               colName = string.Empty,

               colValue = string.Empty,

               colResult = string.Empty;

        // declare new DataTable

        DataTable dataTable = new DataTable();

        DataRow dataRow;

        foreach (var item in dynamicObject)

        {

            Type row = item.GetType();

            PropertyInfo[] rowPropInfo = row.GetProperties();

            Console.WriteLine("rowPropInfo is {0}", rowPropInfo.Length);

            // CREATE NEW DATATABLE ROW

            dataRow = dataTable.NewRow();

            colResult = "";

            // loop over object properties and create table columns

            foreach (var prop in rowPropInfo)

            {

                colType = prop.PropertyType.ToString();

                colName = prop.Name.ToString();

                switch (colType)

                {

                    case "System.Int16":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(Int16));

                        }

                        dataRow[colName] = Convert.ToInt16(prop.GetValue(item, null));

                        break;

                    case "System.Int32":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(Int32));

                        }

                        dataRow[colName] = Convert.ToInt32(prop.GetValue(item, null));

                        break;

                    case "System.Int64":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(Int64));

                        }

                        dataRow[colName] = Convert.ToInt64(prop.GetValue(item, null));

                        break;

                    case "System.Boolean":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(Boolean));

                        }

                        dataRow[colName] = Convert.ToBoolean(prop.GetValue(item, null));

                        break;

                    case "System.Decimal":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(Decimal));

                        }

                        dataRow[colName] = Convert.ToDecimal(prop.GetValue(item, null));

                        break;

                    case "System.Nullable`1[System.Decimal]":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(Decimal));

                        }

                        dataRow[colName] = string.IsNullOrEmpty(prop.GetValue(item, null).ToString()) ? (Decimal?)null : Convert.ToDecimal(prop.GetValue(item, null));

                        break;

                    case "System.DateTime":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(DateTime));

                        }

                        dataRow[colName] = Convert.ToDateTime(prop.GetValue(item, null));

                        break;

                    case "System.Nullable`1[System.DateTime]":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(DateTime));

                        }

                        dataRow[colName] = string.IsNullOrEmpty(prop.GetValue(item, null).ToString()) ? (DateTime?)null : Convert.ToDateTime(prop.GetValue(item, null));

                        break;

                    case "System.Char":

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(char));

                        }

                        dataRow[colName] = Convert.ToChar(prop.GetValue(item, null));

                        break;

                    default:

                        if (!dataTable.Columns.Contains(colName))

                        {

                            dataTable.Columns.Add(colName, typeof(string));

                        }

                        dataRow[colName] = prop.GetValue(item, null) == null ? string.Empty : prop.GetValue(item, null).ToString();

                        break;

                }

                colResult += string.Format("{1} {0} = ''; ", colName, colType);

            }

            Console.WriteLine(colResult);

            // ADD DataRow TO DataTable

            dataTable.Rows.Add(dataRow);

        }

        return dataTable;

    }

    public class Person {       

        public string FirstName { get;set; }

        public string LastName { get; set; }

        public int Age { get; set; }

    }

    public class DataParam

    {

        public string ParamName { get; set; }

        public string ParamType { get; set; }

        public object ParamValue { get; set; }

        public int ParamDirection { get; set; }

    }

    public class QueryParam 

    {

        public int QueryParamId { get; set; }

        public string QueryId { get; set; }

        public string ParamName { get; set; }

        public string ParamType { get; set; }

        public int ParamLength { get; set; }

        public string ParamValue { get; set; }

        public string ValueList { get; set; }

        public bool Required { get; set; }

        public int ParamOrder { get; set; }

    }

}

​

​

public static class Extension

{

    // LIST OBJECT TO DATATABLE

    public static DataTable ToDataTable<T>(this List<T> listObject)

    {

        dynamic dynamicObject = listObject;

        return ToDataTable(dynamicObject);

    }   

}

​

​

​