www.pudn.com > UDS1.1_51aspx.rar > Tool.cs

using System; 
using System.Data; 
using System.Data.SqlClient; 
using System.Collections; 
 
namespace UDS.Components 
{ 
	/// 
 
	/// 常用工具函数类 
	/// 
 
	public class Tools 
	{ 
	 
		#region 将DataReader 转为 DataTable 
		/// 
 
		/// 将DataReader 转为 DataTable 
		/// 
 
		/// DataReader 
		public static DataTable ConvertDataReaderToDataTable(SqlDataReader dataReader) 
		{ 
			DataTable datatable = new DataTable(); 
			DataTable schemaTable = dataReader.GetSchemaTable(); 
			//动态添加列 
			try 
			{ 
			 
				foreach(DataRow myRow in schemaTable.Rows) 
				{ 
					DataColumn myDataColumn = new DataColumn(); 
					myDataColumn.DataType	= myRow.GetType(); 
					myDataColumn.ColumnName = myRow[0].ToString(); 
					datatable.Columns.Add(myDataColumn); 
				} 
				//添加数据 
				while(dataReader.Read()) 
				{ 
					DataRow myDataRow = datatable.NewRow(); 
					for(int i=0;i