Update Password in Windows Form C#

Jyoti Jodha

9y7.4kWindows Forms

private void btn_Submit_Click(object sender, EventArgs e)

{

if (txt_UserName.Text == "" || txt_Password.Text == "")

{

MessageBox.Show("Please provide UserName and Password");

return;

}

try

{

SqlCommand cmd = new SqlCommand("UPDATE tbl_Login SET Password=@password where UserName=@UserName ", cs);

cmd.Parameters.AddWithValue("@UserName", txt_UserName.Text);

cmd.Parameters.AddWithValue("@password", txt_Password.Text);

cs.Open();

SqlDataAdapter adapt = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

adapt.Fill(ds);

cs.Close();

int count = ds.Tables[0].Rows.Count;

if (count == 1)

{

MessageBox.Show("Password Changed Successfully!");

}

else

{

MessageBox.Show("Password Changed Failed!");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

4 Replies

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

Rafnas T P9y ago
Accepted answer
replace your button code as below
private void btn_Submit_Click(object sender, EventArgs e)
{
if (txt_UserName.Text == "" || txt_Password.Text == "")
{
MessageBox.Show("Please provide UserName and Password");
return;
}
try
{
SqlCommand cmd = new SqlCommand("UPDATE tbl_Login SET Password=@password where UserName=@UserName ", cs);
cmd.Parameters.AddWithValue("@UserName", txt_UserName.Text);
cmd.Parameters.AddWithValue("@password", txt_Password.Text);
cs.Open();
int count = cmd.ExecuteNonQuery();

cs.Close();

if (count > 0)
{
MessageBox.Show("Password Changed Successfully!");
}
else
{
MessageBox.Show("Password Changed Failed!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Rafnas T P9y ago
to execute insert,update you have to use ExecuteNonQuery
for this

remove these lines from your code

SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);

and
add this below line over there

cmd.ExecuteNonQuery();
Amit Gupta9y ago
There is no need to use DataSet here, using simply ExecuteNonQuery will do your work
SqlCommand cmd = new SqlCommand("UPDATE tbl_Login SET Password=@password where UserName=@UserName ", cs);

cmd.Parameters.AddWithValue("@UserName", txt_UserName.Text);
cmd.Parameters.AddWithValue("@password", txt_Password.Text);
cs.Open();
int x = CMD.ExecuteNonQuery();
if(x>0)
  Message box.Show("Password changed successfully");
else
   MessageBox.Show("Fail to change password");
cs.Close();
Rafnas T P9y ago
can describe what is the problem here