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;
}