从数据库表里循环出来了ID ,NAME放在combo 里了,想把ID隐藏,只显示NAME,并选择NAME时能获取响应的ID,
怎么办?
While Not Adodc_dkfangshi.Recordset.EOF
CompanyID = Adodc_dkfangshi.Recordset.Fields("DKFangShiID")
CompanyName = Adodc_dkfangshi.Recordset.Fields("DKFangShiName")
IDName = CompanyID + " " + CompanyName
Combo_dkFangShi.AddItem IDName
Adodc_dkfangshi.Recordset.MoveNext
Wend
怎么办?
While Not Adodc_dkfangshi.Recordset.EOF
CompanyID = Adodc_dkfangshi.Recordset.Fields("DKFangShiID")
CompanyName = Adodc_dkfangshi.Recordset.Fields("DKFangShiName")
IDName = CompanyID + " " + CompanyName
Combo_dkFangShi.AddItem IDName
Adodc_dkfangshi.Recordset.MoveNext
Wend
解决方案 »
- vb 如何一个工程中加载另一个工程图片
- 在文本框里使用xxx.SetFocus,如何才能触发Validate事件
- 欢迎大家到我的破站做客~没时间维护想请高手维护http://infofox.org
- 如何用sql 语句或其它方式在程序中设定access 表中字段的"unicode 压缩"属性?
- 如何调用Excel对象新建一个.xls文件?
- 忘记的老问题,不好意思(当是送分了)(在线等)
- 请问DAO支持含LIKE的SQL语句吗?应该如何书写呀?
- excel表如何导入SQL
- 泰山,(这名字怎么感觉像占别人便宜似的),你再不快点救命,我就拿弹弓子打你家玻璃了~~
- 有关treeview的两个很实际的问题!
- 贪,你能判断出来这中从属关系吗?或者说VB如何判断从属关系!
- 非技术分有什么用处?
dim i as integer
i=0
While Not Adodc_dkfangshi.Recordset.EOF
CompanyID = Adodc_dkfangshi.Recordset.Fields("DKFangShiID")
CompanyName = Adodc_dkfangshi.Recordset.Fields("DKFangShiName")
IDName = CompanyID + " " + CompanyName
Combo_dkFangShi.AddItem companyname,i
Combo_dkFangShi.itemdata(0)=companyid
Adodc_dkfangshi.Recordset.MoveNext
Wend
如果你的id是整型,可以这样做:
dim i as integer
i=0
While Not Adodc_dkfangshi.Recordset.EOF
CompanyID = Adodc_dkfangshi.Recordset.Fields("DKFangShiID")
CompanyName = Adodc_dkfangshi.Recordset.Fields("DKFangShiName")
IDName = CompanyID + " " + CompanyName
Combo_dkFangShi.AddItem companyname,i
Combo_dkFangShi.itemdata(i)=companyid
i=i+1
Adodc_dkfangshi.Recordset.MoveNext
Wend
改成
IDName = CompanyName