public static DataSet QueryScrapReport(DateTime beginDate, DateTime endDate)
{
DataSet dataSet = new CarsMaintenance.Reports.ScrapDataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
{
try
{
conn.Open();
string sql = string.Format(sqlScrapReport, beginDate, endDate);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables[0]);
}
//catch (Exception e)
//{
//}
finally
{
conn.Close();
}
}
return(dataSet);
}
public static DataSet QueryScrapReport(DateTime beginDate, DateTime endDate)
{
DataSet dataSet = new CarsMaintenance.Reports.ScrapDataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
{
try
{
conn.Open();
string sql = string.Format(sqlScrapReport, beginDate, endDate);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables[0]);
}
//catch (Exception e)
//{
//}
finally
{
conn.Close();
}
}
return dataSet;
}