when I run following code.
{
con.Open();
{
string OLdpassword = txtOldPassword.Text;
if (OLdpassword == txtOldPassword.Text)
{
if (txtNewPassword.Text == txtConfirmPassword.Text)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdatePassword";
cmd.Parameters.AddWithValue("@user_id",Convert.ToString(Session["user_id"]));
cmd.Parameters.AddWithValue("@user_password", txtOldPassword.Text);
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
lblmsg.Text = "Password updated successfully";
}
else
{
lblmsg.Text = "Execution error";
}
}
else
{
lblmsg.Text = "Password miss match";
}
}
else
{
lblmsg.Text = "Old password is incorrect";
}
}
con.Close();
clear();
}
catch (Exception ex)
{
}
Ranjit PowarPosted Dec 30, 2014, 3:30 AM
Abhijit KakadePosted Dec 30, 2014, 4:37 AM
//cmd.Parameters.AddWithValue("@user_id",Convert.ToString(Session["user_id"]));
don't convert into string , it will be int only.
Harieswaran DPosted Dec 30, 2014, 3:31 AM
to "cmd.Parameters.AddWithValue("@user_id",Convert.ToInt32(Session["user_id"]));" if there is any error ,u will get in u r form
Michal HabalcikPosted Dec 30, 2014, 3:23 AM