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 vote327 views1 answer
C# enum key value
C#
0 vote326 views1 answer
Access object property C#
C#
1 vote360 views1 answer
Httppostedfilebase in .net core 3.1
C#
29 votes321 views3 answers
Unity c# delay function
C#
0 vote361 views1 answer
C# webbrowser control append
C#
31 votes429 views3 answers
Raycasting in unity
C#Unity
0 vote323 views1 answer
Freeze scene unity
C#
0 vote329 views1 answer
Wpf textblock line break code behind
C#
0 vote339 views1 answer
List contains type c#
C#
1 vote364 views1 answer
PlayerInputManager.JoinPlayer(....)
C#