我要做一个信息修改的页面,先从数据库中提取个人信息,显示在TextBox中,在修改后,再从TextBox中取得修改后的值存入数据库中。
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//加载相应的用户信息
string name = Request.QueryString["name"].ToString(); string sQuery = "select * from tbuser where name='" + name + "' ";
SqlConnection con = cc.GetConnection();
SqlCommand com = new SqlCommand(sQuery, con);
con.Open(); SqlDataReader sdr = com.ExecuteReader(CommandBehavior.CloseConnection | CommandBehavior.SingleResult);
if (sdr.HasRows)
{
while (sdr.Read())
{
txtName.Text = sdr["name"].ToString();
txtPwd.Text = sdr["Pwd"].ToString();
txtTrueName.Text = sdr["truename"].ToString();
ddlDepartment.SelectedValue = sdr["department"].ToString();
txtJob.Text = sdr["job"].ToString();
ddlRole.SelectedValue = sdr["role"].ToString();
txtPhone.Text = sdr["phone"].ToString(); }
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//这里取到的值依然是数据库里的值,并不是修改后的值
string time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string Role = ddlRole.SelectedValue.ToString();
string name = txtName.Text.Trim();
string pwd = txtPwd.Controls.ToString();
string trueName = txtTrueName.Text.Trim();
string phone = txtPhone.Text.Trim();
string job = txtJob.Text.Trim();
string department = ddlDepartment.SelectedValue.ToString(); string str = "update tbuser set Name='" + name + "',pwd='" + pwd + "',Role='" + Role + "',Truename='" + trueName + "',phone='" + phone + "',department='" + department + "',job='" + job + "'"; if (cc.ExecSQL(str))
{
Response.Write(cc.MessageBox("修改成功!","FindUser.aspx"));
}
else
{
Response.Write(cc.MessageBox("修改失败!","FindUser.aspx"));
}
}
请各位高手帮忙看看,上面这段代码如何修改才能获取修改后的值?
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//加载相应的用户信息
string name = Request.QueryString["name"].ToString(); string sQuery = "select * from tbuser where name='" + name + "' ";
SqlConnection con = cc.GetConnection();
SqlCommand com = new SqlCommand(sQuery, con);
con.Open(); SqlDataReader sdr = com.ExecuteReader(CommandBehavior.CloseConnection | CommandBehavior.SingleResult);
if (sdr.HasRows)
{
while (sdr.Read())
{
txtName.Text = sdr["name"].ToString();
txtPwd.Text = sdr["Pwd"].ToString();
txtTrueName.Text = sdr["truename"].ToString();
ddlDepartment.SelectedValue = sdr["department"].ToString();
txtJob.Text = sdr["job"].ToString();
ddlRole.SelectedValue = sdr["role"].ToString();
txtPhone.Text = sdr["phone"].ToString(); }
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//这里取到的值依然是数据库里的值,并不是修改后的值
string time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string Role = ddlRole.SelectedValue.ToString();
string name = txtName.Text.Trim();
string pwd = txtPwd.Controls.ToString();
string trueName = txtTrueName.Text.Trim();
string phone = txtPhone.Text.Trim();
string job = txtJob.Text.Trim();
string department = ddlDepartment.SelectedValue.ToString(); string str = "update tbuser set Name='" + name + "',pwd='" + pwd + "',Role='" + Role + "',Truename='" + trueName + "',phone='" + phone + "',department='" + department + "',job='" + job + "'"; if (cc.ExecSQL(str))
{
Response.Write(cc.MessageBox("修改成功!","FindUser.aspx"));
}
else
{
Response.Write(cc.MessageBox("修改失败!","FindUser.aspx"));
}
}
请各位高手帮忙看看,上面这段代码如何修改才能获取修改后的值?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货