'定义 dim name_1() as String Dim iRecordnum As Integer dim i as Integer --------------------------
ReDim name_1(0)
cn.Open …… rs.Open "select NAME(你的字段名) from student ", cn, 1, 3 iRecordnum = rs.RecordCount for i=1 to iRecordnum ReDim name_1(i) name_1(i)=rs.Fields("NAME") rs.MoveNext next i Set rs = Nothing Set cn = Nothing数据保存在name_1数组中,下标从1开始
rs.open "select * from student ",cn,1,3
do while not rs.eof
name_1=rs!name
debug.pring name_1
rs.movenext
loop
set rs=nothing
or
name_1 = Recordset_1("NAME")
or
name_1 = Recordset_1!NAME
我的recordset不知道怎么open,郁闷,跟我说说呗?
objAdoConn.Open strConn
objAdoRecS.Open strSQL, objAdoConn
...
or
name_1 = Recordset_1("NAME")
or
name_1 = Recordset_1!NAME除了这三个还有
name_1 = Recordset_1.Fields("NAME")
name_1 = Recordset_1.Fields("NAME").value
当然还可以用序数如果你的name字段在记录集中处在第2个字段可以把"NAME"都换成1
rs.Open "select NAME(你的字段名) from student ", cn, 1, 3
Do While Not rs.EOF
debug.pring rs(0)
rs.MoveNext
Loop
rs.colse
Set rs = Nothing
name_1 = Recordset_1(2) '2 为第二个字段
Dim Rst As New ADODB.Recordset
Cnn.CursorLocation = adUseClient
Cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=密码"
Rst.Open "SELECT * FROM 表名", Cnn, adOpenForwardOnly, adLockReadOnly, adCmdText '打开表中所有内容
Set DataGrid1.DataSource = Rst '使用DataGrid控件把数据读入该控件
'name_1只能表中某条数据的值,不能是整个字段的值。所以要加条件打开某条数据然后再付值把
Rst.Open "Select * from 表名 Where Name='" & 变量 & "'" ,cnn, adOpenForwardOnly, adLockReadOnly
name_1 = Recordset_1(2) '2 为第二个字段
dim name_1() as String
Dim iRecordnum As Integer
dim i as Integer
--------------------------
ReDim name_1(0)
cn.Open ……
rs.Open "select NAME(你的字段名) from student ", cn, 1, 3
iRecordnum = rs.RecordCount for i=1 to iRecordnum
ReDim name_1(i)
name_1(i)=rs.Fields("NAME")
rs.MoveNext
next i Set rs = Nothing
Set cn = Nothing数据保存在name_1数组中,下标从1开始