求救!SOS 我用DATAGRID绑定了一个记录集(数据来自两个表的连接)。我想让用户在GRID上修改数据临时使用。也就是说我的数据不需要更新。但是出现了两个问题:一是有时我获取用户修改后的数据时出现实时错误6160,说数据不可访问。二是在退出窗体时提示记录集是只读的。请问要怎么才能解决这个问题,急!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Public Function ExecuteSQL(ByVal sql _ As String, MsgString As String) _ As ADODB.Recordset 'executes SQL and returns Recordset ' ConnectString = "DBQ=" + CurDir("") + DataBaseName + ";pwd=;DefaultDir=;Driver={Microsoft Access Driver (*.mdb)};" ConnectString = "DBQ=" & DataBaseName & ";DefaultDir=;Driver={Microsoft Access Driver (*.mdb)};" Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim sTokens() As String On Error GoTo ExecuteSQL_Error sTokens = Split(sql) Set cnn = New ADODB.Connection cnn.Open ConnectString If InStr("INSERT,DELETE,UPDATE", _ UCase$(sTokens(0))) Then cnn.Execute sql MsgString = sTokens(0) & _ " query successful" Else Set rst = New ADODB.Recordset rst.Open Trim$(sql), cnn, _ adOpenKeyset, _ adLockOptimistic 'rst.MoveLast 'get RecordCount Set ExecuteSQL = rst MsgString = "²éѯµ½" & rst.RecordCount & _ " Ìõ¼Ç¼ " End If Set rst = Nothing Set cnn = Nothing Exit FunctionExecuteSQL_Exit: Set rst = Nothing Set cnn = Nothing Exit Function ExecuteSQL_Error: MsgString = "²éѯ´íÎó: " & _ Err.Description Resume ExecuteSQL_ExitEnd Function 请问我这段代码哪里错了呢? 请各位老师帮忙看看存在的错误,谢谢 怎样限制RichTextBox输入 贪,你能判断出来这中从属关系吗?或者说VB如何判断从属关系! 跪求高手帮忙!请高手进来解决!一定给分! 如何修改datagrid中的一个单元格。 载了一个MIDI钢琴的程序,但有些问题 FAQ是什么意思? 如何从一个窗口中打开一个应用程序,以及如何挂起 关于UDP对等聊天 求救!!!用DATA控件读取Excel时产生数值字段溢出错误(NO:3349) 关于crystal report 9 在vb中使用的两个基础问题。
As String, MsgString As String) _
As ADODB.Recordset
'executes SQL and returns Recordset
' ConnectString = "DBQ=" + CurDir("") + DataBaseName + ";pwd=;DefaultDir=;Driver={Microsoft Access Driver (*.mdb)};"
ConnectString = "DBQ=" & DataBaseName & ";DefaultDir=;Driver={Microsoft Access Driver (*.mdb)};"
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sTokens() As String
On Error GoTo ExecuteSQL_Error
sTokens = Split(sql)
Set cnn = New ADODB.Connection
cnn.Open ConnectString
If InStr("INSERT,DELETE,UPDATE", _
UCase$(sTokens(0))) Then
cnn.Execute sql
MsgString = sTokens(0) & _
" query successful"
Else
Set rst = New ADODB.Recordset
rst.Open Trim$(sql), cnn, _
adOpenKeyset, _
adLockOptimistic
'rst.MoveLast 'get RecordCount
Set ExecuteSQL = rst
MsgString = "²éѯµ½" & rst.RecordCount & _
" Ìõ¼Ç¼ "
End If
Set rst = Nothing
Set cnn = Nothing
Exit Function
ExecuteSQL_Exit:
Set rst = Nothing
Set cnn = Nothing
Exit Function
ExecuteSQL_Error:
MsgString = "²éѯ´íÎó: " & _
Err.Description
Resume ExecuteSQL_Exit
End Function