SqlDataReader转成DataTable

SqlDataReader转成DataTable

<script type="text/javascript"> var $tag='校园生活'; </script>

/// <summary>
    /// SqlDataReader转成DataTable实现方法
    /// </summary>
    /// <param name="strSql">Sql语句</param>
    /// <returns></returns>
    protected DataTable DataReaderToDataTable(string strSql)
    {
        string connstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(connstr);
        SqlCommand sqlComm = new SqlCommand(strSql, sqlConn);
        SqlDataReader dataReader = null;
        DataTable dtReturn = null;
        object[] value = null;
        try
        {
            sqlComm.Connection.Open();
            dataReader = sqlComm.ExecuteReader();

            if (dataReader.HasRows)
            {
                dtReturn = CreateTableBySchemaTable(dataReader.GetSchemaTable());

                value = new object[dataReader.FieldCount];

                while (dataReader.Read())
                {
                    dataReader.GetValues(value);
                    dtReturn.LoadDataRow(value, true);
                }

                value = null;
            }

        }
        catch (Exception err)
        {}
        finally
        {
            dataReader.Close();
            sqlComm.Connection.Close();
            sqlComm.Dispose();
        }
        return dtReturn;

    }
   
    protected DataTable CreateTableBySchemaTable(DataTable pSchemaTable)
    {
        DataTable dtReturn = new DataTable();
        DataColumn dc = null;
        DataRow dr = null;

        for (int i = 0; i < pSchemaTable.Rows.Count; i++)
        {
            dr = pSchemaTable.Rows[i];
            dc = new DataColumn(dr["ColumnName"].ToString(), dr["DataType"] as Type);
            dtReturn.Columns.Add(dc);
        }

        dr = null;
        dc = null;

        return dtReturn;
    }