how to reference feild data -

Playing about in VB.NET using classic ADO and I cant see how to reference
feild data - the !fieldname

syntax I'm used to in Access doesn't seem to work -



Imports System.Data

Imports ADODB

Imports System.Data.OleDb

Dim conn As New ADODB.Connection

Dim rs As ADODB.Recordset

Dim v As String, i As Int16

conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\t.mdb")

rs = conn.Execute("select * from main")

rs.MoveFirst()

Do While Not rs.EOF

' ListBox1.Items.Add(rs!last) ' DOES NOT WORK

rs.MoveNext()

Loop

For i = 0 To rs.Fields.Count - 1

' ListBox1.Items.Add(rs.Fields(i).Name)

'ListBox1.Items.Add(rs.Fields(i).Name)

Next


.

Relevant Pages