这是SQL Server的例子,你改成Access的就可以了Private Sub Form_Load()
Dim conn As ADODB.Connection
Dim rst As ADODB.RecordsetSet conn = New ADODB.Connection
Set rst = New ADODB.Recordset
conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=test;Data Source=SERVER"
conn.Open , "sa"rst.CursorLocation = adUseClientrst.Open "select * from table1", conn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rstEnd Sub
Dim conn As ADODB.Connection
Dim rst As ADODB.RecordsetSet conn = New ADODB.Connection
Set rst = New ADODB.Recordset
conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=test;Data Source=SERVER"
conn.Open , "sa"rst.CursorLocation = adUseClientrst.Open "select * from table1", conn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rstEnd Sub
解决方案 »
- 请教高人如何使用 Excel VBA设置数据线的宽度
- 高分求救SQLSERVER2000问题
- 如何用VB编写一个注册控件OCX的代码
- 请高手指点!求救!!!!正态分布曲线问题!
- 可以编辑datagrid的内容吗?
- 可是在SQL Server里都可以在哪里写T-SQL语句呢?
- 十分感激liangfang(一齐听歌〖眼红红〗),接分!!
- txtItem_GotFocus
- 怎么用HttpWebRequest访问一个网站,然后提取数据.但这个网需先登陆
- 难道是颜色的问题??????????急!!!!!!!!!!!
- 刚做好的编程技术文章系统,欢迎来翻阅(VB)等技术文章.
- 功能键在COMMAND命令中怎么用
set .datasource=rs
.Refresh
end with