public void item() { List <StockinView> stockinViews = aStockInManager.StockWithCompany(); StockinView defauStockinView = new StockinView(); defauStockinView.ItemId = -1; defauStockinView.ItemName = "--Select--"; stockinViews.Insert(0, defauStockinView); itemNameComboBox.DataSource = stockinViews; itemNameComboBox.DisplayMember = "ItemName"; itemNameComboBox.ValueMember = "ItemId"; }
public List <StockinView> StockWithCompany() { Query = "SELECT * FROM StockWithCompany"; Command = new SqlCommand(Query, Connection); Command.Connection.Open(); Reader = Command.ExecuteReader(); List <StockinView> stockList = new List <StockinView>(); while (Reader.Read()) { StockinView aStockinView = new StockinView(); aStockinView.CompanyId = (int)Reader["CompanyId"]; aStockinView.ItemId = (int)Reader["ItemId"]; aStockinView.CompanyName = Reader["CompanyName"].ToString(); aStockinView.ItemName = Reader["ItemName"].ToString(); stockList.Add(aStockinView); } Reader.Close(); Connection.Close(); return(stockList); }