IList to datatable
来源:互联网 发布:mac 电源 爆 编辑:程序博客网 时间:2024/06/05 16:32
http://adofer.blog.163.com/blog/static/417381562009811354145/
通过 NHibernate 查询返回的表数据通常都是IList<T>,但在实际使用中有些数据控件在数据绑定上对IList的支持并不是很好,所以有时候将IList转换成DataSet还是有必要的。
// <summary>
/// Ilist<T> 转换成 DataSet
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static DataSet ConvertToDataSet<T>(IList<T> i_objlist)
{
if (i_objlist == null || i_objlist.Count <= 0)
{
return null;
}
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 i_objlist)
{
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);}
if (t == null)
{
continue;
}}
row = dt.NewRow();
for (int i = 0, j = myPropertyInfo.Length; i < j; i++)
{
System.Reflection.PropertyInfo piSystem.Reflection.PropertyInfo pi = myPropertyInfo[i];
string name = pi.Name;
if (dt.Columns[name] == null)
{
columncolumn = new DataColumn(name, pi.PropertyType);
dt.Columns.Add(column);
}dt.Columns.Add(column);
}
row[name] = pi.GetValue(t, null);
}}
dt.Rows.Add(row);
}
if (t == null)
{
continue;
}}
row = dt.NewRow();
for (int i = 0, j = myPropertyInfo.Length; i < j; i++)
{
System.Reflection.PropertyInfo piSystem.Reflection.PropertyInfo pi = myPropertyInfo[i];
string name = pi.Name;
if (dt.Columns[name] == null)
{
columncolumn = new DataColumn(name, pi.PropertyType);
dt.Columns.Add(column);
}dt.Columns.Add(column);
}
row[name] = pi.GetValue(t, null);
}}
dt.Rows.Add(row);
}
ds.Tables.Add(dt);
return ds;
}}
/// <summary>
/// Ilist<T> 转换成 DataTable
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static DataTable ConvertToDataTable<T>(IList<T> i_objlist)
{
if (i_objlist == null || i_objlist.Count <= 0)
{
return null;
}
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 i_objlist)
{
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);
}
return dt;
}
/// <summary>
/// Ilist 转换成 DataTable
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static DataTable ConvertToDataTable(IList i_objlist)
{
if (i_objlist == null || i_objlist.Count <= 0)
{
return null;
}
DataTable dt = new DataTable();
DataRow row;
System.Reflection.PropertyInfo[] myPropertyInfo = i_objlist[0].GetType().GetProperties();
foreach (System.Reflection.PropertyInfo pi in myPropertyInfo)
{
if (pi == null)
{
continue;
}
dt.Columns.Add(pi.Name, System.Type.GetType(pi.PropertyType.ToString()));
}
for (j = 0; j < i_objlist.Count; j++)
{
row = dt.NewRow();
for (int i = 0; i < myPropertyInfo.Length; i++)
{
System.Reflection.PropertyInfo pi = myPropertyInfo[i];
row[pi.Name] = pi.GetValue(t, null);
}
dt.Rows.Add(row);
}
return dt;
}
/// <summary>
/// Ilist 转换成 DataSet
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static DataSet ConvertToDataSet(IList i_objlist)
{
if (i_objlist == null || i_objlist.Count <= 0)
{
return null;
}
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow row;
System.Reflection.PropertyInfo[] myPropertyInfo = i_objlist[0].GetType().GetProperties();
foreach (System.Reflection.PropertyInfo pi in myPropertyInfo)
{
if (pi == null)
{
continue;
}
dt.Columns.Add(pi.Name, System.Type.GetType(pi.PropertyType.ToString()));
}
for (j = 0; j < i_objlist.Count; j++)
{
row = dt.NewRow();
for (int i = 0; i < myPropertyInfo.Length; i++)
{
System.Reflection.PropertyInfo pi = myPropertyInfo[i];
row[pi.Name] = pi.GetValue(t, null);
}
dt.Rows.Add(row);
}
ds.Tables.Add(dt);
return ds;
}
- IList to datatable
- DataTable还是IList
- IList转DataTable
- DataTable转换为IList
- DataTable转换成IList
- DataTable转换成IList
- IList 转DataTable
- DataTable转换成IList
- IList转换Datatable
- C# dataTable 转 IList 问题
- DataTable转换成IList(二)
- ILIST<t>转换成DataTable
- DataTable转换成IList 【转载】
- SqlDataReader to IList<T>
- 将 IList 或 IList 转换为Dataset或DataTable
- 将 IList 或 IList 转换为Dataset或DataTable
- 关于TypedDataTable 、 DataTable 、 ArrayList 、 IList 、Array
- 如何将IList转化为datatable
- linux内核分析笔记----定时器和时间管理
- Java文件创建--将原文件和可执行文件分开
- 离线内存中数据集dataset内部结构
- webgoat 中 Blind String SQL Injection 的 Python 编程解决
- 巧妙利用空白设计案例分享(多图)
- IList to datatable
- 一个branch prediction很好的例子
- 用 X3D 替代 VRML 2.0 的理由
- OK6410移植Boa过程中遇到的错误!
- Android网络通信之蓝牙教程实例汇总
- 聚合与组合的区别?
- 从汇编层面深度剖析C++虚函数 .
- 那些年Google公开的大数据领域论文
- A. Beautiful Matrix