Fill dataset with list c#

public class ListtoDataTableConverter
{
    public DataTable ToDataTable<T>(List<T> items)
    {
        DataTable dataTable = new DataTable(typeof(T).Name);
        //Get all the properties
        PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
        foreach (PropertyInfo prop in Props)
        {
            //Setting column names as Property names
            dataTable.Columns.Add(prop.Name);
        }
        foreach (T item in items)
        {
            var values = new object[Props.Length];
            for (int i = 0; i < Props.Length; i++)
            {
                //inserting property values to datatable rows
                values[i] = Props[i].GetValue(item, null);
            }
            dataTable.Rows.Add(values);
        }
        //put a breakpoint here and check datatable
        return dataTable;
    }
}

Source: c-sharpcorner.com

Similar codes

0 vote122 views2 answers
1.1 0da14962afa287e5ba55c7d30c902392.cloudfront.net w
C#
0 vote126 views1 answer
Ef core unique index
C#
0 vote129 views1 answer
How to minimum text length in textbox in c#
C#
0 vote141 views1 answer
Wpf binding ancestor codebehind
C#
0 vote80 views1 answer
Hwo to prevent rotation after hitting an object in unity
C#
7 votes153 views1 answer
For loop unity
C#Unity
0 vote133 views1 answer
T SQL Format GetDate()
C#
0 vote206 views1 answer
How to detach the camera from the player after death unity
C#Unity
25 votes165 views3 answers
If get key down unity
C#Unity
1 vote159 views2 answers
C# string to binary
C#