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

5 votes210 views1 answer
Load prefab in script unity
C#Unity
0 vote168 views2 answers
String parameter too long.' c#
C#
0 vote192 views1 answer
OrElseThrow
C#
0 vote186 views1 answer
How to have referecne to script in unity
C#Unity
1 vote171 views1 answer
How to center text in console application
C#
1 vote177 views1 answer
How to write web service for API in c#
C#
1 vote202 views2 answers
Delegate unity
C#
2 votes193 views1 answer
Json ignore property c#
C#
0 vote181 views1 answer
Subquery in LInQ EF Core C#
C#
0 vote171 views1 answer
Change image of button c#
C#