MS Windows XP PRO
MS VW D 2005 XP Edition-VB
SQL Server 2005 XP-Access 2003 Database Source
Hi,
I have two comboboxes/Dropdowns. One is based on the other. They are working ok.
I would like to add a search button to display/return the results. Thank you.
Microsoft SQL Server 2005Microsoft AccessMicrosoft SQL Server
Last Comment
epossys
8/22/2022 - Mon
peter57r
What do you want to search?
How do you want to display the results?
Jim Horn
To echo Peter's comment, you need to provide us with a bunch of details as to what you want to search, and what you want displayed. Otherise, without my prerequisite gallon of caffiene my mindreading skills are abyssmal at best.
re:MS Windows XP PRO
MS VW D 2005 XP Edition-VB
SQL Server 2005 XP-Access 2003 Database Source
I have two Comboboxes/Dropdowns. One is based on the other. They are working ok.
I would like to add a search button to display/return the results. Thank you.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Perter57r,
My issue comes in two parts:
1. After a selection is make using the dropdown, I would like to add a button that would initiate
a search of the database displaying/return results using a gridview based on the selection
specified in the dropdown .
2. Also, after searching the database such as to locate an item within a specified zip code,
how can I provide a message to the user from a pre-selection of messages that will
alternates each time when there are no items returned from the query?
I hope this is not too confusing. If you have a solution, please provide detail info as to where to
place code. I am new to this process. Thank you.
epossys
ASKER
To All:
I forgot to include that I am using the NWind example - Catetogories and Products tables for the combo/dropdown to make selections - Part 1 and Customer, Address and Zip for additional search -
Part 2. Thank you.
Peter,
I am working with NWind - MDB in Visual Web Developer 2005 Express Edition/VB.
It does not provide a solution for the issue that I have requested.
If you can, I would appreciate it. As I have stated I forgot to include that I am using the NWind example - Catetogories and Products tables for the combo/dropdown to make selections that is part of - Part 1 and Customer, Address and Zip for additional search - Part 2. I hope this will be of some help. I don't know what else I can offer. Please let me know one way or the other. Thank you very much for your interest.
re:MS Windows XP PRO
MS VW D 2005 XP Edition-VB
SQL Server 2005 XP-Access 2003
Database Source/NWind
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Perter57r,
My intentions were not to confuse you. I am using the MS NWind Database Tables to help
resolve my issues. I have two Combo/DropDownLists to populate a Category list and one
to populate a Product list - one is based on the other. It makes it possible for a user to select an
item from the Category list that will simultaneously populate the Product list with related items.
It works great. No Problems! However, part 1& 2 are the issues that needs to be resolved.
Part 1. - Now that the user can make a selection, I need to add a button that would initiate a search of the database displaying/return results of the query using a Gridview based on the selection specified.
Part 2. - After searching the database such as to locate an item within a specified zip code or etc, how can I provide a message to the user from a pre-selection of messages that will alternates each time when there are no items found / returned from the query?
I do hope the clarity is here this time. Again, thank you for your time.
How do you want to display the results?