Filling in TextBox values from a database

[MisterEko]

Hey guys, I am kind of new to VB.NET programming. Right now I am trying to fill in a textbox field with a value from an access database. The error I am getting is that the values are not of the same type. Do I need to do some converting before I can fill in the values? Below is my code. Thank you!!!

Dim recset2
Dim sqlstament2
Dim Conn2
recset2 = CreateObject("ADODB.Recordset")
Conn2 = CreateObject("ADODB.Connection")
Conn2.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\test.mdb")
sqlstament2 = "SELECT name FROM testing"
recset2.Open(sqlstament2, Conn2, 1, 3)
namevalue = recset2.fields("name")
phonevalue = recset2.fields("phone")
useridvalue = recset2.fields("userid")
followupvalue = recset2.fields("followup")
problemvalue = recset2.fields("problem")

[Pasvorto]

YOu may need to qualify things a bit more:

phonevalue.text = .....

[dglienna]

You are only selecting the name in the query

sqlstament2 = "SELECT name FROM testing"

try selecting each one, separated by comma's, or select them all:

sqlstament2 = "SELECT * FROM testing"

[MisterEko]

I just put that in, thanks for noticing that. However, the error I am getting is
Conversion from type 'Field' to type 'String' is not valid.

Not sure why its considering the type of the value in the database a "field"

[kleinma]

try

namevalue = recset2.fields("name").Value


although I have to say not only are you using old DB connection objects (ADODB) you are also using late binding (CreateObject)

these are both rather frowned upon in the .NET world..

You sould be using early binding with option strict on, and ADO.NET

[MisterEko]

Thank you. The .value option worked

I know about the old DB connection objects etc. I was just trying to get a quick program up and running and I am not as familar with ADO.NET as I should be.

Thank you all very much!!!!!


P.S. - I have been on this website all of 1 hour and I love it!!!