省市选择器

//数据库文件：http://www.programfan.com/blog/article.asp?id=28128

//源码：

 

  1 using System;
  2 using System.Collections.Generic;
  3 using System.ComponentModel;
  4 using System.Data;
  5 using System.Drawing;
  6 using System.Linq;
  7 using System.Text;
  8 using System.Windows.Forms;
  9 using System.Data.SqlClient;
 10 using System.IO;
 11 namespace 省市选择
 12 {
 13     public partial class Form1 : Form
 14     {
 15         public Form1()
 16         {
 17             InitializeComponent();
 18         }
 19 
 20         private void Form1_Load(object sender, EventArgs e)
 21         {   /*
 22             Person p1 = new Person();
 23             p1.Name = "tom";
 24             p1.Age = 30;
 25 
 26             MessageBox.Show(p1.ToString());
 27 
 28             Person p2 = new Person();
 29             p2.Name = "jim";
 30             p2.Age = 20;
 31             //设定comboBox的DisplayMerber属性为Name,就会显示对象的Name属性的值
 32             cmd省.Items.Add(p1);
 33             cmd省.Items.Add(p2);
 34             return;*/
 35             //创建数据库连接
 36             using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\VS2010\Test\省市选择\SS.mdf;Integrated Security=True;User Instance=True"))
 37             {
 38                 conn.Open();
 39                 //创建一个command 数据库交互的对象 
 40                 using (SqlCommand cmd = conn.CreateCommand())
 41                 {
 42                     cmd.CommandText = "select * from promary";
 43                     using (SqlDataReader dataReader = cmd.ExecuteReader())
 44                     {   //遍历
 45                         while (dataReader.Read())
 46                         {
 47                             ProvinceItem item = new ProvinceItem();
 48                             item.Id = dataReader.GetInt32(dataReader.GetOrdinal("proID"));
 49                             item.Name = dataReader.GetString(dataReader.GetOrdinal("proName"));
 50                             cmd省.Items.Add(item);
 51                         }
 52                     }
 53                 }
 54             }
 55             
 56         }
 57         private void cmb省_SelecteIndexChanged(object sender, EventArgs e)
 58         {
 59             ProvinceItem item = (ProvinceItem)cmd省.SelectedItem;
 60             int proID = item.Id;
 61             /*
 62             object obj1 = item;
 63             ProvinceItem p2 = obj;//把p2指向obj1 指向的对象
 64             ProvinceItem p2 = (ProvinceItem)obj1;*/
 65 
 66             using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\VS2010\Test\省市选择\SS.mdf;Integrated Security=True;User Instance=True"))
 67             {
 68                 conn.Open();
 69                 //创建一个command 数据库交互的对象 
 70                 using (SqlCommand cmd = conn.CreateCommand())
 71                 {
 72                     cmd.CommandText = "select * from city where proID=@proID";
 73                     cmd.Parameters.Add(new SqlParameter("proID", proID));
 74                     using (SqlDataReader dataReader = cmd.ExecuteReader())
 75                     {   //遍历
 76                         while (dataReader.Read())
 77                         {
 78                             string cityName = dataReader.GetString(dataReader.GetOrdinal("cityName"));
 79                             cmd市.Items.Add(cityName);
 80                            
 81                         }
 82                     }
 83                 }
 84             }
 85         }
 86       
 87     }
 88     class ProvinceItem
 89     {
 90         public string Name { get; set; }
 91         public int Id { get; set; }
 92     }
 93     /*
 94     class Person
 95     {
 96         public string Name { get; set; }
 97         public int Age { get; set; }
 98 
 99         public override string ToString()
100         {
101             return"hahahahahah" +Name;
102         }
103     }*/
104 }

//选择器

 

转载于:https://www.cnblogs.com/xudaxia/p/3285946.html