Hi guys,

Ive got an ASP.net page with a Dropdownlist on it called DropDownList1, What I am trying to do is show the data from a table called Rates depending on the selection of 'companies' in the drop down list.

When a company is selected the Gridview is populated with the applicable rates based on the company name selected. At the moment ive got an SqlDataSource for the Gridview but I want to change it so it loads only the selection from the dropdownlist.

Here is the SQL command I have so far, it is hard coded to load all the 'SSE' results and was just for testing.

SELECT        Tariff_Popular.Company_Name, Tariff_Popular.Popular_PK, Tariff_Popular.Popular_Day_Rate, Tariff_Popular.Popular_Standing_Charge
FROM            Tariff_Popular INNER JOIN
                         Suppliers ON Tariff_Popular.Company_Name = Suppliers.Company_Name
WHERE        (Suppliers.Company_Name = 'SSE')