SqlDataReader 结果集 转 DataTable

	private SqlConnection conn = null;

    string str1 = "Data Source=.;Initial Catalog=liux_test;user=sa;password=sa123;";

    public SqlConnection Getconn()
    {
        if (conn == null)
        {
            return this.conn = new SqlConnection(str1);
        }
        else
        {
            return this.conn;
        }
    }

    public DataTable GetAll(int id,int s)
    {
        using (SqlConnection conn = Getconn())
        {
            conn.Open();
            SqlCommand comm = conn.CreateCommand();
            comm.CommandText = "GetTypeById";
            comm.CommandType = CommandType.StoredProcedure;
            comm.Parameters.Add(new SqlParameter("type_id", id));
            comm.Parameters.Add(new SqlParameter("type_s", s));
            SqlDataReader dr = comm.ExecuteReader();
            return DRToDT(dr);
            //SqlDataAdapter dd = new SqlDataAdapter(comm);
            //DataTable dt = new DataTable();
            //dd.Fill(dt);
            //return dt;
        }
    }
    
	private static DataTable DRToDT(SqlDataReader dataReader)
    {
        ///定义DataTable  
        DataTable datatable = new DataTable();

        try
        {    ///动态添加表的数据列  
            for (int i = 0; i < dataReader.FieldCount; i++)
            {
                DataColumn myDataColumn = new DataColumn();
                myDataColumn.DataType = dataReader.GetFieldType(i);
                myDataColumn.ColumnName = dataReader.GetName(i);
                datatable.Columns.Add(myDataColumn);
            }
            ///添加表的数据  
            while (dataReader.Read())
            {
                DataRow myDataRow = datatable.NewRow();
                for (int i = 0; i < dataReader.FieldCount; i++)
                {
                    myDataRow[i] = dataReader[i].ToString();
                }
                datatable.Rows.Add(myDataRow);
                myDataRow = null;
            }
            ///关闭数据读取器  
            dataReader.Close();
            return datatable;
        }
        catch (Exception ex)
        {
            ///抛出类型转换错误  
            //SystemError.CreateErrorLog(ex.Message);  
            throw new Exception(ex.Message, ex);
        }
    }