Counting Views for an ASP.net Page

I already know how you count the views for certain records in ASP. The SQL Statement should be something like:      
'Update the Views
SQL= "UPDATE Spastore SET Views = Views + 1 " & _
 "WHERE SpaStoreID = '" & strChosenStoreID & "'"

However, I am not sure how to do this in ASP.Net. I am trying to figure out where I should put this under my code for the DataList. Or should I create a separate sub procedure? Does anyone know the best way for me to accomplish this?

Here's some of my code:

'---------------------------------------------

' name: BindDataList()

'---------------------------------------------

Sub BindDataList()

              Dim strConnect As String

              Dim objConnect As New System.Data.SqlClient.SQLConnection(ConnectionString())

              Dim objCommand As New System.Data.SqlClient.SQLCommand

              Dim strSQL as String

              Dim SQL as String

              Dim dtaSpaStore As New System.Data.SqlClient.SQLDataAdapter()

              Dim dtsSpaStore As New DataSet()

              Dim strChosenStoreID

              objConnect.Open()

                   'Get incoming querystring values

                  strChosenStoreID = request.params("ID")

              'Start SQL statement

             strSQL = "Select * From SpaStore, City, State, Area"

                    strSQL = strSQL & " where SpaStore.City = City.City"

                    strSQL = strSQL & " and SpaStore.State = City.State"

                    strSQL = strSQL & " and SpaStore.State = State.State"

                    strSQL = strSQL & " and SpaStore.AreaID = Area.AreaID"

                    strSQL = strSQL & " and SpaStoreID = '" & strChosenStoreID & "'"

                    strSQL = strSQL & " and Approve=1"

The code that Mart gave me worked fine. strChosenStoreID is an integer. I should have not called it strChosenStoreID because str stands for string. I never dimmed it as a string. However, there's a strange problem. It will add 2 to the views instead of 1. I don't understand why this is happening. Views is an int datatype with default value of 0 in my table. How do I get the sql statement to only add one to the views like I indicated in the sql statement?

I have this code:

 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
              If Not Page.IsPostBack THEN
      BindDataList()
                 
              END IF
    End Sub 

The code for counting views is under BindDataList(). Should I make a separate sub procedure for counting views?

I've tried experimenting with my code, but I have been unsuccessful in getting the sql statement to only add 1 to the views. I decided to experiment with subtracting 1 from the views. It subtracted 2 from the views. This is puzzling.

Let me show you some of my code that may be significiant:

 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
                          If Not Page.IsPostBack THEN
      BindDataList()
     end if         &nbs p;  
          
    End Sub 

'---------------------------------------------

' name: BindDataList()

'---------------------------------------------

Sub BindDataList()

              Dim strConnect As String

              Dim objConnect As New System.Data.SqlClient.SQLConnection(ConnectionString())

              Dim objCommand As New System.Data.SqlClient.SQLCommand

              Dim strSQL as String

              Dim SQL as String

              Dim dtaSpaStore As New System.Data.SqlClient.SQLDataAdapter()

              Dim dtsSpaStore As New DataSet()

              Dim ChosenStoreID

                    Dim City as String

                    Dim AreaID

                    Dim CityID

                    Dim AreaName as String

                    Dim StateName as String

                    Dim State as String

                    Dim SpaStoreName as String

              'Get incoming querystring values

              ChosenStoreID = request.params("ID")

             If Not Page.IsPostBack THEN