vb连接SQL数据库
来源:百度知道 编辑:UC知道 时间:2024/05/01 02:02:54
我用VB已经连接上数据库了,可是在连接以后打开另外的窗体的时候,报错
代码如下:
Private Sub Command1_Click()
Dim strSQL As String
Dim ADOrs As New Recordset
ADOrs.ActiveConnection = ADOcn
strSQL = "select * from stu_score"
strSQL = strSQL + " where 学号='" + Combo1.Text + "'"
strSQL = strSQL + "and 课程号='" + Combo2.Text + "'"
ADOrs.Open strSQL
If Not ADOrs.EOF Then
MsgBox "该记录已经存在,不能继续增加", vbCritical + vbOKOnly
Exit Sub
End If
strSQL = "insert into stu_score(学号,课程号,成绩)"
strSQL = strSQL + "values('" + Combo1.Text + "','"
strSQL = strSQL + Combo2.Text + "'," + Str(Val(Text3.Text)) + ")"
ADOcn.Execute strSQL
MsgBox "已成功添加新记录", vbQuestion + vbOKOnly
End Sub
Private Sub Form_Load()
Dim ADOrs As New Recordset
代码如下:
Private Sub Command1_Click()
Dim strSQL As String
Dim ADOrs As New Recordset
ADOrs.ActiveConnection = ADOcn
strSQL = "select * from stu_score"
strSQL = strSQL + " where 学号='" + Combo1.Text + "'"
strSQL = strSQL + "and 课程号='" + Combo2.Text + "'"
ADOrs.Open strSQL
If Not ADOrs.EOF Then
MsgBox "该记录已经存在,不能继续增加", vbCritical + vbOKOnly
Exit Sub
End If
strSQL = "insert into stu_score(学号,课程号,成绩)"
strSQL = strSQL + "values('" + Combo1.Text + "','"
strSQL = strSQL + Combo2.Text + "'," + Str(Val(Text3.Text)) + ")"
ADOcn.Execute strSQL
MsgBox "已成功添加新记录", vbQuestion + vbOKOnly
End Sub
Private Sub Form_Load()
Dim ADOrs As New Recordset
1、声明ADO对象应该这样写:
Dim ADOrs As New ADODB.Recordset
Dim ADOcn As New ADODB.Connection
ADOcn.ConnectionString ="..."
ADOcn.Open
recordset.Open Source, ActiveConnection, CursorType, LockType, Options
2、SQL语句的问题
strSQL = strSQL + "and 课程号='" + Combo2.Text + "'"
本句中 and 前加上一个空格。
Dim ADOrs As New Recordset
ADOrs.ActiveConnection = ADOcn
这两句看着不顺眼
ADOrs是什么?
ADOcn又是什么?
改成Dim ADOrs As New ADODB.Recordset试试?
语句:ADOrs.ActiveConnection = ADOcn
应改为:
SET ADOrs.ActiveConnection = ADOcn