using System.Data.SqlClient;
namespace legou
{
public class Users
{
public Users()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
///
/// 用户信息更新
///
/// 用户登录密码
/// 用户Email
/// 用户登录名
public void UserInfoUpdate(string userPwd, string userEmail, string userName, string userAddress)
{
DataBase db = new DataBase();
//定义用户信息更新的SQL语句
string sql = "update UserInfo set Pwd='" + userPwd + "',Email='" + userEmail + "' ,Address='" + userAddress + "' where Name='" + userName + "'";
//string sql = "update UserInfo set Pwd='"+userPwd+"',Email='" + userEmail + "' ,Address='" + userAddress + "' where Name='" + userName + "'";
//调用数据访问类的ExecuteSQL()方法
db.ExecuteSQL(sql);
db.CloseConn();
}
}
}
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace legou
{
public partial class UserInfoManage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string userName = Session["UserName"].ToString();
Users user = new Users();
SqlDataReader dr = user.GetUserInfo(userName);
dr.Read();
this.txtUserName.Text = dr["Name"].ToString();
// this.txtUserPwd.Text = dr["Pwd"].ToString();
// this.txtUserPwd2.Text = dr["Pwd"].ToString();
// this.txtUserAddress.Text = dr["Address"].ToString();
// this.txtUserEmail.Text = dr["Email"].ToString();
dr.Close();
if (!IsPostBack)
{
lblValidator.Text = new randomCode().RandomNum(4);///产生验证码
}
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
if (this.txtValidator.Text == this.lblValidator.Text)
{
string userName = Session["UserName"].ToString();
string userPwd = this.txtUserPwd.Text;
string userPwd2 = this.txtUserPwd.Text;
string userEmail = this.txtUserEmail.Text.Trim();
string userAddress = this.txtUserAddress.Text.Trim();
Users user = new Users();
user.UserInfoUpdate(userPwd, userEmail, userName, userAddress);
Response.Write("");
}
else
{
Response.Write("");
}
}
}
}
不报错
|