public DsReports.SalesInvListDataTable GetSalesReportByDate(DateTime d1,DateTime d2) { var ds = new DsReports().SalesInvList; try { var ta = new DsReportsTableAdapters.taSalesInvList { Connection = { ConnectionString = _constr } }; ta.FillByTrandate(ds, false, d1, d2); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return ds; }
public DsReports.SalesInvListDataTable GetSalesReport(string invno = null) { var ta = new DsReportsTableAdapters.taSalesInvList {Connection = {ConnectionString = _constr}}; var ds = new DsReports().SalesInvList; if (invno == null) ta.Fill(ds, false); else { ta.FillBySalesInv(ds, true, false, invno); } return ds; }