I have a Combo Box that contains a number of values, that when selected, my DataGridView needs to change to only show rows that correspond to what is chosen.
So, how do i alter the TableAdapter query to do this using code? Or failing that, how do i get this done?
There are a number of ways to accomplish what you want - the main ways are to use a lookup table or a parameterized query.
This link provides a simple example of a lookup table:
I highly recommned you look at the "Forms or data" videos Beth Massi put together
#4, #5, #6 all talk about filtering data and creating lookup lists.
Hope this helps,
Visual Basic Team
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?