声明部分:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cmd As New Command
Dim strSelect As String
Dim strConnection As String
代码部分:
Private Sub Form_Load() strConnection = "Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source = " & App.Path & "\MBA.mdb;"
cnn.Open strConnection
@ cnn.CursorLocation = aduserclient
strSelect = "Select * from 交易"
rs.Open strSelect, cnn
Set DataGrid1.DataSource = rsEnd Sub
打@那行总出错,为什么????
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cmd As New Command
Dim strSelect As String
Dim strConnection As String
代码部分:
Private Sub Form_Load() strConnection = "Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source = " & App.Path & "\MBA.mdb;"
cnn.Open strConnection
@ cnn.CursorLocation = aduserclient
strSelect = "Select * from 交易"
rs.Open strSelect, cnn
Set DataGrid1.DataSource = rsEnd Sub
打@那行总出错,为什么????
解决方案 »
- 问一个16进制转10进制问题?
- 求助vb高手...VSFlexGrid实现类似treeview效果...
- “Debug.Print Adodc1.RecordSource” 有什么用??
- 【帐篷里的尸体】
- activex cab 控件的问题。..
- [抢答,50分全给第一个解决的人] FlexGrid 中如何把网格和 RecordSet 绑定
- 大家有做过cad二次开发的么 能指点小弟一下么
- 用VC写的DLL在VB中调用,请问怎样传递字符串数组BOOL __stdcall SendArray(char szbuff[20][100]),谢谢~
- 如何减掉没用的数字
- 怎样动态加载显示我所需要的窗体?
- 打包后安装出现的错误
- 怎样关闭已打开的数据库?
Dim rs As New ADODB.Recordset
Dim cmd As New Command
Dim strSelect As String
Dim strConnection As String'代码部分:Private Sub Form_Load()
strConnection = "Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source = " & App.Path & "\MBA.mdb;"
cnn.Open strConnection
cnn.CursorLocation = adUseClient
strSelect = "Select * from 交易"
rs.Open strSelect, cnn
Set DataGrid1.DataSource = rs
End Sub