how to update the password of a particular email

Question

There are two text boxes.

textbox1.text contains the email id

textbox2.text contains the password which is to be updated .

these two textbxes are connected with the database. When a particular emailID is inserted in textbox1.text and password is wriiten then on click submit button the password will automatically gets updated into the database of that particular emailID. 

 

Please Help Me in this to write a code in "WINDOW BASED APPLICATION using c#.." 

Answer 1

update syntax is wrong, you can't say SET WHERE..has to be this format :

UPDATE MyTable 

SET Columnn1 = somevalue

WHERE Column2 =somevalue

 

try this :

 

string sqlUpdate = "UPDATE login SET password='" + txtPass.Text  + "' where ID='" + txtID.Text  + "'"; 

  

Answer 2

But Its not working

Answer 3

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=HMS;Integrated Security=True");

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");

}

Answer 4

On submit click call SQL Update query

Update TableName set password="textbox2.text" where emailId="textbox1.text" 

 

Please apply validation for null and record exist in database before this query. 

Answer 5

you will use SQL Update statement :

http://www.w3schools.com/sql/sql_update.asp

when email is equal to particular email and password is not empty, execute update statement..