public void BindToSaleNo() { SaleController saleController = new SaleController(); SaleCollection saleCollection = saleController.SelectList(); SaleInfo saleInfo = new SaleInfo(); saleInfo.SaleNo = "-Select One"; saleInfo.SaleID = null; saleCollection.Insert(0, saleInfo); this.cboToSaleInvoiceNo.DisplayMember = "SaleNo"; this.cboToSaleInvoiceNo.ValueMember = "SaleID"; this.cboToSaleInvoiceNo.DataSource = saleCollection; this.cboToSaleInvoiceNo.SelectedIndex = 0; }
private void BindToSaleNo() { SaleController saleController = new SaleController(); SaleCollection saleCollection = saleController.SelectList(); SaleInfo info = new SaleInfo(); info.SaleNo = " - Select One - "; info.SaleID = null; saleCollection.Insert(0, info); cboToSaleNo.DisplayMember = "SaleNo"; cboToSaleNo.ValueMember = "SaleID"; cboToSaleNo.DataSource = saleCollection; cboToSaleNo.SelectedIndex = 0; }
public SaleCollection SelectList() { SaleCollection collection = new SaleCollection(); IDataReader Reader = SaleDataAccess.SelectList(); while (Reader.Read()) { SaleInfo saleInfo = new SaleInfo(); saleInfo.SaleID = Convert.ToString(Reader["SaleID"]); saleInfo.SaleNo = Convert.ToString(Reader["SaleNo"]); saleInfo.SaleDate = Convert.ToDateTime(Reader["SaleDate"]); saleInfo.Quantity = Convert.ToInt32(Reader["Quantity"]); saleInfo.CustomerID = Convert.ToString(Reader["CustomerID"]); collection.Add(saleInfo); } Reader.Close(); return(collection); }