C # DataTable conversion to an entity class object instance

public class User {public         int ID {get; set;}         public string Name {get; set;}} Corresponding database table://user//field: ID, Name

Then you may need to write a method that transforms the DataTable into a solid object, which facilitates datatable.rows to get and populate.

Here is a general method I wrote, Share + record, easy to copy directly later ~

private static list<t> tabletoentity<t> (DataTable dt) where T:class,     New () {Type type = typeof (T);     list<t> list = new list<t> (); foreach (DataRow row in dt. Rows) {propertyinfo[] Parray = type.         GetProperties ();         t entity = new T (); foreach (PropertyInfo p in Parray) {if (Row[p.name] is Int64) {P.setvalu                 E (Entity, Convert.ToInt32 (Row[p.name]), NULL);             Continue         } p.setvalue (Entity, Row[p.name], NULL); } list.     ADD (entity); } return list; }//Call:list<user> userlist = tabletoentity<user> (yourdatatable);