Why The Sql Command Is Not Executing

I have the following code in my C# code-behind page to execute on button press: String cString; SqlConnection Conn; protected void Page_Load(object sender, EventArgs e)

Solution 1:

You need to change your dropdownlist to an ASP:DropDownList with ListItems in it.

Then you'd replace 'RIDGE HILL' with '" + slcLocation.SelectedItem.Value (or Text) + "' ..."