Hi I have a gridview which is attached to an access database and I have
created a query that joins two tables together. All this works as
expected. However, I have three problems that I need to solve:
I want to
filter the results displayed on the gridview by way of a dropdown list.
This drop down list will take its values from one of the tables. So, my
question is how do I take a value from my drop down list and link it to
my query on the gridview? I want to add an value to my
drop down list, which is a default value, like "All". How do I add this
value to the list, when it is not part of the table that the values
comes from and when selected by the user shows all results? When the
user selects a value from the gridview and nothing is returned, how do I
get the gridview to show a null result message, like "Sorry, your
selection did not bring back any results"? Thanks
...
Go to the complete details ...