现在的位置: 首页 > 综合 > 正文

完整的DataTable和list转换 老外写的(转)

2013年03月25日 ⁄ 综合 ⁄ 共 3459字 ⁄ 字号 评论关闭

转自http://blog.csdn.net/educast/archive/2010/01/25/5256137.aspx

public class CollectionHelper  
{  
    private CollectionHelper()  
    {  
    }  
 
    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);  
    }  
 
    public static T CreateItem<T>(DataRow row)  
    {  
        T obj = default(T);  
        if (row != null)  
        {  
            obj = Activator.CreateInstance<T>();  
 
            foreach (DataColumn column in row.Table.Columns)  
            {  
                PropertyInfo prop = obj.GetType().GetProperty(column.ColumnName);  
                try 
                {  
                    object value = row[column.ColumnName];  
                    prop.SetValue(obj, value, null);  
                }  
                catch 
                {  
                    // You can log something here  
                    throw;  
                }  
            }  
        }  
 
        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;  
    }  
}  
 
 
To see the full code in action, check this sample out:  
 
public class MyClass  
{  
    public static void Main()  
    {  
        List<Customer> customers = new List<Customer>();  
 
        for (int i = 0; i < 10; i++)  
        {  
            Customer c = new Customer();  
            c.Id = i;  
            c.Name = "Customer " + i.ToString();  
 
            customers.Add(c);  
        }  
 
        DataTable table = CollectionHelper.ConvertTo<Customer>(customers);  
 
        foreach (DataRow row in table.Rows)  
        {  
            Console.WriteLine("Customer");  
            Console.WriteLine("---------------");  
 
            foreach (DataColumn column in table.Columns)  
            {  
                object value = row[column.ColumnName];  
                Console.WriteLine("{0}: {1}", column.ColumnName, value);  
            }  
 
            Console.WriteLine();  
        }  
 
        RL();  
    } 
 
    #region Helper methods  
 
    private static void WL(object text, params object[] args)  
    {  
        Console.WriteLine(text.ToString(), args);  
    }  
 
    private static void RL()  
    {  
        Console.ReadLine();  
    }  
 
    private static void Break()  
    {  
        System.Diagnostics.Debugger.Break();  
    } 
 
    #endregion  
}

抱歉!评论已关闭.