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

10 votes224 views3 answers
How to make a quit button in unity
C#
31 votes226 views4 answers
C# convert string to datetime any format
C#
0 vote260 views1 answer
How to make dobuble jump unity 2d
C#Unity
0 vote253 views1 answer
How to sign in with your unity id in unity hub
C#
0 vote271 views1 answer
Button color uwp c#
C#
0 vote231 views1 answer
How to write an if statement with two checkboxes in c#
C#
1 vote244 views1 answer
Danidev itch io
C#
0 vote279 views1 answer
Gridview column cell alignment form c#
C#
0 vote244 views1 answer
Ensure multiple variables not null c#
C#
3 votes322 views4 answers
Call python script from c#
C#