Databases
StackOverflow2013
Postsdbo
POform_load issue with updating details using session variables and textboxes
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POform_load issue with updating details using session variables and textboxes
    primarykey
    data
    text
    <p>I'm trying to allow users to update their details after logging in on an asp site using vb. Textboxes are populated with user details using session variables in the form_load. The textboxes should be editable but for some reason are not registering the changes when the submit button is clicked. </p> <p>There is a similar question with the same issue <a href="https://stackoverflow.com/questions/2467204/database-not-updating-after-update-sql-statement-in-asp-net">Database not updating after UPDATE SQL statement in ASP.net</a> that was never answered.</p> <p>Please can someone advise</p> <p>Thanks in advance</p> <pre><code>Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Txt_Fname.Text = Session("First_Name") Txt_LName.Text = Session("Last_Name") Txt_ContactNumber.Text = Session("Cell_Number") Txt_Email.Text = Session("Email_Address") End Sub Protected Sub Cmd_Submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Cmd_Submit.Click Command.Connection = Connection Command.CommandText = "UPDATE dbo.User_Account Set First_Name = @First_Name, Last_Name = @Last_Name, Cell_Number = @Cell_Number, Email_Address = @Email_Address where Overall_ID = @Overall_ID" Command.Parameters.AddWithValue("@First_Name", Txt_Fname.Text) Command.Parameters.AddWithValue("@Last_Name", Txt_LName.Text) Command.Parameters.AddWithValue("@Cell_Number", Txt_ContactNumber.Text) Command.Parameters.AddWithValue("@Email_Address", Txt_Email.Text) Command.Parameters.AddWithValue("@Overall_ID", Session("ID")) Connection.Open() Command.ExecuteNonQuery() Connection.Close() Response.Redirect("MyAccount.aspx") End Sub </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USMatt
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POform_load issue with updating details using session variables and textboxes
      1. USgbs
      1. VTFavorite
    1. COcan you show us the code in the submit button?
      singulars
      1. POform_load issue with updating details using session variables and textboxes
      1. USMartin
    2. COwithout code it's going to be impossible to answer. Questions include: at what point do you fill the textboxes? Are you checking to see if a postback occurred before filling them? Have you put a break point to ensure your update statement is being called? etc.
      singulars
      1. POform_load issue with updating details using session variables and textboxes
      1. USNotMe
    3. COThat question has been answered. Please provide further details or close this question.
      singulars
      1. POform_load issue with updating details using session variables and textboxes
      1. USVarun Vohra
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload