dim con as adodb.connection
dim rs as new recordset
set con=new connection
con.connectionstring="Provider=Microsoft.Jet.OLEDB.3.51;"&_
"Data Source=access表的所在路径"
con.openrs.open "select * from 表名",con,adOpenKeyset,adLockPessimistic
dim rs as adodb.recordset
set rs=new recordset
rs.movefrist
listview,例如,表里有ID(PK),NAME,TEL。。
dim cnn as connection
dim rs as recorder
dim new as listitems
set cnn=new connection
cnn.open"......."
set rs=new rescorder
rs.open".........."
set newitem=listview.listitems.add( , ,rs("ID"))
newitem.subitems(1)=rs(姓名)
newitem.subitems(2)=rs(单位)
.
.
.
rs.movenext
loop
Public Declare Function GetVolumeInformation& Lib "kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As String, ByVal pVolumeNameBuffer As String, ByVal nVolumeNameSize As Long, lpVolumeSerialNumber As Long, lpMaximumComponentLength As Long, lpFileSystemFlags As Long, ByVal lpFileSystemNameBuffer As String, ByVal nFileSystemNameSize As Long)
Public Const MAX_FILENAME_LEN = 256
Public Function DriveSerial(ByVal sDrv As String) As Long
Dim RetVal As Long
Dim str As String * MAX_FILENAME_LEN
Dim str2 As String * MAX_FILENAME_LEN
Dim a As Long
Dim b As Long
Call GetVolumeInformation(sDrv & ":\", str, MAX_FILENAME_LEN, RetVal, a, b, str2, MAX_FILENAME_LEN)
DriveSerial = RetVal
End Function