I've been developing the following website www.luxlifeinternational.com and have only gotten into .NET in May and Databases in June/July. No formal training and am learning web development on the fly.

The query works on the site (if you select the US, Nevada, and Price 3-4 mil - some houses will come up - we don't have many - more of samples anyway right now).

The two things it doesn't do are 1. if no homes are returned say "No Homes Match Your Criteria" and 2. Allow search for ANY. Below is the codebehind used when the submit button is pressed.

    protected void SearchTest(object sender, EventArgs e)
    {
        string strNewPage;
        strNewPage = "~/luxlistings/default.aspx?countryid={0}&stateid={1}&priceid={2} ";
        strNewPage = string.Format(strNewPage, Country_Select.SelectedValue, State_Select.SelectedValue, Price_Select.SelectedValue);
        Response.Redirect(strNewPage);
    }

I really need to learn how to do the No Listings Returned and the Any searches. Is there anyone who can help me out. I really want to learn it, but I can't find any good samples online.

Thanks!

__________________
\"Freedom is the right of all sentient beings\" - Optimus Prime

This really doesnt tell us anything about your database:

   protected void SearchTest(object sender, EventArgs e)
    {
        string strNewPage;
        strNewPage = "~/luxlistings/default.aspx?countryid={0}&stateid={1}&priceid={2} ";
        strNewPage = string.Format(strNewPage, Country_Select.SelectedValue, State_Select.SelectedValue, Price_Select.SelectedValue);
        Response.Redirect(strNewPage);
    }

It just shows us how you redirect to another page.

What you could do if, for example, you are populating a dataset with the results returned from sql is something like

if(ds.Tables[0].Rows.Count == 0)
{
   Response.Write("No homes match your criteria!");
}
else
{
   control.DataSource = ds.Tables[0];
   control.DataBind();
}

For your second problem, have you read about Full Text Index's? This might be the way to go to search your entire database.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

Thanks. Not sure I am tracking with the first part, is that c#? Like I said, really raw on some of this.

What do you need me to post on here to give you an idea regarding the Not Returning any Matches part. I'm assuming that there is part of that code that will need some exact information that I have in my code.

Just trying to wrap my brain around it.

Ok let me back up. Show me the code that you use to get data from your Database server and we can work from there =]

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========