Private Sub Form_Load() Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ IIf(Len(App.Path) > 3, App.Path & "\", App.Path) & "\test.mdb;Persist Security Info=False" Adodc1.CommandType = adCmdText Adodc1.RecordSource = "Select * from table1" Set DataGrid1.DataSource = Adodc1 End Sub
rs.open strSql,cn,1,3set datagrid1.datasource=rs
错了,你说不用控件的,应该是 Dim mconn As New ADODB.Connection Dim mrst As New ADODB.Recordset Private Sub Form_Load() mconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ IIf(Len(App.Path) > 3, App.Path & "\", App.Path) & "\test.mdb;Persist Security Info=False"
mrst.Open "Select * from table1", mconn, adOpenKeyset, adLockOptimistic Set DataGrid1.DataSource = mrst End Sub
'直接与ACCESS连接Dim Conn As New ADODB.Connection '定义连接 Dim Reset As New ADODB.Recordset '定义记录集 Dim SQLstr As String '定义返回记录集的SQL语句变量 Dim i As Integer'------------------------------------------------------------------------------------- Conn.Open "DBQ="& app.path &\test.mdb" & ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};" '-------------------------------------------------------------------------------------SQLstr = "select * from xx" Reset.CursorType = adOpenStatic Reset.CursorLocation = adUseClient'返回记录集 Reset.Open SQLstr, Conn, , , adCmdText set datagrid1.datasource=Reset
Dim dbAs New ADODB.Connection Dim rb As New ADODB.Recordset .. .. .. . ... set datagrid1.datasource=db datagrid1.datamember=rb
Private Sub Command1_Click() Dim oCn as ADODB.Connection Dim oRS as ADODB.Recordset
oCn.CursorLocation = adUseClient Set oCn = New ADODB.Connection oCn.Open "Provider=SQLOLEDB.1;Data Source=ServerName;Initial Catalog=DataBaseName;User ID=UserID;Password=PWD;" Set oRS = New ADODB.Recordset oRS.Open "Select * From MyTable",oCn Set DataGrid.DataSource = oRS End Sub
Private Sub Command1_Click() Dim rsADO As New ADODB.Recordset Dim cnADO As New ADODB.Connection rsADO.CursorLocation = adUseClient Set cnADO = New ADODB.ConnectionOn Error GoTo ErrorA IbmcnADO.Open "provider=Microsoft OLE DB Provider for Oracle;DATA SOURCE=oradb1;USER ID=usermq1;PASSWORD=8710009;Persist security info=true;" ErrorA: ''MsgBox (Err.Description) MsgBox ("数据库连接错误") Resume NextSet rsADO = New ADODB.Recordset On Error GoTo ErrorB rsADO.Open "select * from cp01",cnADO,adOpenKeyset,adLockOptimistic ErrorB: MsgBox ("记录集错误!") Resume Next Set DataGrid1.DataSource = IbmrsADO两种错误都有,不知道错在哪里呀? 改为 Provider=Oracle Provider for OLE DB 还是有错误?
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
IIf(Len(App.Path) > 3, App.Path & "\", App.Path) & "\test.mdb;Persist Security Info=False"
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "Select * from table1"
Set DataGrid1.DataSource = Adodc1
End Sub
rs.open strSql,cn,1,3set datagrid1.datasource=rs
Dim mconn As New ADODB.Connection
Dim mrst As New ADODB.Recordset
Private Sub Form_Load()
mconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
IIf(Len(App.Path) > 3, App.Path & "\", App.Path) & "\test.mdb;Persist Security Info=False"
mrst.Open "Select * from table1", mconn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = mrst
End Sub
set datagrid1.datasource=rs
Dim Reset As New ADODB.Recordset '定义记录集
Dim SQLstr As String '定义返回记录集的SQL语句变量
Dim i As Integer'-------------------------------------------------------------------------------------
Conn.Open "DBQ="& app.path &\test.mdb" & ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
'-------------------------------------------------------------------------------------SQLstr = "select * from xx"
Reset.CursorType = adOpenStatic
Reset.CursorLocation = adUseClient'返回记录集
Reset.Open SQLstr, Conn, , , adCmdText
set datagrid1.datasource=Reset
Dim rb As New ADODB.Recordset
..
..
..
.
...
set datagrid1.datasource=db
datagrid1.datamember=rb
Dim oCn as ADODB.Connection
Dim oRS as ADODB.Recordset
oCn.CursorLocation = adUseClient
Set oCn = New ADODB.Connection
oCn.Open "Provider=SQLOLEDB.1;Data Source=ServerName;Initial Catalog=DataBaseName;User ID=UserID;Password=PWD;"
Set oRS = New ADODB.Recordset
oRS.Open "Select * From MyTable",oCn
Set DataGrid.DataSource = oRS
End Sub
Dim rsADO As New ADODB.Recordset
Dim cnADO As New ADODB.Connection
rsADO.CursorLocation = adUseClient
Set cnADO = New ADODB.ConnectionOn Error GoTo ErrorA
IbmcnADO.Open "provider=Microsoft OLE DB Provider for Oracle;DATA SOURCE=oradb1;USER ID=usermq1;PASSWORD=8710009;Persist security info=true;"
ErrorA:
''MsgBox (Err.Description)
MsgBox ("数据库连接错误")
Resume NextSet rsADO = New ADODB.Recordset
On Error GoTo ErrorB
rsADO.Open "select * from cp01",cnADO,adOpenKeyset,adLockOptimistic
ErrorB:
MsgBox ("记录集错误!")
Resume Next
Set DataGrid1.DataSource = IbmrsADO两种错误都有,不知道错在哪里呀?
改为 Provider=Oracle Provider for OLE DB 还是有错误?