C# DataTable and Model Transfer Example Code

/// <summary>
 /// Entity conversion auxiliary class /// </summary>
 public class ModelConvertHelper<T> where T : new()
 {
  /// <summary>
  /// List generic conversion DataTable.  /// </summary>
  public DataTable ListToDataTable<T>(List<T> items)
  {
   var tb = new DataTable(typeof(T).Name);

   PropertyInfo[] props = typeof(T).GetProperties( | );

   foreach (PropertyInfo prop in props)
   {
    Type t = GetCoreType();
    (, t);
   }

   foreach (T item in items)
   {
    var values = new object[];

    for (int i = 0; i < ; i++)
    {
     values[i] = props[i].GetValue(item, null);
    }

    (values);
   }

   return tb;
  }

  /// <summary>
  /// model conversion DataTable  /// </summary>
  /// <typeparam name="T"></typeparam>
  /// <param name="items"></param>
  /// <returns></returns>
  public DataTable ModelToDataTable<T>(T items)
  {
   var tb = new DataTable(typeof(T).Name);

   PropertyInfo[] props = typeof(T).GetProperties( | );

   foreach (PropertyInfo prop in props)
   {
    Type t = GetCoreType();
    (, t);
   }


   var values = new object[];

   for (int i = 0; i < ; i++)
   {
    values[i] = props[i].GetValue(items, null);
   }

   (values);


   return tb;
  }

  /// <summary>
  /// Determine of specified type is nullable
  /// </summary>
  public static bool IsNullable(Type t)
  {
   return ! || ( && () == typeof(Nullable<>));
  }

  /// <summary>
  /// Return underlying type if type is Nullable otherwise return the type
  /// </summary>
  public static Type GetCoreType(Type t)
  {
   if (t != null && IsNullable(t))
   {
    if (!)
    {
     return t;
    }
    else
    {
     return (t);
    }
   }
   else
   {
    return t;
   }
  }

  /// <summary>
  /// DataTable converts generic List  /// </summary>
  /// <param name="dt"></param>
  /// <returns></returns>
  public static List<T> DataTableToList(DataTable dt)
  {
   // Define the collection   List<T> ts = new List<T>();

   // Get the type of this model   Type type = typeof(T);
   string tempName = "";
   foreach (DataRow dr in )
   {
    T t = new T();
    // Get the public properties of this model    PropertyInfo[] propertys = ().GetProperties();
    foreach (PropertyInfo pi in propertys)
    {
     tempName = ; // Check whether DataTable contains this column
     if ((tempName))
     {
      // Determine whether this property has a Setter      if (!) continue;

      object value = dr[tempName];
      if (value != )
       (t, value, null);
     }
    }
    (t);
   }
   return ts;
  }


  public static T DataTableToModel(DataTable dt)
  {
   // Define entities   T t = new T();

   // Get the type of this model   Type type = typeof(T);
   string tempName = "";

   foreach (DataRow dr in )
   {

    // Get the public properties of this model    PropertyInfo[] propertys = ().GetProperties();
    foreach (PropertyInfo pi in propertys)
    {
     tempName = ; // Check whether DataTable contains this column
     if ((tempName))
     {
      // Determine whether this property has a Setter      if (!) continue;

      object value = dr[tempName];
      if (value != )
       (t, value, null);
     }
    }
    break;
   }
   return t;
  }
 }