Does anyone know how to put information from a database (i.e. UserId) into a variable (i.e. VarUserID) and then add 1 to it. So now the new variable will be 2. Then insert the new variable value into the database.
My logic:
UserID=1
VarUserID = UserID
VarUserID = VarUserID + 1
UserID = VarUserID
Insert into database UserID

Thanks in Advance,
Mark

Will UserID be the Primary Key? And will the new value be a new row or are you updating the existing UserID?

Yes UserID will be a Primary Key and YES this will be a new record in the table.

Mark

  Public Function getMyID() As Integer
        Dim strConn As String = ConfigurationSettings.AppSettings("myDB")
        Dim objConn As New OleDbConnection(strConn)

        Dim strSQL As String = "SELECT the_id FROM the_database WHERE (email = '" & System.Web.HttpContext.Current.User.Identity.Name & "')"
        Dim objCommand As New OleDbCommand(strSQL, objConn)

        Dim sResult As Integer
        objConn.Open()
        sResult = CType(objCommand.ExecuteScalar(), Integer)
        objConn.Close()
        Return sResult
End Function

Now you can call another function or sub to increment getMyID() + 1 and send that value back to the database as a new row.

If you are using Access make sure Auto Increment isn't turned on.