//以下是代码,将X表中的一个字段里的23条数据读取到数组中,label在根据这23条数据分别赋值,下面的代码错在哪里,谢谢大家Dim str As String
Dim x(1 To 23) As String Dim StrConnect As String '定义
StrConnect = App.Path
If Right(StrConnect, 1) <> "\" Then StrConnect = StrConnect + "\"
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & StrConnect & "\data\set.mdb"
Adodc1.ConnectionString = StrConnect
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "SELECT * FROM [x]"
Adodc1.Refresh
For j = 1 To Adodc1.Recordset.RecordCount
x(j) = Adodc1.Recordset.Fields("项目名称")
Adodc1.Recordset.MoveNext
Next jFor i = 0 To Adodc1.Recordset.RecordCount - 1 Labx(i).Visible = True
Textx(i).Visible = True
Labx(i).Caption = x(j)
Next iDisp
Dim x(1 To 23) As String Dim StrConnect As String '定义
StrConnect = App.Path
If Right(StrConnect, 1) <> "\" Then StrConnect = StrConnect + "\"
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & StrConnect & "\data\set.mdb"
Adodc1.ConnectionString = StrConnect
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "SELECT * FROM [x]"
Adodc1.Refresh
For j = 1 To Adodc1.Recordset.RecordCount
x(j) = Adodc1.Recordset.Fields("项目名称")
Adodc1.Recordset.MoveNext
Next jFor i = 0 To Adodc1.Recordset.RecordCount - 1 Labx(i).Visible = True
Textx(i).Visible = True
Labx(i).Caption = x(j)
Next iDisp
解决方案 »
- VB窗口里实时显示SQL里被修改的数据库表记录。
- 如何通过对象名柄 或 对象名称 来返回对象并操纵对象? --- 在线等...即结贴!
- vb中Global与pulic的区别
- 急!关于addnew的问题
- 怎么动态改变水晶报表的数据源呀?
- 请问如何清空treeview里的所有内容,我要添加新的树,全天在线立即给分
- 如何实现输入用户名和密码后自动进入论坛?
- 万年历奖100分
- listbox控件中显示数据库中的记录,我选中了其中的一些项,怎么让下次打开界面时 同样显示那些项目被选中????
- 一个很简单的问题ye也送到20分:如何用函数分解路径和文件名呢?如:c:\game\rpl\pal.exe
- DATAGRID“显示”的数据导出到EXCEL
- 菜鸟求救 希望大虾们给点办法
我将Labx(i).Caption = x(j)改成Labx(i).Caption = x(i + 1)就行了,呵呵,眼花了