Change Password using Stored Procedure

Question

I want to Change passsword of logged in user using stored Procedure .

Dhruvi kukadiya · Answer

protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { Session[siteid] = siteid; if (Session[siteid] != null && Session[siteid] != ) { string siteid = Session[SiteID].ToString(); } } } protected void btnSubmit_Click(object sender EventArgs e) { try { con.Open(); { string OLdpassword = txtOldPassword.Text; if (OLdpassword == txtOldPassword.Text) { if (txtNewPassword.Text == txtConfirmPassword.Text) { Session[siteid] = ToString(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(); cmd.CommandText = UpdatePassword; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@SiteIDConvert.ToInt32(Session[siteid].ToString())); cmd.Parameters.AddWithValue(@Password txtOldPassword.Text); da.SelectCommand = cmd; DataTable dt = new DataTable(); da.Fill(dt); Session[siteid] = dt.Rows[0][SiteID].ToString(); cmd.ExecuteNonQuery(); 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(); } catch (Exception ex) { } } protected void btnCancel_Click(object sender EventArgs e) { Response.Redirect(Login.aspx); } } here is my code it gives error Error converting data type nvarchar to int.

Manish Kumar Choudhary · Answer

Hi Dhruvi kukadiya  The following example shows how to use ALTER LOGIN to change the password for the login Victoria from manishold to manishnew. This is the preferred method. User Victoria can execute this command without additional permissions. Other users require ALTER ANY LOGIN permission: ALTER LOGIN Victoria WITH PASSWORD = ' manishnew' OLD_PASSWORD = ' manishold; GO