with adodc1
.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=
c:\data.mdb;PersistSecurityInfo=False"
.commandtype=cmdtext
.recordsource=sql = "select * from 数据表"
.refresh
end with
set datagrid1.datasource=adodc1
.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=
c:\data.mdb;PersistSecurityInfo=False"
.commandtype=cmdtext
.recordsource=sql = "select * from 数据表"
.refresh
end with
set datagrid1.datasource=adodc1
就好了,可是datagrid不管用啊!这究竟是为什么?神啊!救救我吧。
Dim rs As New ADODB.Recordset
Dim strsql As String
Dim sql As String
strconn= "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\data.mdb;PersistSecurityInfo=False"
conn.Open strconn
sql = "select * from 数据表"
rs.Open sql, conn, adOpenKeyset, adLockOptimistic, adCmdText
Set datagrid1.datasourse=rs
不用ADODC控件
要么用adodc
要么用adodb
Dim ado As Adodc
Dim dbgrid As DataGrid
Set ado = vado
Set dbgrid = vdbgrid
With ado
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\vb_project\bet\bet.mdb;Persist Security Info=False"
.RecordSource = "select bet_no,no_1,no_2,no_3,no_4,no_5,no_6,no_7,no_8 from bet order by bet_no desc"
.Visible = False
End With
ado.Refresh
Set dbgrid.DataSource = ado
dbgrid.Refresh
With dbgrid
.Columns(0).Caption = "彩票期数"
.Columns(1).Caption = "第一号"
.Columns(2).Caption = "第二号"
.Columns(3).Caption = "第三号"
.Columns(4).Caption = "第四号"
.Columns(5).Caption = "第五号"
.Columns(6).Caption = "第六号"
.Columns(7).Caption = "第七号"
.Columns(8).Caption = "特殊号"
.Columns(0).Width = 850
.Columns(1).Width = 650
.Columns(2).Width = 650
.Columns(3).Width = 650
.Columns(4).Width = 650
.Columns(5).Width = 650
.Columns(6).Width = 650
.Columns(7).Width = 650
.Columns(8).Width = 650
.Columns(0).AllowSizing = False
.Columns(1).AllowSizing = False
.Columns(2).AllowSizing = False
.Columns(3).AllowSizing = False
.Columns(4).AllowSizing = False
.Columns(5).AllowSizing = False
.Columns(6).AllowSizing = False
.Columns(7).AllowSizing = False
.Columns(8).AllowSizing = False
.AllowRowSizing = False
.AllowUpdate = False
.AllowDelete = False
.Width = 6600
End With
End Sub
好象没问题啊