ADODB Fields Question

[Ivan Sammut]

Hi,

I am a rookie and trying to use the ADODB recordset.
I got the hang on how ot open a table and navigate thru it.
The only question I have is that currently I am using a kind of field Index
to access a field in the table like
//
Rec1.Open("users",sCon,ADODB.CursorTypeEnum.adOpenForwardOnly,ADODB.LockType
Enum.adLockOptimistic,0);
textBox1.Text = Rec1.Fields[1].Value.ToString()
//
Is it possible to access a field with it's name not with the index.
//
Thanks
Ivan Sammut

 

[Miha Markic]

Hi Ivan,

You should really switch to ADO.NET and get rid of ADO.

 

[Jan Tielens]

Ivan

Try this:
textBox1.Text = Rec1.Fields["NameOfField"].Value.ToString()
Please don't shoot me if it doesn't work, because I haven't tried it...

Although I recommend you to switch to ADO.NET.