Avatar of epossys
epossys
 asked on

Search Button

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

Avatar of undefined
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.
GRayL

not to mention your spelling;-)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
epossys

ASKER
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.
peter57r

So is this an ADP or an MDB?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
epossys

ASKER
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.
ASKER CERTIFIED SOLUTION
peter57r

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
epossys

ASKER
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.