private void Btncreate_Click(object sender, EventArgs e)
{
SqlDataAdapter ad = new SqlDataAdapter("select COUNT(*) from register_user where email_id='" + Txtemail.Text + "' AND password='******'", con);
DataTable dt = new DataTable();
ad.Fill(dt);
errorProvider1.Clear();
if (dt.Rows[0][0].ToString() == "1")
{
if (Txtnew.Text == Txtconfirm.Text)
{
SqlDataAdapter dd = new SqlDataAdapter("update register_user set password='******'", con);
DataTable ds = new DataTable();
dd.Fill(ds);
MessageBox.Show("Password Change...!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
Txtold.Clear();
Txtnew.Clear();
Txtconfirm.Clear();
}
else
{
errorProvider1.SetError(Txtconfirm, "Password not matched!");
}
}
else
{
errorProvider1.SetError(Txtold, "Incorrect Password");
}
}
private void Btnclear_Click(object sender, EventArgs e)
{
Txtold.Clear();
Txtnew.Clear();
Txtconfirm.Clear();
}