DataTable转泛型集合

 public static IList<T> convertToList<T>(DataTable dt) where T : new()
    {
        List<T> ts=new List<T>();

        Type type = typeof(T);

        string tempName = string.Empty;

        foreach (DataRow dr in dt.Rows)
        {
            T t = new T();

            PropertyInfo[] propertys = t.GetType().GetProperties();

            foreach (PropertyInfo pi in propertys)
            {
                tempName = pi.Name;

                if (dt.Columns.Contains(tempName))
                {
                    if (!pi.CanWrite) continue;

                    object value = dr[tempName];

                    if (value != DBNull.Value)
                    {
                        pi.SetValue(t, value, null);
                    }
                }
            }

            ts.Add(t);
        }

        return ts;
    }