在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using DBHelper; using MySql.Data.MySqlClient; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { //string sql = "select * from s_province"; ////DataTableCollection dc = SqlHelper.GetTableText(sql, null); //MySqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionString, CommandType.Text, sql, null); //while (dr.Read()) //{ // zi a = new zi(); // comboBox1.DisplayMember = "ProvinceName"; // comboBox1.ValueMember = "ProvinceID"; // a.provinceID = Convert.ToInt32(dr[0]); // a.provinceName = Convert.ToString(dr[1]); // comboBox1.Items.Add(a); //} //comboBox1.SelectedIndex = 0; this.comboBox1.Items.Clear(); string sql = "select * from s_province"; DataSet ds = SqlHelper.ExecuteDataSetText(sql, null); comboBox1.DisplayMember = "ProvinceName"; comboBox1.ValueMember = "ProvinceID"; comboBox1.DataSource = ds.Tables[0]; } private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { //this.comboBox3.Items.Clear(); //qu qx = (qu)comboBox2.SelectedItem; //int id = qx.cityID; //string sql = "select * from qu where quid=@id"; //MySqlParameter p = new MySqlParameter("@id", id); //MySqlParameter[] pa = new MySqlParameter[] { p }; //MySqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionString, CommandType.Text, sql, pa); //while (dr.Read()) //{ // comboBox3.Items.Add(dr[1]); //} } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { // this.comboBox2.Items.Clear(); //zi ax = (zi)comboBox1.SelectedItem; //int id = ax.provinceID; //string sql = "select * from s_city where ProvinceID=@id"; //MySqlParameter p = new MySqlParameter("@id", id); //MySqlParameter[] pa = new MySqlParameter[] { p }; //MySqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionString, CommandType.Text, sql, pa); //while (dr.Read()) //{ // //qu q = new qu(); // //comboBox1.DisplayMember = "CityName"; // //comboBox1.ValueMember = "CityID"; // //q.cityID = Convert.ToInt32(dr[0]); // //q.cityName = Convert.ToString(dr[1]); // //comboBox2.Items.Add(q); // comboBox2.Items.Add(dr[1]); //} string id = Convert.ToString(comboBox1.SelectedValue); load_city(id); } private void load_city(string provinceid) { string sql = "select * from s_city where ProvinceID="+provinceid; DataSet ds = SqlHelper.ExecuteDataSetText(sql, null); comboBox2.DisplayMember = "CityName"; comboBox2.ValueMember = "CityID"; comboBox2.DataSource = ds.Tables[0]; } private void comboBox3_SelectedIndexChanged(object sender, EventArgs e) { } } class zi { public string provinceName; public string ProvinceName { get { return provinceName; } set { provinceName = value; } } public int provinceID; public int ProvinceID { get { return provinceID; } set { provinceID = value; } } } class qu { public string cityName; public string CityName { get { return cityName; } set { cityName = value; } } public int cityID; public int CityID { get { return cityID; } set { cityID = value; } } } }
|
请发表评论