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