private void Form1_Load(object sender, EventArgs e)
{
DataTable dt = SQLTools.getDT("select distinct(provinceName) from Data_Province");
SQLTools.addBOX(comboBox1, dt, "provinceName");
comboBox1.Text = dt.Rows[0][0].ToString();
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox3.Items.Count != 0)
{
comboBox3.Items.Clear();
}
DataTable dtTemp = SQLTools.getDT("select CityCode,CityName from Data_City where CityName='" + comboBox2.SelectedItem + "'");
DataTable dt = SQLTools.getDT("select distinct(AreaName) from Data_Area where CityCode='" + dtTemp.Rows[0]["CityCode"] + "'");
SQLTools.addBOX(comboBox3, dt, "AreaName");
comboBox3.Text = dt.Rows[0][0].ToString();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
//判断选择框是否有内容，如果有则清除
if (comboBox2.Items.Count != 0)
{
comboBox2.Items.Clear();
}
DataTable dtTemp = SQLTools.getDT("select provinceCode,provinceName from Data_Province where provinceName='" + comboBox1.SelectedItem + "'");
//MessageBox.Show(dtTemp.Rows[0]["provinceCode"].ToString());
DataTable dt = SQLTools.getDT("select distinct(CityName) from Data_City where ProvinceCode='" + dtTemp.Rows[0]["provinceCode"] + "'");
SQLTools.addBOX(comboBox2, dt, "CityName");
comboBox2.Text = dt.Rows[0][0].ToString();
}
private void Form2_Load(object sender, EventArgs e)
{
DataTable dt = SQLTools.getDT("select distinct(provinceName) from Data_Province");
SQLTools.addBOX(comboBox1, dt, "provinceName");
}