private void ActivityLogReports_Load(object sender, EventArgs e) { Stores stor = new Stores(); DataTable dtStor = stor.GetActiveStores(); DataRow dtStorRow = dtStor.NewRow(); dtStorRow["ID"] = "0"; dtStorRow["StoreName"] = "All Stores"; dtStor.Rows.InsertAt(dtStorRow, 0); cboStores.Properties.DataSource = dtStor; DateTime dateFrom = dtFrom.Value; DateTime dateTo = dtTo.Value; Supplier sp = new Supplier(); DataTable dtsupp = sp.GetActiveSuppliers(); DataRow dtrsupp = dtsupp.NewRow(); dtrsupp["ID"] = "0"; dtrsupp["CompanyName"] = "All Suppliers"; dtsupp.Rows.InsertAt(dtrsupp, 0); lkSupplier.Properties.DataSource = dtsupp; lkSupplierT.Properties.DataSource = dtsupp; ReceivingUnits ru = new ReceivingUnits(); DataTable dtru = ru.GetAllApplicableDU(); DataRow dtrru = dtru.NewRow(); dtrru["ID"] = "0"; dtrru["Name"] = "All Receiving Units"; dtru.Rows.InsertAt(dtrru, 0); lklocation.Properties.DataSource = dtru; lklocationT.Properties.DataSource = dtru; dtRec = rec.GetAllReceiveByDateRange(dateFrom, dateTo); dtiss = iss.GetIssuedByDateRange(dateFrom, dateTo); gridReceives.DataSource = dtRec; gridIssues.DataSource = dtiss; grdViewIssued.ActiveFilterString = String.Format("Quantity<>0"); grdViewIssued.Columns["InternalDrugCode"].Visible = grdViewReceive.Columns["InternalDrugCode"].Visible = false; grdTotalReceived.DataSource = rec.GetTotalReceiveByDateRange(dateFrom, dateTo, 0); //grdVwTotalReceived.ActiveFilterString = String.Format("totalQuantity<>0"); grdTotalIssued.DataSource = iss.GetTotalIssuedByDateRange(dateFrom, dateTo, 0); grdVwTotalIssued.ActiveFilterString = String.Format("TotalQuantity<>0"); }