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;
}
