当前文件路径：XuanKeLunWen/student/SelectClass.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_SelectClass : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19    protected void Linkadd_Click(object sender, EventArgs e)
20    ...{
21        Insertclass();
22    }
23    protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
24    ...{
25        string id = this.GridView2.SelectedDataKey["Classid"].ToString();
26      
27        OleDbConnection con = db.con();
28        con.Open();
29        OleDbCommand cmd = new OleDbCommand("select  * from  JiaoyanshiClass    where Classid=@Classid", con);
30
31        cmd.Parameters.Add("@Classid", SqlDbType.VarChar);
32        cmd.Parameters["@Classid"].Value = id;
33        OleDbDataReader sdr = cmd.ExecuteReader();
34        if (sdr.Read())
35        ...{
36            this.txtjieci.Text = sdr["Ctime"].ToString();
37            this.txtjieshu.Text = sdr["CweekEndTime"].ToString();
38            this.txtlaoshi.Text = sdr["Cteacher"].ToString();
39            this.txtname.Text = sdr["Cname"].ToString();
40            this.txtweek.Text = sdr["Cdate"].ToString();
41            this.txtxi.Text = sdr["CClass"].ToString();
42            txtzhuanye.Text = sdr["Czhuanye"].ToString();
43            this.txtkaishi.Text = sdr["CweekBegTime"].ToString();
44
45        }
46
47    }
48    private void Insertclass()
49    ...{//
50        OleDbConnection con = db.con();
51        con.Open();
52        OleDbCommand cmd = new OleDbCommand("insert into  studentclass (Cname,Cteacher,CweekBegTime,Cdate,Ctime,CweekEndTime,CClass,Czhuanye,Cstudentname)values(@Cname,@Cteacher,@CweekBegTime,@Cdate,@Ctime,@CweekEndTime,@CClass,@Czhuanye,@Cstudentname)", con);
53        cmd.Parameters.Add("@Cname", OleDbType.VarChar);
54        cmd.Parameters.Add("@Cteacher", OleDbType.VarChar);
55
56        cmd.Parameters.Add("@CweekBegTime", OleDbType.VarChar);
57        cmd.Parameters.Add("@Cdate", OleDbType.VarChar);
58        cmd.Parameters.Add("@Ctime", OleDbType.VarChar);
59        cmd.Parameters.Add("@CweekEndTime", OleDbType.VarChar);
60        cmd.Parameters.Add("@CClass", OleDbType.VarChar);
61        cmd.Parameters.Add("@Czhuanye", OleDbType.VarChar);
62        cmd.Parameters.Add("@Cstudentname", OleDbType.VarChar);
63
64        cmd.Parameters["@Cname"].Value = txtname.Text;
65        cmd.Parameters["@Cteacher"].Value = txtlaoshi.Text;
66        cmd.Parameters["@CweekBegTime"].Value = txtkaishi.Text;
67        cmd.Parameters["@Cdate"].Value = txtweek.Text;
68        cmd.Parameters["@Ctime"].Value = txtjieci.Text;
69        cmd.Parameters["@CweekEndTime"].Value = txtjieshu.Text;
70        cmd.Parameters["@CClass"].Value = txtxi.Text;
71        cmd.Parameters["@Czhuanye"].Value = txtzhuanye.Text;
72        cmd.Parameters["@Cstudentname"].Value = Session["sname"].ToString();
73      
74        cmd.ExecuteNonQuery();
75
76        con.Close();
77        Response.Write("<script language='javascript'>alert('选课成功！')</script>");
78    }
79}
80