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