Add(db Param_email) Dim db Param_firstname As System.
Add(db Param_firstname) Dim db Param_lastname As System.
The properties of each class map to the columns of a corresponding table in the database.
Each instance of a class entity represents a row within the database table.
The aim is to update the details when the user overwrites the current text in the text boxes. Visible = False end if email = session.contents.item("Email") first = session.contents.item("First Name") last = session.contents.item("Last Name") promo = session.contents.item("Promo") End Sub Sub Button1_Click(sender As Object, e As Event Args) change Details(email Box.text, first Box.text, last Box.text, promo Box.text) End Sub Function change Details(By Val email As String, By Val firstname As String, By Val lastname As String, By Val promo As String) As Integer Dim connection String As String = "Provider=Microsoft. OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Documents an"& _ "d Settings\Paul Jarratt\My Documents\ticketoffice\datab\ticketoffice.mdb" Dim db Connection As System.
Add With Value("@Cust ID", id); int sql RA try catch (Exception ex) /* sql RA values explained -1 : Error occurred 0 : Record not found 1 : 1 Record updated Now reading through your code, all we are doing with the first query is mapping the Session["User"] to id, and then using that id in the second query to do the update, and that Username is not updated in the second. I currently have a problem attepting to update a record within my database. I have a webpage that displays in text boxes a users details, these details are taken from the session upon login. Currently, I am not able to update the Sub Tut Text. Tut Title" How do I change this set of code to make it update only the one I want or add new lines based on the Tut ID from table a? With my line of code I am updating everything instead of only the one I want.