Need some simple SQL help in conjunction with a .NET Website using

I'm also using SQL 2005. I am developing a website with a search feature
like one used on REMAX.com. My challenge is getting the search to work. I
am trying to pass three variables from dropdown lists: CountryID, StateID,
and PriceID. These need to go to the Listings page and query the DB to pull
the matching records.

I am willing to share my code to solve the problem, but I really want to
figure out how to do it. I am trying to teach myself all this, but this has
been a major stumbling block for me. So I am hoping to find an
understandable soul who can help hold my hand through this process. I have
taught myself .NET to this point and some other SQL items during this
process, so I can learn.

Thanks so much

Your request is not very clear; can you please indicate exactly what it is
that you would like to be shown?

From what you have written, you could be asking with help writing the query
to return the results, the .NET code to call the query, or even a
combination of the above plus the necessary code to fill the drop down
lists.

If you can provide more detail, I am sure we can help.




"u2clone" <u2clone (AT) discussions (DOT) microsoft.com> wrote

I'm also using SQL 2005. I am developing a website with a search feature
like one used on REMAX.com. My challenge is getting the search to work.
I
am trying to pass three variables from dropdown lists: CountryID, StateID,
and PriceID. These need to go to the Listings page and query the DB to
pull
the matching records.

I am willing to share my code to solve the problem, but I really want to
figure out how to do it. I am trying to teach myself all this, but this
has
been a major stumbling block for me. So I am hoping to find an
understandable soul who can help hold my hand through this process. I
have
taught myself .NET to this point and some other SQL items during this
process, so I can learn.

Thanks so much