https://blog.youkuaiyun.com/rabbitlzxzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/rabbitlzx/article/details/158648079https://blog.youkuaiyun.com/rabbitlzx/article/details/158648079rabbitlzxWed, 04 Mar 2026 15:32:49 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/158068356https://blog.youkuaiyun.com/rabbitlzx/article/details/158068356rabbitlzxSat, 14 Feb 2026 15:35:01 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/157902297https://blog.youkuaiyun.com/rabbitlzx/article/details/157902297rabbitlzxFri, 13 Feb 2026 13:56:14 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/156071515https://blog.youkuaiyun.com/rabbitlzx/article/details/156071515rabbitlzxWed, 24 Dec 2025 16:07:33 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/118512640https://blog.youkuaiyun.com/rabbitlzx/article/details/118512640rabbitlzxTue, 06 Jul 2021 17:18:41 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/116306826https://blog.youkuaiyun.com/rabbitlzx/article/details/116306826rabbitlzxFri, 30 Apr 2021 17:27:55 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/115536377https://blog.youkuaiyun.com/rabbitlzx/article/details/115536377rabbitlzxFri, 09 Apr 2021 08:59:25 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/115065810https://blog.youkuaiyun.com/rabbitlzx/article/details/115065810rabbitlzxMon, 22 Mar 2021 10:27:24 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/114888860https://blog.youkuaiyun.com/rabbitlzx/article/details/114888860rabbitlzxTue, 16 Mar 2021 17:02:31 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/114888600https://blog.youkuaiyun.com/rabbitlzx/article/details/114888600rabbitlzxTue, 16 Mar 2021 17:00:40 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/114887836https://blog.youkuaiyun.com/rabbitlzx/article/details/114887836rabbitlzxTue, 16 Mar 2021 16:47:33 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/7754225https://blog.youkuaiyun.com/rabbitlzx/article/details/7754225rabbitlzxTue, 17 Jul 2012 10:22:19 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/7681627https://blog.youkuaiyun.com/rabbitlzx/article/details/7681627rabbitlzxThu, 21 Jun 2012 09:15:38 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/6542935https://blog.youkuaiyun.com/rabbitlzx/article/details/6542935rabbitlzxTue, 14 Jun 2011 09:50:00 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/6541301https://blog.youkuaiyun.com/rabbitlzx/article/details/6541301rabbitlzxMon, 13 Jun 2011 14:53:00 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/6146756https://blog.youkuaiyun.com/rabbitlzx/article/details/6146756rabbitlzxMon, 17 Jan 2011 14:04:00 +0800keywords: 拼音 首字母 过滤
 
在combobox中输入汉字拼音的首字母时，下面列出对应的可选项，就像下面这样
 
 

 
1。 首先在数据库中需要设计一个表，专门用来存放药物及对应的拼音首字母，这样当用户输入拼音字母后就可以到表中查找匹配的药物，然后再显示
 
2。 下面的委托方法负责将从数据库获得的查询结果集重新邦定到combobox并自动弹出下拉列表。下面的代码需要注意这几行
https://blog.youkuaiyun.com/rabbitlzx/article/details/6074739https://blog.youkuaiyun.com/rabbitlzx/article/details/6074739rabbitlzxTue, 14 Dec 2010 10:16:00 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/6020943https://blog.youkuaiyun.com/rabbitlzx/article/details/6020943rabbitlzxFri, 19 Nov 2010 10:55:00 +0800https://blog.youkuaiyun.com/rabbitlzx/article/details/6020929https://blog.youkuaiyun.com/rabbitlzx/article/details/6020929rabbitlzxFri, 19 Nov 2010 10:50:00 +0800这几天遇到的问题，就是发现，sqlconnection.open在数据库已经断开连接（如停掉sql service）时还能正常返回，没有错误发生，经过研究发现这是因为ado.net默认采取了连接池技术，当断开连接后，sqlconnection.open仍然可以从池中返回conn，但是已经是无效的，但是只有当你使用它的时候才会知道它是无效的，sqlconnection.open会到连接池中查看是否有对应的连接，有的话就拿出来，没有才会创建，当数据库断开后，在程序中调用sqlconnection.o]]>https://blog.youkuaiyun.com/rabbitlzx/article/details/6013917https://blog.youkuaiyun.com/rabbitlzx/article/details/6013917rabbitlzxWed, 17 Nov 2010 09:24:00 +0800