I am writing a form with serveral textboxes, those textboxes are going to display serveral records with same criteria. How can I show those records on those textboxes ?

Dim ShowPhonestrSelect As String = "select autoid, id, phone, type, phone &typeasshowphone from phone where id = '" & CboFiltered.SelectedValue & "'"

Dim ShowPhoneDA As New OleDb.OleDbDataAdapter(ShowPhonestrSelect, ShowPhoneconn)
Dim ShowPhoneDS As New DataSet

ShowPhoneconn.Open()

ShowPhoneDA.Fill(ShowPhoneDS, "phone")

What should I do then ??

Thank You

Um, no ... a ListView cannot be databound, there is no DataSource property. The others (DataGrid, DataGridView) can be databound.

Are you going to show different records at the same time?

If you only show one records at the time and you are using textboxes, and ff you work with .Net 2.0 (Visual Studio 2005), then you need to try out the BindingSource control.

A BindingSource is a easy way to Bind controls to a dataSet.

1) create a bindingsource
2) bind your bindingsource to the data (DataSource and DataMember Property)
3) Bind your controls (textboxes) to the BindingSource
a) programmatically using the DataBindings class  "textbox.databindings.add( ...) "
b) using the designer (recommended for starters)
4) add a binding navigator
5) set the bindingsource property of this BindingNavigator to the bindingsource you created in step 2.

You can do all these steps very easy when you use the "data sources" window.

Hope it helps
Damiaan

yes,I am going to show all records with the same criteria at the same time.

e.g.autoid id phone type

00001 001 12345678 Home

00002 001 87654321 Business

00003 001 78945612 Business (Fax)

and I have 3 set of textboxes,

txtphone1:txtphonetype1, txtphone2:txtphonetype2, txtphone3:txtphonetype3

If I write the code :

Txtphone1.DataBindings.Add("Text", ShowPhoneDS.Tables("phone"), "phone")

txtphonetype1.databindings.add("Text", ShowPhoneDS.Tables("phone"), "type")

What should I do if I want to show the rest of the records in textboxes 2 and 3 ?

Thank You.

Chris,

Rather than sets of TextBoxes, you'd be better off using a DataGrid, a DataGridView or a ListView.

You just need to set the datasource of these (datagrid, datagridview or listview) controls to the bindingsource, and off you go.

Um, no ... a ListView cannot be databound, there is no DataSource property. The others (DataGrid, DataGridView) can be databound.

I'm trying to use DataGridView now,

Thank You

Hey Chris, you gave yourself the "marked as an answer" ... shouldn't it have gone to me?