private void vip_Load(object sender, EventArgs e) { Mysqlcom my = new Mysqlcom(); if (!my.conn) { MessageBox.Show("数据库连接失败:" + my.error); return; } MySqlDataReader mydr = my.er("select SHID,SHname from wa_shop"); if (mydr == null) { MessageBox.Show("店铺读取失败:" + my.error); this.Close(); return; } sid.Clear(); while (mydr.Read()) { sid.Add((int)mydr["SHID"]); comboBox1.Items.Add(mydr["SHname"].ToString()); } comboBox1.Items.Add("全部"); mydr.Close(); comboBox1.Text = "全部"; }
private void search_Load(object sender, EventArgs e) { Mysqlcom my = new Mysqlcom(); if (!my.conn) { MessageBox.Show("数据库连接失败:" + my.error); return; } MySqlDataReader mydr = my.er("select SHID,SHname from wa_shop"); if (mydr == null) { MessageBox.Show("店铺读取失败:" + my.error); this.Close(); return; } sid.Clear(); while (mydr.Read()) { sid.Add((int)mydr["SHID"]); comboBox1.Items.Add(mydr["SHname"].ToString()); } comboBox1.Items.Add("全部"); mydr.Close(); int i = 0; for (i = 0; i < sid.Count; i++) if (Comdata.shopnum == (int)sid[i]) break; comboBox1.SelectedIndex = i; }