数据表:HB_User
数据字段:UserPassword,UserName,UserNickName,UserSex,UserEmail,UserSign
现有显示用户资料页User.aspx
用户名:
密码:
昵称:
性别:
信箱地址:
签名: 更新(按钮)在其User.aspx.cs中实现了两种方式显示数据DataReader或DataView,现在我想实现用户可以修改其资料,点击"更新"可以自动更新数据库中该用户的数据. 现有User.aspx.cs代码如下:
public class User : System.Web.UI.Page
{
#region 共有说明
string strConn = System.Configuration.ConfigurationSettings.AppSettings[0];
#endregion protected System.Web.UI.WebControls.Button submit1;
protected System.Web.UI.WebControls.TextBox Password;
protected System.Web.UI.WebControls.TextBox UserName;
protected System.Web.UI.WebControls.TextBox NickName;
protected System.Web.UI.WebControls.TextBox Sex;
protected System.Web.UI.WebControls.TextBox Sign;
protected System.Web.UI.WebControls.TextBox EmailBox;
private void Page_Load(object sender, System.EventArgs e)
{
string SessionUserID = Session["userID"].ToString();
string Sql = "select UserPassword,UserName,UserNickName,UserSex,UserEmail,UserSign from HB_User where UserID = " + SessionUserID; //用了Session
SqlConnection cn = new SqlConnection(strConn);
cn.Open();
SqlDataAdapter myAdapter = new SqlDataAdapter(Sql,strConn);
DataSet ds = new DataSet();
myAdapter.Fill(ds,"HB_User");
DataView dv = ds.Tables["HB_User"].DefaultView;
if (dv.Count > 0)
{
Password.Text = dv[0]["UserPassword"].ToString();
UserName.Text = dv[0]["UserName"].ToString();
NickName.Text = dv[0]["UserNickName"].ToString();
Sex.Text = dv[0]["UserSex"].ToString();
EmailBox.Text = dv[0]["UserEmail"].ToString();
Sign.Text = dv[0]["UserSign"].ToString();
}
else
{
Response.Write("<script>alert('很抱歉,系统没有您的数据!');</script>");
}
} private void submit1_Click(object sender, System.EventArgs e)
{
}
}
}请问这个按钮触发事件(既更新该用户数据记录)怎么写,求代码...
方法越多越好,我希望彻底搞透.
麻烦各位大虾拉!
数据字段:UserPassword,UserName,UserNickName,UserSex,UserEmail,UserSign
现有显示用户资料页User.aspx
用户名:
密码:
昵称:
性别:
信箱地址:
签名: 更新(按钮)在其User.aspx.cs中实现了两种方式显示数据DataReader或DataView,现在我想实现用户可以修改其资料,点击"更新"可以自动更新数据库中该用户的数据. 现有User.aspx.cs代码如下:
public class User : System.Web.UI.Page
{
#region 共有说明
string strConn = System.Configuration.ConfigurationSettings.AppSettings[0];
#endregion protected System.Web.UI.WebControls.Button submit1;
protected System.Web.UI.WebControls.TextBox Password;
protected System.Web.UI.WebControls.TextBox UserName;
protected System.Web.UI.WebControls.TextBox NickName;
protected System.Web.UI.WebControls.TextBox Sex;
protected System.Web.UI.WebControls.TextBox Sign;
protected System.Web.UI.WebControls.TextBox EmailBox;
private void Page_Load(object sender, System.EventArgs e)
{
string SessionUserID = Session["userID"].ToString();
string Sql = "select UserPassword,UserName,UserNickName,UserSex,UserEmail,UserSign from HB_User where UserID = " + SessionUserID; //用了Session
SqlConnection cn = new SqlConnection(strConn);
cn.Open();
SqlDataAdapter myAdapter = new SqlDataAdapter(Sql,strConn);
DataSet ds = new DataSet();
myAdapter.Fill(ds,"HB_User");
DataView dv = ds.Tables["HB_User"].DefaultView;
if (dv.Count > 0)
{
Password.Text = dv[0]["UserPassword"].ToString();
UserName.Text = dv[0]["UserName"].ToString();
NickName.Text = dv[0]["UserNickName"].ToString();
Sex.Text = dv[0]["UserSex"].ToString();
EmailBox.Text = dv[0]["UserEmail"].ToString();
Sign.Text = dv[0]["UserSign"].ToString();
}
else
{
Response.Write("<script>alert('很抱歉,系统没有您的数据!');</script>");
}
} private void submit1_Click(object sender, System.EventArgs e)
{
}
}
}请问这个按钮触发事件(既更新该用户数据记录)怎么写,求代码...
方法越多越好,我希望彻底搞透.
麻烦各位大虾拉!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货