return reader;
        }

        public static SqlDataReader ExecuteReader(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
        ...{
            SqlConnection conn = new SqlConnection(connStr);
            SqlCommand comm = new SqlCommand(commStr, conn);
            comm.CommandType = commandType;

            for (int i = 0; i < commandParameters.Length; i++)
                comm.Parameters.Add(commandParameters[i]);

            conn.Open();
            SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection);

            return reader;
        }
        #endregion

        SqlDataSetAdapter的两个重载#region SqlDataSetAdapter的两个重载
        public static DataSet SqlDataSetAdapter(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
        ...{
            SqlConnection conn = new SqlConnection(connStr);
            SqlCommand comm = new SqlCommand(commStr, conn);
            comm.CommandType = commandType;

            for (int i = 0; i < commandParameters.Length; i++)
                comm.Parameters.Add(commandParameters[i]);

            SqlDataAdapter sda = new SqlDataAdapter(comm);
            DataSet ds = new DataSet();

            sda.Fill(ds);
            return ds;
        }

        public static DataSet SqlDataSetAdapter(string connStr, CommandType commandType, string commStr)
        ...{
            SqlConnection conn = new SqlConnection(connStr);
            SqlCommand comm = new SqlCommand(commStr, conn);
            comm.CommandType = commandType;