步步为营-40-省市列表二级联动

说明: ComboBox的使用

1:准备数据

USE [master]

GO

/****** Object: Database [DBProvinceCity] Script Date: 2017-04-27 09:27:48 ******/

CREATE DATABASE [DBProvinceCity]

CONTAINMENT = NONE

ON PRIMARY

( NAME = N'DBProvinceCity', FILENAME = N'F:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\DBProvinceCity.mdf' , SIZE = 4288KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

LOG ON

( NAME = N'DBProvinceCity_log', FILENAME = N'F:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\DBProvinceCity_log.ldf' , SIZE = 1072KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

GO

ALTER DATABASE [DBProvinceCity] SET COMPATIBILITY_LEVEL = 120

GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [DBProvinceCity].[dbo].[sp_fulltext_database] @action = 'enable'

end

GO

ALTER DATABASE [DBProvinceCity] SET ANSI_NULL_DEFAULT OFF

GO

ALTER DATABASE [DBProvinceCity] SET ANSI_NULLS OFF

GO

ALTER DATABASE [DBProvinceCity] SET ANSI_PADDING OFF

GO

ALTER DATABASE [DBProvinceCity] SET ANSI_WARNINGS OFF

GO

ALTER DATABASE [DBProvinceCity] SET ARITHABORT OFF

GO

ALTER DATABASE [DBProvinceCity] SET AUTO_CLOSE OFF

GO

ALTER DATABASE [DBProvinceCity] SET AUTO_SHRINK OFF

GO

ALTER DATABASE [DBProvinceCity] SET AUTO_UPDATE_STATISTICS ON

GO

ALTER DATABASE [DBProvinceCity] SET CURSOR_CLOSE_ON_COMMIT OFF

GO

ALTER DATABASE [DBProvinceCity] SET CURSOR_DEFAULT GLOBAL

GO

ALTER DATABASE [DBProvinceCity] SET CONCAT_NULL_YIELDS_NULL OFF

GO

ALTER DATABASE [DBProvinceCity] SET NUMERIC_ROUNDABORT OFF

GO

ALTER DATABASE [DBProvinceCity] SET QUOTED_IDENTIFIER OFF

GO

ALTER DATABASE [DBProvinceCity] SET RECURSIVE_TRIGGERS OFF

GO

ALTER DATABASE [DBProvinceCity] SET ENABLE_BROKER

GO

ALTER DATABASE [DBProvinceCity] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

GO

ALTER DATABASE [DBProvinceCity] SET DATE_CORRELATION_OPTIMIZATION OFF

GO

ALTER DATABASE [DBProvinceCity] SET TRUSTWORTHY OFF

GO

ALTER DATABASE [DBProvinceCity] SET ALLOW_SNAPSHOT_ISOLATION OFF

GO

ALTER DATABASE [DBProvinceCity] SET PARAMETERIZATION SIMPLE

GO

ALTER DATABASE [DBProvinceCity] SET READ_COMMITTED_SNAPSHOT OFF

GO

ALTER DATABASE [DBProvinceCity] SET HONOR_BROKER_PRIORITY OFF

GO

ALTER DATABASE [DBProvinceCity] SET RECOVERY FULL

GO

ALTER DATABASE [DBProvinceCity] SET MULTI_USER

GO

ALTER DATABASE [DBProvinceCity] SET PAGE_VERIFY CHECKSUM

GO

ALTER DATABASE [DBProvinceCity] SET DB_CHAINING OFF

GO

ALTER DATABASE [DBProvinceCity] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )

GO

ALTER DATABASE [DBProvinceCity] SET TARGET_RECOVERY_TIME = 0 SECONDS

GO

ALTER DATABASE [DBProvinceCity] SET DELAYED_DURABILITY = DISABLED

GO

EXEC sys.sp_db_vardecimal_storage_format N'DBProvinceCity', N'ON'

GO

USE [DBProvinceCity]

GO

/****** Object: Table [dbo].[city] Script Date: 2017-04-27 09:27:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[city](

[cityID] [int] NOT NULL,

[cityName] [varchar](50) NOT NULL,

[proID] [int] NULL,

PRIMARY KEY CLUSTERED

(

[cityName] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object: Table [dbo].[Province] Script Date: 2017-04-27 09:27:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Province](

[proID] [int] NOT NULL,

[proName] [varchar](50) NOT NULL,

PRIMARY KEY CLUSTERED

(

[proID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (19, N'阿坝藏族羌族自治州', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'阿克苏市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'阿拉尔市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'阿拉善盟', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (22, N'阿勒泰市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'阿里地区', 30)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'阿图什市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'安康市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'安庆市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'安顺市', 24)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'安阳市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'鞍山市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'澳门特别行政区', 34)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'巴彦淖尔市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'巴中市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'白城市', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'白沙黎族自治县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'白山市', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'白银市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'百色市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'蚌埠市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'包头市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'宝鸡市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'保定市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'保山市', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'保亭黎族苗族自治县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'北海市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'北京市', 1)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'本溪市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'毕节地区', 24)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'滨州市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'亳州市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'博乐市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'沧州市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'昌都地区', 30)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'昌吉市　', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'昌江黎族自治县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'长春市', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'长沙市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'长治市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'常德市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'常州市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'巢湖市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'朝阳市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (19, N'潮州市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'郴州市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'成都市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'承德市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'澄迈县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'池州市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'赤峰市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'崇左市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'滁州市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'楚雄彝族自治州', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'达州市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'大 庆 市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'大理白族自治州', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'大连市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'大同市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'大兴安岭地区', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'丹东市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'儋州市', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'德宏傣族景颇族自治州', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'德阳市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'德州市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'迪庆藏族自治州', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'定安县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'定西市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'东方市', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'东莞市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'东营市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'鄂尔多斯市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'鄂州市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'恩施土家族苗族自治州', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'防城港市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'佛山市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'福州市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'抚顺市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'抚州市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'阜康市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'阜新市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'阜阳市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'甘南藏族自治州', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (20, N'甘孜藏族自治州', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'赣州市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'高雄市', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (19, N'高雄县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'固原市', 31)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'广安市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'广元市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'广州市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'贵港市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'贵阳市', 24)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'桂林市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'果洛藏族自治州', 27)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'哈尔滨市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'哈密市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'海北藏族自治州', 27)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'海东地区', 27)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'海口市', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'海南藏族自治州', 27)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'海西蒙古族藏族自治州', 27)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'邯郸市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'汉中市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'杭州市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'合肥市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'和田市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'河池市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'河源市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'菏泽市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'贺州市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'鹤 岗 市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'鹤壁市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'黑 河 市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'衡水市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'衡阳市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'红河哈尼族彝族自治州', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'呼和浩特市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'呼伦贝尔市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'湖州市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'葫芦岛市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (23, N'花莲县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'怀化市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'淮安市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'淮北市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'淮南市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'黄冈市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'黄南藏族自治州', 27)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'黄山市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'黄石市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'惠州市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'鸡 西 市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'基隆市', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'吉安市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'吉林市', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'济南市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'济宁市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (18, N'济源市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'佳木斯市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'嘉兴市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'嘉义市', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'嘉义县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'嘉峪关市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'江门市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'焦作市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (20, N'揭阳市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'金昌市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'金华市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'锦州市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'晋城市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'晋中市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'荆门市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'荆州市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'景德镇市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'九江市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'酒泉市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'喀什市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'开封市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'克拉玛依市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'库尔勒市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (19, N'奎屯市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'昆明市', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'拉萨市', 30)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'来宾市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'莱芜市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'兰州市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'廊坊市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'乐东黎族自治县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'乐山市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'丽江市', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'丽水市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'连云港市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (21, N'凉山彝族自治州', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'辽阳市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'辽源市', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'聊城市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'林芝地区', 30)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'临沧市', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'临汾市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'临高县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'临夏回族自治州', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'临沂市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'陵水黎族自治县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'柳州市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'六安市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'六盘水市', 24)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'龙岩市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'陇南市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'娄底市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'泸州市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'吕梁市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'洛阳市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'漯河市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'马鞍山市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'茂名市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'眉山市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'梅州市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'米泉市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'绵阳市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'苗栗县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'牡丹江市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'内江市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'那曲地区', 30)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'南昌市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'南充市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'南京市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'南宁市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'南平市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'南通市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'南投县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'南阳市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'宁波市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'宁德市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'怒江傈傈族自治州', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'攀枝花市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'盘锦市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (21, N'澎湖县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'平顶山市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'平凉市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (20, N'屏东县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'萍乡市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'莆田市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'濮阳市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'七台河市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'齐齐哈尔市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'潜江市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'黔东南苗族侗族自治州', 24)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'黔南布依族苗族自治州', 24)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'黔西南布依族苗族自治州', 24)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'钦州市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'秦皇岛市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'青岛市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'清远市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'庆阳市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'琼海市', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (18, N'琼中黎族苗族自治县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'曲靖市', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'衢州市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'泉州市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'日喀则地区', 30)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'日照市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'三门峡市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'三明市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'三亚市', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'山南地区', 30)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'汕头市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'汕尾市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'商洛市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'商丘市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'上海市', 3)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'上饶市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'韶关市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'邵阳市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'绍兴市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'深圳市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'神农架林区', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'沈阳市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'十堰市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'石河子市　', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'石家庄市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'石嘴山市', 31)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'双鸭山市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'朔州市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'思茅市', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'四平市', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'松原市', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'苏州市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'宿迁市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'宿州市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'绥 化 市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'随州市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'遂宁市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (20, N'塔城市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'台北市', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'台北县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (22, N'台东县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'台南市', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (18, N'台南县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'台中市', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'台中县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'台州市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'太原市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'泰安市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'泰州市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'唐山市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'桃园县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'天津市', 2)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'天门市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'天水市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (12, N'铁岭市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'通化市', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'通辽市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'铜川市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'铜陵市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'铜仁地区', 24)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'图木舒克市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'吐鲁番市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'屯昌县', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'万宁市', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'威海市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'潍坊市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'渭南市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'温州市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'文昌市', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'文山壮族苗族自治州', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'乌海市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'乌兰察布市', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'乌鲁木齐市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (21, N'乌苏市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'无锡市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'吴忠市', 31)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'芜湖市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'梧州市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'五家渠市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'五指山市', 25)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'武汉市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'武威市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'西安市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'西宁市', 27)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'西双版纳傣族自治州', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'锡林郭勒盟', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'厦门市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'仙桃市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'咸宁市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'咸阳市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'香港特别行政区', 35)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'湘潭市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'湘西土家族苗族自治州', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'襄樊市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'孝感市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'忻州市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'新乡市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'新余市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'新竹市', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'新竹县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'信阳市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'兴安盟', 33)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'邢台市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'徐州市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'许昌市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'宣城市', 13)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'雅安市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'烟台市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'延安市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'延边朝鲜族自治州', 9)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'盐城市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'扬州市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (15, N'阳江市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'阳泉市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'伊 春 市', 10)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (18, N'伊宁市', 32)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (13, N'宜宾市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'宜昌市', 18)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'宜春市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'宜兰县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'益阳市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'银川市', 31)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'鹰潭市', 15)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'营口市', 8)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'永州市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'榆林市', 28)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'玉林市', 29)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'玉树藏族自治州', 27)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'玉溪市', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'岳阳市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (21, N'云浮市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'云林县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'运城市', 6)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (4, N'枣庄市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'湛江市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (8, N'张家界市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'张家口市', 5)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (7, N'张掖市', 21)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (14, N'彰化县', 7)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (6, N'漳州市', 14)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'昭通市', 26)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (10, N'肇庆市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (11, N'镇江市', 11)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'郑州市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (18, N'中山市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (5, N'中卫市', 31)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (1, N'重庆市', 4)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (9, N'舟山市', 12)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (16, N'周口市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'株洲市', 19)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'珠海市', 20)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (17, N'驻马店市', 17)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (18, N'资阳市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'淄博市', 16)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (2, N'自贡市', 22)

GO

INSERT [dbo].[city] ([cityID], [cityName], [proID]) VALUES (3, N'遵义市', 24)

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (1, N'北京市')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (2, N'天津市')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (3, N'上海市')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (4, N'重庆市')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (5, N'河北省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (6, N'山西省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (7, N'台湾省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (8, N'辽宁省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (9, N'吉林省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (10, N'黑龙江省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (11, N'江苏省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (12, N'浙江省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (13, N'安徽省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (14, N'福建省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (15, N'江西省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (16, N'山东省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (17, N'河南省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (18, N'湖北省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (19, N'湖南省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (20, N'广东省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (21, N'甘肃省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (22, N'四川省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (24, N'贵州省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (25, N'海南省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (26, N'云南省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (27, N'青海省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (28, N'陕西省')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (29, N'广西壮族自治区')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (30, N'西藏自治区')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (31, N'宁夏回族自治区')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (32, N'新疆维吾尔自治区')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (33, N'内蒙古自治区')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (34, N'澳门特别行政区')

GO

INSERT [dbo].[Province] ([proID], [proName]) VALUES (35, N'香港特别行政区')

GO

ALTER TABLE [dbo].[city] WITH CHECK ADD FOREIGN KEY([proID])

REFERENCES [dbo].[Province] ([proID])

GO

USE [master]

GO

ALTER DATABASE [DBProvinceCity] SET READ_WRITE

GO

View Code

2: 设置省,然后添加一个Province类,然后重写ToString方法(返回市名属性)比较好,这里为了省事直接通过字典保存数据

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Province_City

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

//定义一个字典--省;存放显示的名称和int值

private Dictionary provinceList = new Dictionary();

private void Form1_Load(object sender, EventArgs e)

{

string sqlSelect = "select proID, proName from Province";

MakeList(sqlSelect, "Province");

this.cbProvince.SelectedIndex = 0;

}

private void cbProvince_SelectedIndexChanged(object sender, EventArgs e)

{

//01获取选择省的名称

string proviceName =Convert.ToString(this.cbProvince.SelectedItem);

//02 通过名称查询字典获取ID

string proviceID = provinceList[proviceName];

//03 根据省份ID获取省下的市

string sqlSelect = "select cityID, cityName, proID from city where proID =" + proviceID;

//04调用之前先清空

this.cbCity.Items.Clear();

MakeList(sqlSelect, "city");

}

public void MakeList( string sqlSelect,string flag)

{

//01创建连接字符串

//01-a 配置config文件

//01-b 添加引用

string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

//02创建连接对象

SqlConnection conn = new SqlConnection(connStr);

using (conn)

{

//03打开数据

conn.Open();

//04接受SQL脚本,

using (SqlCommand cmd = new SqlCommand(sqlSelect, conn))

{

//05执行脚本

using (cmd)

{

//06使用SqlDataReader读取数据

using (SqlDataReader reader = cmd.ExecuteReader())

{

if (flag == "Province")

{

while (reader.Read())

{

//把省的信息放到 ComboBox中。ComboBox显示信息是 Item对象的ToString（）

//同时把id值放到对应的字典中,也可以新建一个Province类进行存储

this.cbProvince.Items.Add(reader["proName"].ToString());

provinceList.Add(reader["proName"].ToString(), reader["proID"].ToString());

}

}

else

{

while (reader.Read())

{

this.cbCity.Items.Add(reader["cityName"].ToString());

}

}

}

}

}

}

}

}

}

View Code

3:运行效果

参考阅读