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