Database filtering

[hepeci]

Hello everybody!

I'm using one Access Database and DataSet, BindingSource And Table Adapter. My question is: how to fill one listbox on my form with dates from one row from Database.

Look at the picture:

http://www.imagesforme.com/show.php/870175_table.JPG

So listbox needs to have 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20.

How to to this, code?

[kareninstructor]

Hello everybody!

I'm using one Access Database and DataSet, BindingSource And Table Adapter. My question is: how to fill one listbox on my form with dates from one row from Database.

Look at the picture:

http://www.imagesforme.com/show.php/870175_table.JPG

So listbox needs to have 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20.

How to to this, code?

I suggest learning the basics at this point. Here are some ideas...

Set your DisplayMember to the field to view (assume a date), ValueMemer is the ID (assume from your image). Then set the data source of the ListBox to the BindingSource. Double click the ListBox, in the selection change event write code to retreive the ID, something like

ListBox1.Text gives you the date
ListBox.SelectedValue gives the ID

You could simply populate the Listbox with the Binding source, create an onchange event for the Binding source, get the current position and then get the ID.


Declare bindingsource

Private WithEvents bsSource As New BindingSource()

Declare a private var for holding the ID

Private mIdentifier As String

Write code to get the ID

   Private Sub bsSource_PositionChanged() Handles bsSource.PositionChanged
      If Not IsNothing(bsSource.Current) Then
         mIdentifier = CType(bsSource.Current, DataRowView).Item("Identifier").ToString()
      End If
   End Sub

In the above code my source id a DataView, if you are using a DataTable then change the casting.

Hope this helps.

[jmcilhinney]

In the above code my source id a DataView, if you are using a DataTable then change the casting.

When you bind a DataTable the items are still DataRowView objects because they come from the table's DefaultView. That's why it's generally pointless to bind a DataView directly. The only reason to do that is if you want multiple views of the same table.