I am a new in using Visual Basic.

I am trying to use ADODB instead of ADODC in display a set of records to text box or table. Besides displaying records, updating, modifying and deleting are also able in order to manupulate those records.

I heard that by binding text box is able to do that. however, i got no idea on how to do it after so many tried.

Hope can get help from expertise.

Advanced thanks.

For your ADODC1 control set your .ConnectionString and .RecordSource. The .ConnectionString will tell VB what OLE DB driver to use and what database to read from. The .RecordSource will tell VB what table to use from the database. In your text box you need to set the .DataSource to the name of you ADODC1 control and the .DataField to the field you want to view.

Kenny Alligood

another way to bind textfield to field data... use databinding collection this sample is from MSDN

dim bmCustomers As New BindingCollection
' Assuming an ADO Data Control configured to connect to the Customers
' table. The TextBox is named Text1; the code binds the CompanyName
' field to the Text property.

Private Sub UserForm_Initialize()
   Set bmCustomers.DataSource = ADODC1
   BmCustomers.Add TextBox1, "Text", "CompanyName"
end sub

Ahmed Ali
Software Developer