麻烦各位大虾给点提示 Dim txtSQL As String
Dim mrc As ADODB.Recordset
Dim MsgText As String
txtSQL = "SELECT * FROM userInfo"
Set mrc = ExecuteSQL(txtSQL, MsgText)
Set dGrid.DataSource = mrc
Public Function ExecuteSQL(ByVal SQL As String, MsgString As String) As ADODB.Recordset
'执行sql语句,并返回记录集对象
Dim connect As ADODB.Connection
Dim result As ADODB.Recordset
Dim sTokens() As String
'异常处理
On Error GoTo ExecuteSQL_Error
'用split函数产生一个包含各个子串的数组
sTokens = Split(SQL)
Set connect = New ADODB.Connection
'打开连接
connect.Open ConnectString
'判断查询语句内容
If InStr("INSERT,DELETE,UPDATE", UCase$(sTokens(0))) Then
connect.Execute SQL
MsgString = sTokens(0) & "query successful"
Else
Set result = New ADODB.Recordset
result.Open Trim$(SQL), connect, adOpenKeyset, adLockOptimistic
'返回记录集对象
Set ExecuteSQL = result
MsgString = "查询到" & result.RecordCount & "条记录"
End If
ExecuteSQL_Exit:
Set result = Nothing
Set connect = Nothing
Exit Function
ExecuteSQL_Error:
MsgString = " 查询错误:" & Err.Description
Resume ExecuteSQL_Exit
End Function
Dim mrc As ADODB.Recordset
Dim MsgText As String
txtSQL = "SELECT * FROM userInfo"
Set mrc = ExecuteSQL(txtSQL, MsgText)
Set dGrid.DataSource = mrc
Public Function ExecuteSQL(ByVal SQL As String, MsgString As String) As ADODB.Recordset
'执行sql语句,并返回记录集对象
Dim connect As ADODB.Connection
Dim result As ADODB.Recordset
Dim sTokens() As String
'异常处理
On Error GoTo ExecuteSQL_Error
'用split函数产生一个包含各个子串的数组
sTokens = Split(SQL)
Set connect = New ADODB.Connection
'打开连接
connect.Open ConnectString
'判断查询语句内容
If InStr("INSERT,DELETE,UPDATE", UCase$(sTokens(0))) Then
connect.Execute SQL
MsgString = sTokens(0) & "query successful"
Else
Set result = New ADODB.Recordset
result.Open Trim$(SQL), connect, adOpenKeyset, adLockOptimistic
'返回记录集对象
Set ExecuteSQL = result
MsgString = "查询到" & result.RecordCount & "条记录"
End If
ExecuteSQL_Exit:
Set result = Nothing
Set connect = Nothing
Exit Function
ExecuteSQL_Error:
MsgString = " 查询错误:" & Err.Description
Resume ExecuteSQL_Exit
End Function
解决方案 »
- 哪位好心的师傅帮我做个VB浮雕效果的作业啊?谢谢谢谢。
- 怎样用InternetAPI取得HTTP文件头信息
- 请问这段语句错在什么地方啊?
- 有N组数,指定每组固定取0-2个数,然后列出所有组合.....有什么好算法?
- 谁知道VB写的ACTIVEX DLL中的form 是否支持DDE技术?
- 各位帮个忙,小弟要搞个IT讲座,想现场编个网络小游戏,要求游戏有趣好玩,能吸引人的眼球。马上给分。不够加再!!
- 碰到下面几个问题,请高手指点一下!
- 我的DLL里有个FORM,我想在打开DLL的FORM时
- pdf文件能转换成word吗?
- 怎么用API函数来制作 Split 条?
- vb+access 关于 Con.Recordset.RecordCount
- 一个读数据的问题
Set connect = New ADODB.Connection
后面加上一句
connect.CursorLocation = adUseClient