DataTables List互相转换的实现类示例

public static class datatablehelper
    {
        public static datatable convertto<t>(ilist<t> list)
        {
            datatable table = createtable<t>();
            type entitytype = typeof(t);
            propertydescriptorcollection properties = typedescriptor.getproperties(entitytype);
            foreach (t item in list)
            {
                datarow row = table.newrow();
                foreach (propertydescriptor prop in properties)
                    row[prop.name] = prop.getvalue(item);
                table.rows.add(row);
            }
            return table;
        }

        public static ilist<t> convertto<t>(ilist<datarow> rows)
        {
            ilist<t> list = null;
            if (rows != null)
            {
                list = new list<t>();
                foreach (datarow row in rows)
                {
                    t item = createitem<t>(row);
                    list.add(item);
                }
            }
            return list;
        }

        public static ilist<t> convertto<t>(datatable table)
        {
            if (table == null)
                return null;

            list<datarow> rows = new list<datarow>();
            foreach (datarow row in table.rows)
                rows.add(row);

            return convertto<t>(rows);
        }

        //convert datarow into t object
        public static t createitem<t>(datarow row)
        {
            string columnname;
            t obj = default(t);
            if (row != null)
            {
                obj = activator.createinstance<t>();
                foreach (datacolumn column in row.table.columns)
                {
                    columnname = column.columnname;
                    //get property with same columnname
                    propertyinfo prop = obj.gettype().getproperty(columnname);
                    try
                    {
                        //get value for the column
                        object value = (row[columnname].gettype() == typeof(dbnull))
                        ? null : row[columnname];
                        //set property value
                        if (prop.canwrite)    //判断其是否可写
                            prop.setvalue(obj, value, null);
                    }
                    catch
                    {
                        throw;
                        //catch whatever here
                    }
                }
            }
            return obj;
        }

        public static datatable createtable<t>()
        {
            type entitytype = typeof(t);
            datatable table = new datatable(entitytype.name);
            propertydescriptorcollection properties = typedescriptor.getproperties(entitytype);

            foreach (propertydescriptor prop in properties)
                table.columns.add(prop.name, prop.propertytype);

            return table;
        }
    }