一个关于在VB中函数定义的问题
来源:百度知道 编辑:UC知道 时间:2024/06/21 04:38:46
' 显示用户信息
Sub showinfo(ID As String)
Dim personInfo, courseinfo As Recordset '以记录
Dim sqlstr, str As String
'读取学生个人信息
sqlstr = "select*from 学生信息 where 学号='" & ID & "'"
Set personInfo = courseDB.OpenRecordset(sqlstr, dbOpenSnapshot, dbReadOnly)
'读取学生已选课信息,这里只读取了课程名
sqlstr = "SELECT[课程].[课程名称]"
sqlstr = sqlstr & " FORM 课程 INNER JOIN 学号课程 ON [课程].[课程编号]=[学号课程].[课程编号]"
sqlstr = sqlstr & "WHERE[学号课程].[学号]='" & ID & "'"
Set courseinfo = courseDB.OpenRecordset(sqlstr, dbOpenSnapshot, dbReeadOnly)
For i = 0 To personInfo.Fields.Count - 1
infolab(i).Caption = personInfo.Fields(i).Name & ":" & personInfo.Fields(i).Value
Next
While Not (courseinfo.EOF)
str = str & " " & courseinfo.Fields("课程名称
Sub showinfo(ID As String)
Dim personInfo, courseinfo As Recordset '以记录
Dim sqlstr, str As String
'读取学生个人信息
sqlstr = "select*from 学生信息 where 学号='" & ID & "'"
Set personInfo = courseDB.OpenRecordset(sqlstr, dbOpenSnapshot, dbReadOnly)
'读取学生已选课信息,这里只读取了课程名
sqlstr = "SELECT[课程].[课程名称]"
sqlstr = sqlstr & " FORM 课程 INNER JOIN 学号课程 ON [课程].[课程编号]=[学号课程].[课程编号]"
sqlstr = sqlstr & "WHERE[学号课程].[学号]='" & ID & "'"
Set courseinfo = courseDB.OpenRecordset(sqlstr, dbOpenSnapshot, dbReeadOnly)
For i = 0 To personInfo.Fields.Count - 1
infolab(i).Caption = personInfo.Fields(i).Name & ":" & personInfo.Fields(i).Value
Next
While Not (courseinfo.EOF)
str = str & " " & courseinfo.Fields("课程名称
infolab(i) 这应该是你画面上的一个label控件!~
可能你这程序是照搬别人的或者别人给你的吧
你看看你画面上有没有添加这个label数组
要是添加了再看看名字改没改对~