ListをDataTableに変換する

忘れないように

sample.cs

public static DataTable ToDataTable<T>(this List<T> data)
    {
      var properties = TypeDescriptor.GetProperties(typeof(T));
      var table = new DataTable();
      foreach (PropertyDescriptor prop in properties)
        table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
      foreach (T item in data)
      {
        var row = table.NewRow();
        foreach (PropertyDescriptor prop in properties)
          row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
        table.Rows.Add(row);
      }
      return table;
    }