[Solved] Why the SQL command is not executing

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) + “‘ …”