旧密码是:BeforePwd;新密码是NewPwd;确认新密码是SurePwd;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;using System.Data;
using System.Data.SqlClient;public partial class SystemManager_AlterPassword : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void AlterBtn_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=JiaTingCaiWu;Integrated Security=SSPI"))
{
string sql = "update dbo.Users set Pwd='@pwd' where Name='" + Session["userName"].ToString()+"'";
con.Open(); SqlCommand cmd = new SqlCommand(sql, con);
//cmd.CommandText = "update dbo.Users set Pwd=@pwd where id=@ID";
//cmd.Connection = con; //cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Convert.ToInt32(Session["selectID"].ToString());
cmd.Parameters.Add("@pwd", SqlDbType.NVarChar).Value = this.NewPwd.Text.ToString();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
这是我写的代码,但是没写全,请各位亲们,帮帮忙啊!
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;using System.Data;
using System.Data.SqlClient;public partial class SystemManager_AlterPassword : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void AlterBtn_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=JiaTingCaiWu;Integrated Security=SSPI"))
{
string sql = "update dbo.Users set Pwd='@pwd' where Name='" + Session["userName"].ToString()+"'";
con.Open(); SqlCommand cmd = new SqlCommand(sql, con);
//cmd.CommandText = "update dbo.Users set Pwd=@pwd where id=@ID";
//cmd.Connection = con; //cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Convert.ToInt32(Session["selectID"].ToString());
cmd.Parameters.Add("@pwd", SqlDbType.NVarChar).Value = this.NewPwd.Text.ToString();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
这是我写的代码,但是没写全,请各位亲们,帮帮忙啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货