首先引用Microsoft Activex Data Objects 2.x Library
Dim objcon As New ADODB.Connection
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=sqloledb.1;user id=sa;password=密码;Initial Catalog=数据库名;Data Source="
objrs.Open "select * from 表 ", objcon, 3, 1
'再部件中添加DataGrid控件
Set DataGrid1.DataSource = objrs
'access
Dim objcon As New ADODB.Connection
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database password=basic;Data Source=" & App.Path & "\infoTable.mdb"
objrs.Open "select * from infoTable ", objcon, 3, 1
Set DataGrid1.DataSource = objrs
Dim objcon As New ADODB.Connection
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=sqloledb.1;user id=sa;password=密码;Initial Catalog=数据库名;Data Source="
objrs.Open "select * from 表 ", objcon, 3, 1
'再部件中添加DataGrid控件
Set DataGrid1.DataSource = objrs
'access
Dim objcon As New ADODB.Connection
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database password=basic;Data Source=" & App.Path & "\infoTable.mdb"
objrs.Open "select * from infoTable ", objcon, 3, 1
Set DataGrid1.DataSource = objrs
解决方案 »
- 关于mysql中replication的M-S复制问题,master机要正常工作
- Lock wait timeout exceeded; try restarting transaction
- 请教一个error
- 急问:mysql-4.1.12插入字段个数有限制吗?
- 在线急等:jsp+mysql的中文问题,帮忙看一下啊
- fish21cn(阿飞) 请进!!!!
- mysql使用问题!!(在线急切等待ing,给达人送100分)
- 请问mySQL的mm.mysql.driver??
- 有没有朋友用过mysql backup tool做自动备份工具?
- 如何把一张表的数据分布到不同的服务器上?
- MySQL 4.1配置时出现的问题?急!在线等
- mysql安装系统服务问题
并且给用户分配权限~-------
这个可以直接操作
mysql.user表
插入一个用户的用户名和密码,然后再给定权限
或者使用grnt语句分配权限