provincecityarea.sql

三层无刷新级联选择省市区县 C#语言开发SQL 数据库(含全国完整数据库)Ajax无刷新三级联动

INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 246,'510700','绵阳市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 247,'510800','广元市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 248,'510900','遂宁市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 249,'511000','内江市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 250,'511100','乐山市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 251,'511300','南充市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 252,'511400','眉山市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 253,'511500','宜宾市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 254,'511600','广安市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 255,'511700','达州市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 256,'511800','雅安市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 257,'511900','巴中市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 258,'512000','资阳市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 259,'513200','阿坝藏族羌族自治州','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 260,'513300','甘孜藏族自治州','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 261,'513400','凉山彝族自治州','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 262,'520100','贵阳市','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 263,'520200','六盘水市','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 264,'520300','遵义市','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 265,'520400','安顺市','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 266,'522200','铜仁地区','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 267,'522300','黔西南布依族苗族自治州','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 268,'522400','毕节地区','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 269,'522600','黔东南苗族侗族自治州','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 270,'522700','黔南布依族苗族自治州','520000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 271,'530100','昆明市','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 272,'530300','曲靖市','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 273,'530400','玉溪市','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 274,'530500','保山市','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 275,'530600','昭通市','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 276,'530700','丽江市','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 277,'530800','思茅市','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 278,'530900','临沧市','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 279,'532300','楚雄彝族自治州','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 280,'532500','红河哈尼族彝族自治州','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 281,'532600','文山壮族苗族自治州','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 282,'532800','西双版纳傣族自治州','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 283,'532900','大理白族自治州','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 284,'533100','德宏傣族景颇族自治州','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 285,'533300','怒江傈僳族自治州','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 286,'533400','迪庆藏族自治州','530000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 287,'540100','拉萨市','540000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 288,'542100','昌都地区','540000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 289,'542200','山南地区','540000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 290,'542300','日喀则地区','540000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 291,'542400','那曲地区','540000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 292,'542500','阿里地区','540000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 293,'542600','林芝地区','540000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 294,'610100','西安市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 295,'610200','铜川市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 296,'610300','宝鸡市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 297,'610400','咸阳市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 298,'610500','渭南市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 299,'610600','延安市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 300,'610700','汉中市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 301,'610800','榆林市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 302,'610900','安康市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 303,'611000','商洛市','610000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 304,'620100','兰州市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 305,'620200','嘉峪关市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 306,'620300','金昌市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 307,'620400','白银市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 308,'620500','天水市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 309,'620600','武威市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 310,'620700','张掖市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 311,'620800','平凉市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 312,'620900','酒泉市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 313,'621000','庆阳市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 314,'621100','定西市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 315,'621200','陇南市','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 316,'622900','临夏回族自治州','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 317,'623000','甘南藏族自治州','620000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 318,'630100','西宁市','630000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 319,'632100','海东地区','630000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 320,'632200','海北藏族自治州','630000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 321,'632300','黄南藏族自治州','630000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 322,'632500','海南藏族自治州','630000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 323,'632600','果洛藏族自治州','630000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 324,'632700','玉树藏族自治州','630000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 325,'632800','海西蒙古族藏族自治州','630000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 326,'640100','银川市','640000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 327,'640200','石嘴山市','640000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 328,'640300','吴忠市','640000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 329,'640400','固原市','640000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 330,'640500','中卫市','640000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 331,'650100','乌鲁木齐市','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 332,'650200','克拉玛依市','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 333,'652100','吐鲁番地区','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 334,'652200','哈密地区','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 335,'652300','昌吉回族自治州','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 336,'652700','博尔塔拉蒙古自治州','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 337,'652800','巴音郭楞蒙古自治州','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 338,'652900','阿克苏地区','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 339,'653000','克孜勒苏柯尔克孜自治州','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 340,'653100','喀什地区','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 341,'653200','和田地区','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 342,'654000','伊犁哈萨克自治州','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 343,'654200','塔城地区','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 344,'654300','阿勒泰地区','650000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 345,'659000','省直辖行政单位','650000')
if exists (select * from sysobjects where id = OBJECT_ID('[area]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [area]

CREATE TABLE [area] (
[id] [int]  NOT NULL,
[code] [nvarchar]  (100) NULL,
[name] [nvarchar]  (120) NULL,
[cityId] [nvarchar]  (12) NULL)

INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 1,'110101','东城区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 2,'110102','西城区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 3,'110103','崇文区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 4,'110104','宣武区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 5,'110105','朝阳区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 6,'110106','丰台区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 7,'110107','石景山区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 8,'110108','海淀区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 9,'110109','门头沟区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 10,'110111','房山区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 11,'110112','通州区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 12,'110113','顺义区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 13,'110114','昌平区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 14,'110115','大兴区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 15,'110116','怀柔区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 16,'110117','平谷区','110100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 17,'110228','密云县','110200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 18,'110229','延庆县','110200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 19,'120101','和平区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 20,'120102','河东区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 21,'120103','河西区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 22,'120104','南开区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 23,'120105','河北区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 24,'120106','红桥区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 25,'120107','塘沽区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 26,'120108','汉沽区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 27,'120109','大港区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 28,'120110','东丽区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 29,'120111','西青区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 30,'120112','津南区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 31,'120113','北辰区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 32,'120114','武清区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 33,'120115','宝坻区','120100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 34,'120221','宁河县','120200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 35,'120223','静海县','120200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 36,'120225','蓟　县','120200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 37,'130101','市辖区','130100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 38,'130102','长安区','130100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 39,'130103','桥东区','130100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 40,'130104','桥西区','130100')