none
Updating Values entered by User in form to database RRS feed

  • Question

  • Hi all,

    I am trying to create an application which involves the User to change the password.

    I am using Microsoft Visual Studio for developing the Graphical User Interface and Microsoft SQL server as the back-end.

    I have created a separate form which allows the user to change the password.

    However I am unaware of how the particular password will be updated to the Database.

    I have tried the following code for updating the new password to the database but it is not working.

    There is no error in the code when compiling and running but the password is not updated in the database.

    Coding:

    UserID = txtUserID.Text;
    try
    {
    SqlCommand objSqlCommand = new SqlCommand("update NewUserRegister set Password = @Password where UserID = @UserID",objSqlConnection);

    SqlParameter sql;
    sql = objSqlCommand.Parameters.Add("@UserID", SqlDbType.Int);
    sql.Value = UserID;

    MessageBox.Show("Password Updated Successfully");
    }
    catch (SqlException e1)
    {
    MessageBox.Show(e1.Message, "Error Information", MessageBoxButtons.OK, MessageBoxIcon.Hand);
    }
    catch(System.Exception e2)
    {
    MessageBox.Show(e2.Message, "Error Information", MessageBoxButtons.OK, MessageBoxIcon.Hand);
    }

    Can any one help me out with the correct code snippet I should use to update the password?

    I am in urgent need of completing this task. Please reply me soon..

    Thanks in advance!!
    Friday, June 19, 2009 10:58 AM

Answers

  • Where is the code to execute the Command? It looks like you're missing a call to ExecuteNonQuery.


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Friday, June 19, 2009 7:07 PM

All replies

  • Where is the code to execute the Command? It looks like you're missing a call to ExecuteNonQuery.


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Friday, June 19, 2009 7:07 PM
  • Where is the code to execute the Command? It looks like you're missing a call to ExecuteNonQuery.


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thanks for your reply.

    I will include the ExecuteNonQuery command and check whether if it is working.


    Saturday, June 20, 2009 4:58 AM