i fix the code
FormsAuthentication.SignOut();
Response.Redirect("~/Login.aspx");
rotected void OnChangingPassword(object sender, LoginCancelEventArgs e)
{
if (!ChangePassword1.CurrentPassword.Equals(ChangePassword1.NewPassword, StringComparison.CurrentCultureIgnoreCase))
{
int rowsAffected = 0;
string query = "UPDATE [Table_infoname] SET [Password] = @NewPassword WHERE [name] = @name AND [Password] = @CurrentPassword";
string constr = ConfigurationManager.ConnectionStrings["kankonConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Parameters.AddWithValue("@name", this.Page.User.Identity.Name);
cmd.Parameters.AddWithValue("@CurrentPassword", ChangePassword1.CurrentPassword);
cmd.Parameters.AddWithValue("@NewPassword", ChangePassword1.NewPassword);
cmd.Connection = con;
con.Open();
rowsAffected = cmd.ExecuteNonQuery();
con.Close();
}
}
if (rowsAffected > 0)
{
lblMessage.ForeColor = Color.Green;
lblMessage.Text = "تم تحديث كلمة المرور بنجاح";
FormsAuthentication.SignOut();
Response.Redirect("~/Login.aspx");
}
else
{
lblMessage.ForeColor = Color.Red;
lblMessage.Text = "Password does not match with our database records.";
}
}
}
else
{
lblMessage.ForeColor = Color.Red;
lblMessage.Text = "Old Password and New Password must not be equal.";
}
e.Cancel = true;
}