Question

vb 数字转文本 数据库

With ListView1
Set LV = .ListItems.Add(, , rs!Name) '文本类型可以读
LV.SubItems(6) = rs!Dj_Id 'rs!DjCat_Id '数字类型读不出？
在VB的listview中读取段名数字类型的Cat_Id 段,出错,而文本类型就可以读.
请问在不改动ACC的情况下,我该怎么在VB代码里将那个数字类型的段所有值读出来?

Answer 1

没看懂你的问题
1、试试强制转换字符串 cstr(rs!DjCat_Id)

2、试试在SQL语句中转换 select Name,cast(DjCat_Id as vchar) as DjCat_Id1,....... from 表名 ....

Answer 2

LV.SubItems(6) = cstr(rs!Dj_Id) 'rs!DjCat_Id

Answer 3

LV.SubItems(6) = iif(rs!Dj_Id is nothing,"","" & rs!Dj_Id)

Answer 4

str

Answer 5

就是str()