c# 存储过程的调用

 try
            {
                Hashtable item = HttpContext.Current.Application["hbm"] as Hashtable;
                string sr = string.Concat(item["hibernate.connection.connection_waterString"]);
                SqlConnection conn = new SqlConnection(sr);
                SqlCommand sqlCommand = new SqlCommand();

                //CHECKMONTH存储过程名称
                SqlParameter[] sqlParameter = new SqlParameter[] { new SqlParameter("@CHECKMONTH", str) };

                            
            PrepareCommand(sqlCommand, conn, null, CommandType.StoredProcedure, "PROC_CHECK_RATE", sqlParameter);
                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                try
                {
                    DataSet dataSet1 = new DataSet();
                    sqlDataAdapter.Fill(dataSet1);
                    conn.Close();
                    sqlCommand.Parameters.Clear();
                    dataSet = dataSet1;
                    this.Bind(dataSet, this.rpt);
                }
                finally
                {
                    if (sqlDataAdapter != null)
                    {
                        ((IDisposable)sqlDataAdapter).Dispose();
                    }
                }
            }
            catch (SqlException sqlException)
            {
                throw sqlException;
            }