How to change select query in oledb binding with ListBox ?

[Legjendat]

Hello, I have a local MsAccess database(called Products, and a table called Products again), and a listbox in my program. I bind the data from my local database to my listbox, and from what I noticed, I see in my program there have been created a DataSet called ProductsDataSet, a BindingSource called BindingSource1 and a TableAdapter called ProductsTableAdapter.

Which one of these 3 objects do I need to modify to modify the selection query, and then re-bind the data to the listbox again programmatically?

[.paul.]

Personally I wouldn't add the db + all the peripherals in the designer. It can all be done in code + gives easier flexibility.
I'll post links to some examples in a minute

[.paul.]

http://code.msdn.microsoft.com/acces...-with-2fed4cc1

[.paul.]

http://code.msdn.microsoft.com/DataBinding-91dfbcf4

[Legjendat]

Ok, Thank You, I will check them out and come back at you!