省市选择器WinFrom

来源：互联网发布：php 批量不重复卡密编辑：程序博客网时间：2024/04/30 01:28
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; }            }        }    }}
0 0