Comments by Member 12317764 (Top 5 by date)

if(tb_newPassword.Text == tb_Confirm.Text)
{
try
{
if (connect.State != ConnectionState.Open)
{
connect.Open();
OleDbCommand cmd = connect.CreateCommand();

cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE userInformation SET password= @password WHERE emailAddress= @email";
cmd.Parameters.AddWithValue("@password", tb_Confirm.Text);
cmd.Parameters.AddWithValue("@emaili", p_Email.Text);
cmd.Connection = connect;
connect.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connect.Close();
}
}



--------------------------------------------------------------
Before I debug it,
Did I add everything correctly?

The name of the password field in the table is "password"

I tried it and I this exception

"the connection was not closed, The connection's current state is open"

i then added "connect.Close()" after the cmd.ExecuteNonQuery() statement and I get the same exception

@Da-broken-Breakpoint

I tried it, it gives me an error that says error in UPDATE statement


These are the names of all my fields as well as my table in the database
table name = userInformation

table column = emailAddress
form textbox = p_Email
form textBox = tb_newPassword
form textBox = tb_Confirm

Am I perhaps missing a comma, or any quote marks?