欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

ASP.NET后台显示信息、修改密码等操作

程序员文章站 2022-06-07 09:40:05
...

protected void Page_Load(object sender, EventArgs e){//显示姓名等信息string sql = select * from [stu] where id=+Convert.ToString(Req【本文来自鸿网互联 (http://www.68idc.cn)】uest.QueryString[Id]);DataTable dt = new SqlHelper().ExecuteQuery

protected void Page_Load(object sender, EventArgs e)
{
//显示姓名等信息
string sql = "select * from [stu] where id="+Convert.ToString(Req【本文来自鸿网互联 (http://www.68idc.cn)】uest.QueryString["Id"]);
DataTable dt = new SqlHelper().ExecuteQuery(sql, CommandType.Text);
Label1.Text= Convert.ToString(dt.Rows[0]["stuname"]);

}
protected void Button1_Click(object sender, EventArgs e)
{
//修改密码等
string upsql = "update [stu] set [password]=" + TextBox1.Text.Trim() + "where id=" + Convert.ToString(Request.QueryString["Id"]);
int rows = new SqlHelper().ExecuteNonQuery(upsql, CommandType.Text);
Response.Write("");
}