省市选择器WinFrom

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WinFrom省市选择器
{
    public partial class Form1 : Form
    {
        SqlConnection con = null;
        SqlCommand cmd = null;
        string constr = @"Data Source=.;Initial Catalog=MyDB;Integrated Security=True";
        public Form1()
        {
            InitializeComponent();
            BindData();
        }

        private void cmbprovince_SelectedIndexChanged(object sender, EventArgs e)
        {
            AddItems aitem = (AddItems)cmbprovince.SelectedItem;
            int num = aitem.ID;
            using (con = new SqlConnection(constr))
            {
                con.Open();
                cmd = con.CreateCommand();
                cmd.CommandText = "select * from city where proid=@ProId";
                cmd.Parameters.Add(new SqlParameter("ProId", num));
                SqlDataReader dr = cmd.ExecuteReader();
                cmbcity.Items.Clear();
                while (dr.Read())
                {
                    AddItems ai = new AddItems();
                    ai.ID = dr.GetInt32(dr.GetOrdinal("CityId"));
                    ai.Name = dr.GetString(dr.GetOrdinal("CityName"));
                    //add()需要一个对象，故声明一个类中两个字段，初始化一个对象，将数据库的值附加到对象中，再使用
                    cmbcity.Items.Add(ai);
                }

            }
        }

        /// <summary>
        /// 绑定省的数据
        /// </summary>
        private void BindData()
        {
            using (con = new SqlConnection(constr))
            {
                con.Open();
                cmd = con.CreateCommand();
                cmd.CommandText = "select * from promary";
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    AddItems ai = new AddItems();
                    ai.ID = dr.GetInt32(dr.GetOrdinal("ProID"));
                    ai.Name = dr.GetString(dr.GetOrdinal("ProName"));
                    cmbprovince.Items.Add(ai);                }
            }
        }

        class AddItems
        {
            private int _id;
            private string _name;

            public int ID
            {
                set { _id = value; }
                get { return _id; }
            }
            public string Name
            {
                set { _name = value; }
                get { return _name; }
            }
        }
    }
}