Change password in the database.

Priya Jindal

there are 3 fields.- emailID , new password and confrmPass

when a user enters the EmailID then this field is checked from the database whether exist or not..if yes then it will update the old password with the new password on click of button..

in c# window application

4 Replies

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

Surya Kant10y ago
What error are you getting in that above code.
Please provide your Error or Exception details in the bellow code.
0
Priya Jindal10y ago
its Actually not worjking..
the code im using is:
SqlDataReader dr = null;
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=HMS;Integrated Security=True");
string sqlSearch = "SELECT EmailID FROM login WHERE EmailId='" + txtID.Text + "'";
SqlCommand cmd = new SqlCommand(sqlSearch);
dr = cmd.ExecuteReader();
if (txtPass.Text == txtConfrmPass.Text)
{
try
{
string sqlUpdate = "UPDATE login SET WHERE password='" + txtPass.Text + "' where ID='"+txtID.Text+"'";
SqlCommand cmdd = new SqlCommand(sqlUpdate, conn);
conn.Open();
cmdd.ExecuteNonQuery();
// conn.Close();
MessageBox.Show("successfully updated");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}

}
else
{
MessageBox.Show("retype your new password correctly");
}
}
0
Surya Kant10y ago
Checking User Exit or not ?
Use Ado.net :
public string Check(string name)
{
sqlconnection con=new sqlConnection("Your Connection Strring")
sqlCommand cmd=new sqlCommand("select name where username='"+name+"'from Your table name",con);
DataReader dr=cmd.ExecuteReadeer();
if(dr.Read()){
string name=dr[0].tostring();
}
return name;
}
Then by using the name you can change the old password with new password.
0
Avikshith Aradhya10y ago
What is the issue in that?
0