Re: how to reference feild data -

From: "Richard Mueller" <rlmueller-NOSPAM@xxxxxxxxxxxxxxxxxxxx>
Date: Tue, 3 Jan 2006 17:44:33 -0600

barret bonden wrote:

> 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

Hi,

I use (assuming the field name is "Last"):

rs.Fields("Last").Value

Also, you can experiment to find the index with:

For i = 0 To rs.Fields.Count - 1
ListBox1.Items.Add(rs.Fields(i).Name & ": " & rs.Fields(i).Value)
Next

In any case, you want the Value property, not the Name property, but you can
reference the proper field by specifing the name or the index.

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net

.

Follow-Ups:
- Re: how to reference feild data -
  - From: barret bonden

References:
- how to reference feild data -
  - From: barret bonden

Prev by Date: Re: Identity_Insert
Next by Date: RE: Using Rich Text formating with InfoPath
Previous by thread: how to reference feild data -
Next by thread: Re: how to reference feild data -
Index(es):
- Date
- Thread

Relevant Pages

Re: VB.Net not building added file
... What was happening was that I still had to manually add a reference to ... I
would have thought that if the project was building the .dll, ... Imports System.Data.SqlClient
... Dim SqlConnection1 As SqlConnection ... (microsoft.public.dotnet.languages.vb)
Re: VB.Net not building added file
... What was happening was that I still had to manually add a reference to it. ...
Imports System.Data.SqlClient ... Dim SqlConnection1 As SqlConnection ...
Dim myDbObject As New DbObject ... (microsoft.public.dotnet.languages.vb)
Re: how to reference feild data -
... >> syntax I'm used to in Access doesn't seem to work - ... >> Imports
System.Data ... >> Dim conn As New ADODB.Connection ... > reference
the proper field by specifing the name or the index. ... (microsoft.public.data.ado)
Re: SQLXMLBulkLoad Question (Please help)
... Imports SQLXMLBULKLOADLib ... I have reference to Interop.SQLDMO and
Interop.SQLXMLBULKLOADLib ... >> Dim dsOld As New DataSet ... (microsoft.public.sqlserver.xml)
RE: open arguments.
... The original to add a complete new quote, one to edit a quote and one to ...
Dim rst As Recordset ... This opens the form specified by stDocName in data entry
mode and passes the ... You want to store your reference so poke it into the reference
field. ... (microsoft.public.access.modulesdaovba)