private void cmbDishes_SelectedIndexChanged(object sender, EventArgs e) { if (cmbDishes.SelectedIndex != -1) { int i = cmbDishes.SelectedIndex; main = dishList[i]; } }
private void revealTheDataMainCourse() { //solution link: #region //http://stackoverflow.com/questions/1346132/how-do-i-extract-data-from-a-datatable #endregion string queryString = "SELECT * FROM MainCourse"; DataTable dt = GetData(queryString); foreach (DataRow item in dt.Rows) { var main = new MainCourse(); main.Id = Convert.ToInt32(item["Id"].ToString()); main.Name = item["MainCourseName"].ToString(); main.Price = Convert.ToDecimal(item["Price"].ToString()); dishList.Add(main); } cmbDishes.ValueMember = "Id"; cmbDishes.DisplayMember = "Name"; cmbDishes.DataSource = dishList; }
public Form1() { InitializeComponent(); var connectionString = ConfigurationManager.ConnectionStrings["DB"].ConnectionString; string queryString = "SELECT * FROM MainCourse;"; DataTable dt = GetData(connectionString, queryString); var dishList = new List <MainCourse>(); foreach (DataRow item in dt.Rows) { var main = new MainCourse(); main.Id = Convert.ToInt32(item["Id"].ToString()); main.Name = item["MainCourseName"].ToString(); dishList.Add(main); } cmbDishes.ValueMember = "Id"; cmbDishes.DisplayMember = "Name"; cmbDishes.DataSource = dishList; }