文本框自动提示匹配查询功能

create database XjhDemo go use XjhDemo go --商品类别 Create table Sort ( SortId int primary key identity(1,1),--类别Id SortFatherId int foreign key references Sort(SortId),--FatherId父类ID SortName varchar(30) not null --类别名称 ) go ---大类潮流女装 insert into Sort values(null,'潮流女装') insert into Sort values(1,'女装内衣')--中类女装内衣 insert into Sort values(2,'文胸/塑型') insert into Sort values(2,'内衣套装') insert into Sort values(2,'女式保暖') insert into Sort values(2,'女式内裤') insert into Sort values(2,'睡衣/家居服') insert into Sort values(1,'女装上装')--中类女装上装 insert into Sort values(8,'女式T恤') insert into Sort values(8,'女式皮衣') insert into Sort values(8,'女式针织衫/毛衣') insert into Sort values(8,'女式大衣/风衣') insert into Sort values(8,'女式外套/夹克') insert into Sort values(8,'女式羽绒服') insert into Sort values(8,'打底衫') insert into Sort values(8,'女式马甲/ 背心') insert into Sort values(8,'衬衫/雪纺衫') insert into Sort values(8,'女式棉服') insert into Sort values(8,'女式西服') insert into Sort values(1,'女装下装/裙装')--中类女装下装/裙装 insert into Sort values(20,'礼服') insert into Sort values(20,'女式牛仔裤') insert into Sort values(20,'裙裤') insert into Sort values(20,'女式休闲裤') insert into Sort values(20,'连衣裙') insert into Sort values(20,'半身裙') insert into Sort values(20,'打底裤') insert into Sort values(1,'女装搭配')--中类女装搭配 insert into Sort values(28,'单鞋') ---大类时尚男装 insert into Sort values(null,'时尚男装') insert into Sort values(30,'男装上装')--中类男装上装 insert into Sort values(31,'男式针织衫/毛衣') insert into Sort values(31,'男式衬衫') insert into Sort values(31,'男式外套/夹克') insert into Sort values(31,'男式卫衣') insert into Sort values(31,'男式棉服') insert into Sort values(31,'男式风衣/大衣') insert into Sort values(31,'男式西服') insert into Sort values(31,'男式羽绒服') insert into Sort values(31,'男式马甲/背心') insert into Sort values(31,'男式T恤') insert into Sort values(30,'男装下装')--中类男装下装 insert into Sort values(42,'男式牛仔裤') insert into Sort values(42,'男式西裤') insert into Sort values(30,'男装内衣')--中类男装内衣 insert into Sort values(45,'男式保暖') insert into Sort values(45,'男式睡衣/居家服') insert into Sort values(45,'男式内裤') ---大类运动户外 insert into Sort values(null,'运动户外') insert into Sort values(49,'运动服装')--中类运动服装 insert into Sort values(50,'冲锋衣') insert into Sort values(50,'运动下装') insert into Sort values(50,'运动帽') insert into Sort values(50,'运动袜子') insert into Sort values(50,'运动T恤/POLO衫') insert into Sort values(50,'运动夹克/外套') insert into Sort values(50,'运动卫衣/套头衫') insert into Sort values(50,'运动羽绒服/棉衣') insert into Sort values(50,'健身服装') insert into Sort values(50,'运动套装') insert into Sort values(49,'运动鞋')--中类运动鞋 insert into Sort values(61,'训练鞋/健身鞋') insert into Sort values(61,'帆布鞋') insert into Sort values(61,'运动沙滩鞋/拖鞋') insert into Sort values(61,'登山鞋') insert into Sort values(61,'其他运动鞋') insert into Sort values(61,'网球鞋') insert into Sort values(61,'篮球鞋') insert into Sort values(61,'足球鞋') insert into Sort values(61,'板鞋/休闲鞋') insert into Sort values(61,'跑步鞋') insert into Sort values(49,'户外用品')--中类户外用品 insert into Sort values(72,'游泳用具') insert into Sort values(72,'户外配件') insert into Sort values(72,'体育用品') insert into Sort values(72,'户外背包') insert into Sort values(72,'户外工具') insert into Sort values(72,'旅游用品') --大类箱包手袋 insert into Sort values(null,'箱包手袋') insert into Sort values(79,'潮流女包')--中类潮流女包 insert into Sort values(80,'女式双肩包') insert into Sort values(80,'女式手提包') insert into Sort values(80,'女式斜挎包') insert into Sort values(80,'女式钱包') insert into Sort values(80,'女式手包') insert into Sort values(80,'女式单肩包') insert into Sort values(79,'时尚男包')--中类时尚男包 insert into Sort values(87,'男式斜挎包') insert into Sort values(87,'男式双肩包') insert into Sort values(87,'男式手提包') insert into Sort values(87,'男式单肩包') insert into Sort values(87,'男式手包') insert into Sort values(87,'商务包/公文包') insert into Sort values(87,'男式钱包') insert into Sort values(79,'功能箱包')--中类功能箱包 insert into Sort values(95,'运动休闲包') insert into Sort values(95,'拉杆箱') insert into Sort values(95,'旅行包') --大类家居家纺 insert into Sort values(null,'家居家纺') insert into Sort values(99,'家纺')--中类家纺 insert into Sort values(100,'蚊帐/凉席') insert into Sort values(100,'床垫/床褥') insert into Sort values(100,'抱枕坐垫') insert into Sort values(100,'拖鞋') insert into Sort values(100,'毛巾家纺') insert into Sort values(100,'床品件套') insert into Sort values(100,'家居服') insert into Sort values(100,'被子') insert into Sort values(100,'毛巾被/毯') insert into Sort values(100,'枕芯枕套') insert into Sort values(99,'生活日用')-- 中类生活日用 insert into Sort values(111,'清洁护理') insert into Sort values(111,'拖 鞋') insert into Sort values(111,'茶具/杯具') insert into Sort values(111,'保鲜盒') insert into Sort values(111,'婴幼儿用品') insert into Sort values(111,'居家创意') insert into Sort values(111,'炊具刀具') insert into Sort values(111,'家装软饰') insert into Sort values(111,'浴室用品') insert into Sort values(111,'收纳整理') insert into Sort values(111,'洗晒用品') insert into Sort values(111,'桌面摆设') insert into Sort values(111,'卫浴配件') insert into Sort values(111,'厨房布艺') --大类美容妆品 insert into Sort values(null,'美容妆品') insert into Sort values(126,'面部护理')--中类面部护理 insert into Sort values(127,'面部护理套装') insert into Sort values(127,'眼膜/眼霜') insert into Sort values(127,'眼部精华/乳液') insert into Sort values(127,'卸妆油/乳/液') insert into Sort values(127,'面膜面贴') insert into Sort values(127,'爽肤水') insert into Sort values(127,'洁面乳') insert into Sort values(127,'面乳面霜') insert into Sort values(127,'精华露') insert into Sort values(126,'身体洗护')--中类身体洗护 insert into Sort values(137,'牙膏/牙粉/漱口水') insert into Sort values(137,'护理油') insert into Sort values(137,'口罩') insert into Sort values(137,'卫生护垫') insert into Sort values(137,'身体洗护套装') insert into Sort values(137,'防晒隔离') insert into Sort values(137,'冰/暖宝贴') insert into Sort values(137,'沐浴露') insert into Sort values(137,'染发/造型') insert into Sort values(137,'洗发护发') insert into Sort values(137,'牙刷/牙线') insert into Sort values(137,'手工/香皂') insert into Sort values(137,'润肤乳/霜') insert into Sort values(126,'香氛彩妆')--中类香氛彩妆 insert into Sort values(151,'粉饼') insert into Sort values(151,'中性香水/香氛') insert into Sort values(151,'香水/香氛套装') insert into Sort values(151,'唇膏唇彩') insert into Sort values(151,'粉底/遮瑕') insert into Sort values(151,'眼影/眼线') insert into Sort values(151,'睫毛膏') --大类国际名品 insert into Sort values(null,'国际名品') insert into Sort values(159,'奢侈名包')--中类奢侈名包 insert into Sort values(160,'钱包') insert into Sort values(160,'男包') insert into Sort values(160,'女包') insert into Sort values(159,'数码家电')--中类数码家电 insert into Sort values(164,'数码配件') insert into Sort values(164,'保健器材') insert into Sort values(164,'3C小家电') insert into Sort values(159,'时尚臻饰')--中类时尚臻饰 insert into Sort values(168,'围巾/丝巾') insert into Sort values(168,'钥匙扣') insert into Sort values(168,'高级雨具') insert into Sort values(168,'链饰/耳饰') insert into Sort values(168,'手套') insert into Sort values(168,'帽子') insert into Sort values(168,'太阳镜') insert into Sort values(168,'皮带') insert into Sort values(168,'领带') insert into Sort values(168,'腕表') insert into Sort values(16