将list<>数据填充到Dataset里

publicstatic DataSet ConvertToDataSet<T>(IList<T> list)
    {
        if (list ==null|| list.Count <=0)
        {
            returnnull;
        }
        DataSet ds =new DataSet();
        DataTable dt =new DataTable(typeof(T).Name);
        DataColumn column;
        DataRow row;

        System.Reflection.PropertyInfo[] myPropertyInfo =typeof(T).GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance);
        foreach (T t in list)
        {
            if (t ==null)
            {
                continue;
            }
            row = dt.NewRow();
            for (int i =0, j = myPropertyInfo.Length; i < j; i++)
            {
                System.Reflection.PropertyInfo pi = myPropertyInfo[i];
                string name = pi.Name;
                if (dt.Columns[name] ==null)
                {
                    column =new DataColumn(name, pi.PropertyType);
                    dt.Columns.Add(column);
                }
                row[name] = pi.GetValue(t, null);
            }
            dt.Rows.Add(row);
        }
        ds.Tables.Add(dt);
        return ds;
    }
}

 

posted @ 2015-05-29 15:34  @追&梦ぅかづ  阅读(413)  评论(0编辑  收藏  举报