asp.net c# 中修改密码的语句怎么写?

来源:百度知道 编辑:UC知道 时间:2024/05/19 16:21:36
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class ChangePsw : System.Web.UI.Page
{
SqlConnection cn;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["branch"].ToString() == "0" || Session["branch"].ToString() == "1" || Session["branch"].ToString() == "2")
{

}
else
{
Response.Write("请登入后再操作,<a href='default.aspx'>返回登录</a>");
Page.Response.End();
}
string strconn = ConfigurationManager.AppSettings["

话说修改密码不应该是用:"Update sysuser set pwd = "+spsw+" where Login=@user_id" 么?

下面几个可能是系统变量。
Update [sysuser] set [pwd] = "+spsw+" where [Login]=@user_id

根据条件update不就行了