Select Error Message

 Hi Guys,

          I receiving error message asking to Delcare  variable '@Country'.  Not sure how to Delcare    @Country  Any Help would be Greatly Appreciated Thank You...


Here is the Code Below:

________________________________________________________________________________________

 

Private  Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

         If Not IsPostBack Then

             Dim conCommerce As SqlConnection
             Dim cmdSelect As SqlCommand
             Dim CategoriesCounter As SqlDataReader
             Dim StylesSource As SqlDataReader

       conCommerce = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))

      conCommerce.Open()

      cmdSelect = New SqlCommand("Select CountrySubCatCount FROM StylesSource WHere Country = @Country", conCommerce)

     StylesSource = cmdSelect.ExecuteReader()


     txtCounter1.DataSource = StylesSource
     txtCounter1.DataTextField = "Country"

     txtCounter1.DataBind()

     StylesSource.Close()
     conCommerce.Close()

 

 End If


____________________________________________________________________________________________

Error Message:

Must declare the variable '@Country'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Must declare the variable '@Country'.

Source Error:


Line 220:                                                                 cmdSelect = New SqlCommand("Select CountrySubCatCount FROM StylesSource WHere Country = @Country", conCommerce)
Line 221:
Line 222:                                                                          StylesSource = cmdSelect.ExecuteReader()
Line 223:
Line 224: