New Value To A Existing Session Problems....

 
Ok, I am trying to teach myself asp.net and sql server. The problem I am having now is I want to update the session that already exists.
 I have a global session (I think) that is UserEmployeeID, it is inputed when a user selects the select link on the search page which will redirect to an info page. I want to change the employee to a different employee, well I am updating the database well, no that is a lie it doesn’t that is another error, but anyway I try to update it to the new EmployeeID and it will not update…
 
Partial Class Assignment

    Inherits System.Web.UI.Page
 

    Protected Sub UpdateButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles UpdateButton.Click
 

        Dim empID As Integer

        Dim nbrID As Integer

    
   Dim equid As Integer

        Dim UpdateQuery

        Dim empequipid As SqlCommand

        Dim mySQLConnection As String = System.Configuration.ConfigurationManager.ConnectionStrings("DBConnectionString").ToString

        Dim myConnection As New SqlConnection(mySQLConnection)

        myConnection.Open()
 

        empID = CType(Session("UserEmployeeID"), Integer)

        equid = CType(Session("UserEquipID"), Integer)
 
 

        If CType(empID, Integer) = Nothing Then

            empID = (DropDownList1.SelectedValue)

            Response.Write("Insert: " & empID)

            'Response.End()

            Me.SqlDataSource1.InsertCommand = "INSERT INTO [EMPLOYEES_EQUIP] ([EquipID], [EmployeeID]) VALUES " & equid & " " & empID & ""

            Me.SqlDataSource1.InsertCommand = SqlDataSourceCommandType.Text

            Me.SqlDataSource1.Insert()

        Else

            empequipid = New SqlCommand("Select EmpEquipID From EMPLOYEES_EQUIP Where EmployeeID = " & empID & "
  AND EquipID = " & equid & " ", myConnection)

            empequipid.CommandType = CommandType.Text

            nbrID = empequipid.ExecuteScalar
 

            ' Response.Write("Select EmpEquipID: " & nbrID)
 

            empID = (DropDownList1.SelectedValue)
 

            'Response.Write("<br>Update EmployeeID: " & empID)
 

            Me.SqlDataSource1.UpdateCommand = "UPDATE EMPLOYEES_EQUIP SET EmployeeID = " & empID & " WHERE EmpEquipID = " & nbrID & " "

            Me.SqlDataSource1.UpdateCommand = SqlDataSourceCommandType.Text

       
    Me.SqlDataSource1.Update()
 

            UpdateQuery = "UPDATE EMPLOYEES_EQUIP SET EmployeeID = " & empID & " WHERE EmpEquipID = " & nbrID & " "

            'Response.Write(UpdateQuery)

            'Response.End()

        End If

       
Session("UserEployeeID") = (DropDownList1.SelectedValue)

        'Response.Write("<br>UserEmployeeID Session: " & Session("UserEmployeeID"))
 
 

        '-- Turn On Results Table

        resultstable.Visible = True

        '-- Hide Form by hiding table.

        maintable.Visible = False

        'clientSearch.Visible = False
 

    End Sub
End Class
 
I am also getting an error at Me.SqlDataSource1.Update() saying incorrect syntax near ‘0’ but there isn’t a 0??? I am confused…