Link to home
Start Free TrialLog in
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.
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

What do you want to search?
How do you want to display the results?
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.
not to mention your spelling;-)
Avatar of epossys
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.

Avatar of 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.
So is this an ADP or an MDB?
Avatar of 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
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 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.