c# sql省市联动
[Book]
GO
INSERT INTO Area(city, parentid) VALUES (‘北京市‘,0);
INSERT INTO Area(city, parentid) VALUES (‘天津市‘,0);
INSERT INTO Area(city, parentid) VALUES (‘上海市‘,0);
INSERT INTO Area(city, parentid) VALUES (‘重庆市‘,0);
INSERT INTO Area(city, parentid) VALUES (‘河北省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘山西省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘台湾省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘辽宁省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘吉林省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘黑龙江省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘江苏省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘浙江省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘安徽省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘福建省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘江西省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘山东省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘河南省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘湖北省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘湖南省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘广东省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘甘肃省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘四川省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘贵州省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘海南省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘云南省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘青海省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘陕西省‘,0);
INSERT INTO Area(city, parentid) VALUES (‘广西壮族自治区‘,0);
INSERT INTO Area(city, parentid) VALUES (‘西藏自治区‘,0);
INSERT INTO Area(city, parentid) VALUES (‘宁夏回族自治区‘,0);
INSERT INTO Area(city, parentid) VALUES (‘新疆维吾尔自治区‘,0);
INSERT INTO Area(city, parentid) VALUES (‘内蒙古自治区‘,0);
INSERT INTO Area(city, parentid) VALUES (‘澳门特别行政区‘,0);
INSERT INTO Area(city, parentid) VALUES (‘香港特别行政区‘,0);
INSERT INTO Area(city, parentid) VALUES (‘北京市‘,1);
INSERT INTO Area(city, parentid) VALUES (‘天津市‘,2);
INSERT INTO Area(city, parentid) VALUES (‘上海市‘,3);
INSERT INTO Area(city, parentid) VALUES (‘重庆市‘,4);
INSERT INTO Area(city, parentid) VALUES (‘石家庄市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘保定市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘唐山市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘廊坊市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘张家口市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘承德市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘沧州市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘秦皇岛市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘衡水市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘邢台市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘邯郸市‘,5);
INSERT INTO Area(city, parentid) VALUES (‘太原市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘临汾市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘吕梁市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘大同市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘忻州市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘晋中市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘晋城市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘朔州市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘运城市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘长治市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘阳泉市‘,6);
INSERT INTO Area(city, parentid) VALUES (‘台北市‘,7);
INSERT INTO Area(city, parentid) VALUES (‘云林县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘南投县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘台东县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘台中县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘台中市‘,7);
INSERT INTO Area(city, parentid) VALUES (‘台北县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘台南县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘台南市‘,7);
INSERT INTO Area(city, parentid) VALUES (‘嘉义县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘嘉义市‘,7);
INSERT INTO Area(city, parentid) VALUES (‘基隆市‘,7);
INSERT INTO Area(city, parentid) VALUES (‘宜兰县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘屏东县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘彰化县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘新竹县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘新竹市‘,7);
INSERT INTO Area(city, parentid) VALUES (‘桃园县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘澎湖县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘花莲县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘苗栗县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘高雄县‘,7);
INSERT INTO Area(city, parentid) VALUES (‘高雄市‘,7);
INSERT INTO Area(city, parentid) VALUES (‘沈阳市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘大连市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘丹东市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘抚顺市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘朝阳市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘本溪市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘盘锦市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘营口市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘葫芦岛市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘辽阳市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘铁岭市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘锦州市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘阜新市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘鞍山市‘,8);
INSERT INTO Area(city, parentid) VALUES (‘长春市‘,9);
INSERT INTO Area(city, parentid) VALUES (‘吉林市‘,9);
INSERT INTO Area(city, parentid) VALUES (‘四平市‘,9);
INSERT INTO Area(city, parentid) VALUES (‘延边朝鲜族自治州‘,9);
INSERT INTO Area(city, parentid) VALUES (‘松原市‘,9);
INSERT INTO Area(city, parentid) VALUES (‘白城市‘,9);
INSERT INTO Area(city, parentid) VALUES (‘白山市‘,9);
INSERT INTO Area(city, parentid) VALUES (‘辽源市‘,9);
INSERT INTO Area(city, parentid) VALUES (‘通化市‘,9);
INSERT INTO Area(city, parentid) VALUES (‘哈尔滨市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘七台河市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘伊 春 市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘佳木斯市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘双鸭山市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘大 庆 市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘大兴安岭地区‘,10);
INSERT INTO Area(city, parentid) VALUES (‘牡丹江市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘绥 化 市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘鸡 西 市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘鹤 岗 市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘黑 河 市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘齐齐哈尔市‘,10);
INSERT INTO Area(city, parentid) VALUES (‘南京市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘南通市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘宿迁市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘常州市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘徐州市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘扬州市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘无锡市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘泰州市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘淮安市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘盐城市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘苏州市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘连云港市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘镇江市‘,11);
INSERT INTO Area(city, parentid) VALUES (‘杭州市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘丽水市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘台州市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘嘉兴市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘宁波市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘温州市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘湖州市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘绍兴市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘舟山市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘衢州市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘金华市‘,12);
INSERT INTO Area(city, parentid) VALUES (‘合肥市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘亳州市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘六安市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘安庆市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘宣城市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘宿州市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘巢湖市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘池州市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘淮北市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘淮南市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘滁州市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘芜湖市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘蚌埠市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘铜陵市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘阜阳市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘马鞍山市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘黄山市‘,13);
INSERT INTO Area(city, parentid) VALUES (‘福州市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘三明市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘南平市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘厦门市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘宁德市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘泉州市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘漳州市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘莆田市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘龙岩市‘,14);
INSERT INTO Area(city, parentid) VALUES (‘南昌市‘,15);
INSERT INTO Area(city, parentid) VALUES (‘上饶市‘,15);
INSERT INTO Area(city, parentid) VALUES (‘九江市‘,15);
INSERT INTO Area(city, parentid) VALUES (‘吉安市‘,15);
INSERT INTO