今天在做查询的时候出现了关键字select附近有语法错误!代码如下:Public conn As New ADODB.Connection
Public rs As New ADODB.Recordset
Private Sub Command1_Click()
'If (Combo1.Text = Combo1.List(0)) = True Then
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=图书管理;Data Source=JH"
conn.Open
rs.Open "select bookname from newbook where bookname ='" + Text1.Text + "'", conn, adOpenKeyset, adLockOptimistic, -1
If rs.RecordCount > 0 Then
Adodc1.RecordSource = "select bookname from newbook where bookname ='" + Text1.Text + "'"
Set DataGrid1.DataSource = Adodc1
'Adodc1.Refresh
Else: MsgBox "没有该记录", 1 + 48, "提示" '把参数改成 & Chr(13) &
rs.Close
Exit Sub
End If
conn.Close
'End If
End Sub不知道哪里有错误,望高手指点!
Public rs As New ADODB.Recordset
Private Sub Command1_Click()
'If (Combo1.Text = Combo1.List(0)) = True Then
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=图书管理;Data Source=JH"
conn.Open
rs.Open "select bookname from newbook where bookname ='" + Text1.Text + "'", conn, adOpenKeyset, adLockOptimistic, -1
If rs.RecordCount > 0 Then
Adodc1.RecordSource = "select bookname from newbook where bookname ='" + Text1.Text + "'"
Set DataGrid1.DataSource = Adodc1
'Adodc1.Refresh
Else: MsgBox "没有该记录", 1 + 48, "提示" '把参数改成 & Chr(13) &
rs.Close
Exit Sub
End If
conn.Close
'End If
End Sub不知道哪里有错误,望高手指点!
解决方案 »
- 请问怎么设置DTPicker控件的背景颜色,哪个属性?谢谢!
- 有没有将字符串转换成条件表达式的东东(函数)?
- 想利用获取系统时间的方法,来进行延时,可是利用Time取得的时间格式不能直接相减,怎么办?
- ListView显示图标问题?
- 好
- 各位大侠,救命!!!!!!!!!!!!!!
- 文件操作的问题,请大家来看看(在线等待)
- picturebox.Circle 在不同的点上画相同大小的圆效果不一致呀,有的大有的小
- 窗体间如何传递参数
- 请教各位高手,如何向系统发送Ctrl+Alt+Del按键,大大加分!!!!!!!!!!!!!!!!
- 向各位老师敬礼:导出excel的基础问题请教,谢谢先.
- 关于datareport的问题,急!!!
-------------------------------------------------------
家居新饰界(新店开张,价格好优惠哦):
http://shop33743096.taobao.com