Updating Values entered by User in form to database

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!!

Try this......

Get 2 textboxes for UserID and New password.

//declare connection string
public static string constring = "Your connection string";

private void btn_submit_Click(object sender, EventArgs e)
        {
            //Create connection
            SqlConnection conn = new SqlConnection(constring);
            conn.Open();
            string userID = tbxUserID.Text;
            string password = tbxPassword.Text;

            try
            {
                SqlCommand cmd = new SqlCommand("update NewUserRegister set Password='" + password + "' where UserID='" + userID + "'", conn);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Success");
            }
            catch (Exception e1)
            {
                MessageBox.Show("Error in update");
            }

            conn.Close();
        }

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Charith Liyanagamage17y ago
Try this......

Get 2 textboxes for UserID and New password.

//declare connection string
public static string constring = "Your connection string";

private void btn_submit_Click(object sender, EventArgs e)
        {
            //Create connection
            SqlConnection conn = new SqlConnection(constring);
            conn.Open();
            string userID = tbxUserID.Text;
            string password = tbxPassword.Text;

            try
            {
                SqlCommand cmd = new SqlCommand("update NewUserRegister set Password='" + password + "' where UserID='" + userID + "'", conn);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Success");
            }
            catch (Exception e1)
            {
                MessageBox.Show("Error in update");
            }

            conn.Close();
        }
0