当前文件路径：XuanKeLunWen/student/Maintenance.aspx.cs

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.OleDb;
12
13public partial class studnet_Maintenance : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!IsPostBack)
18        ...{
19            if (Session["sname"] != null)
20            ...{
21                this.TextBox1.Text = Session["sname"].ToString();
22
23            }
24            else
25            ...{
26                Response.Write("<script language='javascript'>alert('没有登录请登录');location.href='../student/StudentLogin.aspx'</script>");
27            }
28
29
30        }
31
32    }
33    protected void LinkButton1_Click(object sender, EventArgs e)
34    ...{
35        update();
36    }
37    private void update()
38    ...{//修改学生信息
39        string name = Session["sname"].ToString();
40        OleDbConnection con = db.con();
41        con.Open();
42        OleDbCommand cmd = new OleDbCommand();
43        cmd.Connection = (OleDbConnection)con;
44        cmd.CommandText = "update   Student set Spwd=@Spwd ,Szhuanye=@Szhuanye  where  Sname='" + name + "'";
45
46        cmd.Parameters.Add("@Spwd", SqlDbType.DateTime);
47        cmd.Parameters.Add("@Szhuanye", SqlDbType.Money);
48
49      
50        cmd.Parameters["@Spwd"].Value = this.txxpwd.Text;
51        cmd.Parameters["@Szhuanye"].Value = this.DropDownList1.SelectedItem.Text;
52
53        cmd.ExecuteNonQuery();
54        con.Close();
55        Response.Write("<script language='javascript'>alert('修改成功')</script>");
56    }
57}
58