引用DAO库
Dim DB As Database
Dim RS As Recordset
Set DB = OpenDatabase(gAppPath & "\数据库文件名.mdb", dbDriverComplete, False, ";PWD=xxxx")
Set RS = DB.OpenRecordset("SELECT * FROM config")
With RS
If .RecordCount > 0 Then
.MoveFirst
ID = .Fields("ID")
User = .Fields("User")....
Dim DB As Database
Dim RS As Recordset
Set DB = OpenDatabase(gAppPath & "\数据库文件名.mdb", dbDriverComplete, False, ";PWD=xxxx")
Set RS = DB.OpenRecordset("SELECT * FROM config")
With RS
If .RecordCount > 0 Then
.MoveFirst
ID = .Fields("ID")
User = .Fields("User")....
解决方案 »
- 编译成功,生成EXE时就出问题啦。急急急。
- 一个关于VB数据库的申明问题
- 关于 ImgAdmin.DeletePages (删除单页问题)
- 高分奖劢:实现如下例子即可...
- 请问,API函数里有可以获取ZIP压缩文件里的文件信息的函数吗?
- listbox的SORT属性到底按什么顺序排序?
- 急!!!!100分
- panel控件在哪里呀,VB有没有呀?
- 请教:这个程序如何实现?谢谢。百分相送
- mshflexgrid的backcolorsel属性设置的问题???
- 如何实现TEXTBOX的格式化录入,如限制只能录入整数
- 如何使 PICTURE 或 IMAGE 支持动态GIF和除VB自身支持的格式外的其他图象格式?
dim db as recordset
dim conn as connection
set db=new recordset
set conn=new connection
conn.connectionstring="………………" /
db.activateconnecyion=conn
db.op "sql语句"
dim conn as new adodb.connection
dim comm as new adodb.command
dim rs as new adodb.recordsetconn.open ConnectionSTRrs.curosrlocation=adclient
rs.open SQLStr,conn,adOpenKeyset, adLockPessimisticrs即为你要的数据集
在窗体上放一个datagrid1
然后 set datagrid1.datasource= rs嘿嘿
Dim DB As Database
Dim RS As Recordset
Set DB = OpenDatabase(App.Path & "\数据库文件名.mdb", dbDriverComplete, False, ";PWD=xxxx")
Set RS = DB.OpenRecordset("SELECT * FROM config")
Dim AdoRst As New ADODB.Recordset
Dim SQL As String
ConStr = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & App.Path & "\*.mdb"
AdoCon.Open ConStr
sql="select * from TableName"
AdoRst.Open SQL, AdoCon, 1, 3
'adoOpen(数据库名,表名或SQL语句,建立的Connection对象(关闭数据库时使用),打开后的RecordSet对象名)
Public Function adoOpen(DbName As String, RsName As String, conn As ADODB.Connection, rs As ADODB.Recordset)
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
Dim connstr As String
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DbName & ".MDB"
conn.Open connstr
rs.CursorLocation = adUseClient
rs.Open RsName, conn, adOpenKeyset, adLockPessimistic
End Function
调用实例:
'调用adoOpen函数,将"lists.dbf"数据库中的"SMOMDTYP"表打开,
Call adoOpen("lists", "SMOMDTYP", connRestock, rsRestock)