Public Function ExcuteSQL(sql As String) As ADODB.Recordset
Dim mycommection As Connection
Dim myrecordset As Recordset
'连接数据库
Set myconnection = New Connection
Set myrecordset = New Recordset
mypath = App.Path & "\mis.mdb"
myconnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & mypath
myrecordset.CursorLocation = adUseClient
myrecordset.Open sql, myconnection, adOpenKeyset, adLockOptimistic
Set ExcuteSQL = myrecordset
Set mycommection = Nothing
Set myrecordset = Nothing
End FunctionPrivate Sub cmdok_Click()
Dim sql As String
Dim myrecordset As ADODB.Recordset
spl = "select * from communication"
Set myrecordset = ExcuteSQL(sql)
Set DataGrid1.DataSource = myrecordset
DataGrid1.Refresh
End Sub当程序运行到:
myrecordset.Open sql, myconnection, adOpenKeyset, adLockOptimistic
句时出错,
错误提示:没有为命令对象设置命令。
请各位大虾指点,不胜感激!
Dim mycommection As Connection
Dim myrecordset As Recordset
'连接数据库
Set myconnection = New Connection
Set myrecordset = New Recordset
mypath = App.Path & "\mis.mdb"
myconnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & mypath
myrecordset.CursorLocation = adUseClient
myrecordset.Open sql, myconnection, adOpenKeyset, adLockOptimistic
Set ExcuteSQL = myrecordset
Set mycommection = Nothing
Set myrecordset = Nothing
End FunctionPrivate Sub cmdok_Click()
Dim sql As String
Dim myrecordset As ADODB.Recordset
spl = "select * from communication"
Set myrecordset = ExcuteSQL(sql)
Set DataGrid1.DataSource = myrecordset
DataGrid1.Refresh
End Sub当程序运行到:
myrecordset.Open sql, myconnection, adOpenKeyset, adLockOptimistic
句时出错,
错误提示:没有为命令对象设置命令。
请各位大虾指点,不胜感激!
解决方案 »
- VB中如何将DataGrid中数据添加到accessr指定字段中?
- treeview控件中如何返回某个父节点下子节点的数目?
- 如何实现让窗口可以最小化,但又不让用户调整窗口的大小?
- vsflexgrid将能不能更新网格中的数据
- 用VB+SQL Server2000开发的一个软件,要放在不同的机器里运行。怎么才能让软件读取它的SQL Server2000的名字?
- 我就不信,没有人回答这个问题,我就疯狂放分了~~~~~~~~(vb论坛人气怎么这么小呢?)
- vb中ActiveMovie控件的问题?
- 3170错误如何在安装包中解决掉而不是用手工解决。
- 有谁知道怎么释放一个byte变量,数组变量? @星期六,100分大放送啦@
- 如何读取txt文件中的任意一行数据?
- 超简单问题,变量传值!
- 关于流程图的问题~大虾请帮下忙(紧急哦!)
Dim myrecordset As Recordset
'连接数据库
Set myconnection = New Connection
Set myrecordset = New Recordset以上改成
dim mycommection as adodb.connection
Dim myrecordset As adodb.Recordset
Public Function ExcuteSQL(sql As String) As ADODB.Recordset
Dim myconnection As Connection
Dim myrecordset As Recordset
'连接数据库
Set myconnection = New Connection
Set myrecordset = New Recordset
mypath = App.Path & "\mis.mdb"
myconnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & mypath
myrecordset.CursorLocation = adUseClient
myrecordset.Open sql, myconnection, adOpenKeyset, adLockOptimistic
Set ExcuteSQL = myrecordset
Set myconnection = Nothing
Set myrecordset = Nothing
End FunctionPrivate Sub cmdok_Click()
Dim sql As String
Dim myrecordset As ADODB.Recordset
spl = "select * from communication"
Set myrecordset = ExcuteSQL(sql)
Set DataGrid1.DataSource = myrecordset
DataGrid1.Refresh
End Sub
Private conn As adodb.Connection
Private rs As adodb.RecordsetPrivate Function ExcuteSQL(sql As String) As adodb.Recordset
Dim apppath As String
Dim DbFileName As String
Dim ConnectString As String
Dim i As Integer
Set conn = New adodb.Connection
If Right(App.Path, 1) = "\" Then
apppath = App.Path
Else
apppath = App.Path & "\"
End If
DbFileName = apppath & "article.mdb"
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
DbFileName & ";Persist Security Info=False;"
On Error Resume Next
With conn
.CursorLocation = adUseClient
.Open ConnectString
End With
Set rs = New adodb.Recordset
rs.Open sql, conn, 1, 3
If rs.EOF Then
Exit Function
End If
Set ExcuteSQL = rs
End FunctionPrivate Sub Command1_Click()
Dim sql As String
sql = "select id,mc from mz"
Set DataGrid1.DataSource = ExcuteSQL(sql)
DataGrid1.Refresh
End Sub