private void Load_PromoProducts_DataGrid() { dgvDataTo_Initialize(); if (txt_PromoID.Text != "") { DataAccessPOS dbPOS = new DataAccessPOS(); int iSelectedPromoId = Convert.ToInt32(txt_PromoID.Text); if (iSelectedPromoId > 0) { pprods = dbPOS.Get_PromoProducts_By_PromoId(iSelectedPromoId); lbl_SelectedProds.Text = "Selected Products ( " + pprods.Count.ToString() + " )"; if (pprods.Count > 0) { foreach (var pprod in pprods) { prods = dbPOS.Get_Product_By_ID(pprod.ProdId); if (prods.Count > 0) { this.dgvDataTo.Rows.Add(new String[] { prods[0].Id.ToString(), dbPOS.Get_ProductTypeName_By_Id(prods[0].ProductTypeId), prods[0].ProductName, prods[0].OutUnitPrice.ToString() }); /* if (ptype.IsBatchDonation) * { * this.dgvData.Rows[dgvData.RowCount - 2].Cells[3].Style.BackColor = Color.Green; * } * if (ptype.IsBatchDiscount) * { * this.dgvData.Rows[dgvData.RowCount - 2].Cells[4].Style.BackColor = Color.Green; * }*/ this.dgvDataTo.FirstDisplayedScrollingRowIndex = dgvDataTo.RowCount - 1; } } } } } }