VB中DATAgrid问题

来源:百度知道 编辑:UC知道 时间:2024/06/24 12:16:40
运行下列代码手 datagrid控件没有任何反应 数据库已经链接 使用ADODC控件链接SQL
Sub refreshgrid()
adodcscore.RecordSource = "select s.st_id as 学号,s.st_name as 姓名," _
& "sc.score as 成绩 from st_info s,s_c_info sc " _
& "where s.cl_name='" + Trim(cmbcls.Text) _
& "'and s.st_id=sc.st_id and sc.c_no='" _
& Trim(strCNo) & "'"
adodcscore.Refresh
grdscore.Refresh

End Sub

Private Sub DataGrid1_Click()

End Sub

Private Sub cmbcls_Click()
refreshgrid
If adodcscore.Recordset.EOF And adodcscore.Recordset.BOF Then
MsgBox cmbcls.Text & "无" & cmbcname.Text & "成绩", , "成绩信息"
End If

End Sub

Private Sub cmbcname_Change()
strCNo = cmbcname.BoundText
refreshgrid
End Sub

Private Sub cmdadd_Click()
If cmbcname.Text = "" Or cmbcls.Text = "" Then
MsgBox "请选择课程名称与班级

cmbcls.AddItem 应该是给ComBox下拉选项添加内容,想让DataGrid有东西,在Form_Load里面
adodcscore.Refresh
下面加上:
Set grdscore.DataSource = adodcscore
下来看一看你的控件名是否与代码中相一致!

设置datagrid控件数据源为ADODC控件