ASP.NET - List To DataTable

發表於 | 更新於 | 分類於 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
public DataTable ConvertToDataTable<T>(IList<T> data)
{
    PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(T));
    DataTable table = new DataTable();
    foreach ( PropertyDescriptor prop in properties )
    {
        table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
    }

    foreach ( T item in data )
    {
        DataRow row = table.NewRow();
        foreach ( PropertyDescriptor prop in properties )
        {
            row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
        }
        table.Rows.Add(row);
    }
    
    return table;
}
0%