使用擴充方法將Linq資料集合轉成DataTable

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

static class IQueryableExtension { public static DataTable ToDataTable<T>(this IQueryable<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; } }