通过 NHibernate 查询返回的表数据通常都是 IList<T>,但在实际使用中有些数据控件在数据绑定上对IList的支持并不是很好,所以有时候将IList转换成DataSet还是有必要的。
代码如下:
ContractedBlock.gif ExpandedBlockStart.gif
None.gifusing System;
None.gif
using System.Data;
    using  System.Collections.Generic;
None.gif
None.gif
public class NHibernateHelper
ExpandedBlockStart.gifContractedBlock.gif
dot.gif{
ExpandedSubBlockStart.gifContractedSubBlock.gif    
/**//// <summary>
InBlock.gif    
/// Ilist<T> 转换成 DataSet
InBlock.gif    
/// </summary>
InBlock.gif    
/// <param name="list"></param>
ExpandedSubBlockEnd.gif    
/// <returns></returns>

InBlock.gif    public static DataSet ConvertToDataSet<T>(IList<T> list)
ExpandedSubBlockStart.gifContractedSubBlock.gif    
dot.gif{
InBlock.gif        
if (list == null || list.Count <= 0)
ExpandedSubBlockStart.gifContractedSubBlock.gif        
dot.gif{
InBlock.gif            
return null;
ExpandedSubBlockEnd.gif        }

InBlock.gif
InBlock.gif        DataSet ds 
= new DataSet();
InBlock.gif        DataTable dt 
= new DataTable(typeof(T).Name);
InBlock.gif        DataColumn column;
InBlock.gif        DataRow row;
InBlock.gif
InBlock.gif        System.Reflection.PropertyInfo[] myPropertyInfo 
= typeof(T).GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance);
InBlock.gif
InBlock.gif        
foreach (T t in list)
ExpandedSubBlockStart.gifContractedSubBlock.gif        
dot.gif{
InBlock.gif            
if (t == null)
ExpandedSubBlockStart.gifContractedSubBlock.gif            
dot.gif{
InBlock.gif                
continue;
ExpandedSubBlockEnd.gif            }

InBlock.gif
InBlock.gif            row 
= dt.NewRow();
InBlock.gif
InBlock.gif            
for (int i = 0, j = myPropertyInfo.Length; i < j; i++)
ExpandedSubBlockStart.gifContractedSubBlock.gif            
dot.gif{
InBlock.gif                System.Reflection.PropertyInfo pi 
= myPropertyInfo[i];
InBlock.gif
InBlock.gif                
string name = pi.Name;
InBlock.gif
InBlock.gif                
if (dt.Columns[name] == null)
ExpandedSubBlockStart.gifContractedSubBlock.gif                
dot.gif{
InBlock.gif                    column 
= new DataColumn(name, pi.PropertyType);
InBlock.gif                    dt.Columns.Add(column);
ExpandedSubBlockEnd.gif                }

InBlock.gif
InBlock.gif                row[name] 
= pi.GetValue(t, null);
ExpandedSubBlockEnd.gif            }

InBlock.gif
InBlock.gif            dt.Rows.Add(row);
ExpandedSubBlockEnd.gif        }

InBlock.gif
InBlock.gif        ds.Tables.Add(dt);
InBlock.gif
InBlock.gif        
return ds;
ExpandedSubBlockEnd.gif    }

InBlock.gif
ExpandedBlockEnd.gif}