Hi! Guys

It's me again

I need help with executing sql statements within VB and displaying results on a textbox.

e.g Select ContactName from Customers where CustomerID = 'ALFKI'

I want to display the contact name on a textbox (either by sending the sql result to a variable then binding the variable to the textbox or by sending the sql result directly to the textbox).

Please help

You have to open a recordset and read the ContactName you want from there:

dim rs as recordset, sSql as string
set rs = new recordset
sSql = "Select ContactName from Customers " & _
"where CustomerID = 'ALFKI'"

rs.open sSql, conn

text1=rs.fields("ContactName")
rs.close

Hello Thato,

Jigarzon's answer only displays the result in the text box. If you want changes made to the text box to be reflected in your database it is easier to bind the control and then update the recordset, like this:

Set txtCustomerName.DataSource = Recordset
txtCustomerName.DataField = "CustomerName"

Like I mentionned last time try out this control which automates all the ADO work for you:

http://www.geocities.com/scirocco_ha/DataControl.htm