selectclass.aspx.cs

智能选课系统:本程序采用Microsoft Visual Studio 2005集成环境开发即 asp.net 2.0+access 数据库开发。 功能如下:学校中学生教师根据不同的权限合理分配,提

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class studnet_SelectClass : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Linkadd_Click(object sender, EventArgs e)
    {
        Insertclass();
    }
    protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
    {
        string id = this.GridView2.SelectedDataKey["Classid"].ToString();
      
        OleDbConnection con = db.con();
        con.Open();
        OleDbCommand cmd = new OleDbCommand("select  * from  JiaoyanshiClass    where Classid=@Classid", con);

        cmd.Parameters.Add("@Classid", SqlDbType.VarChar);
        cmd.Parameters["@Classid"].Value = id;
        OleDbDataReader sdr = cmd.ExecuteReader();
        if (sdr.Read())
        {
            this.txtjieci.Text = sdr["Ctime"].ToString();
            this.txtjieshu.Text = sdr["CweekEndTime"].ToString();
            this.txtlaoshi.Text = sdr["Cteacher"].ToString();
            this.txtname.Text = sdr["Cname"].ToString();
            this.txtweek.Text = sdr["Cdate"].ToString();
            this.txtxi.Text = sdr["CClass"].ToString();
            txtzhuanye.Text = sdr["Czhuanye"].ToString();
            this.txtkaishi.Text = sdr["CweekBegTime"].ToString();

        }

    }
    private void Insertclass()
    {//
        OleDbConnection con = db.con();
        con.Open();
        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);
        cmd.Parameters.Add("@Cname", OleDbType.VarChar);
        cmd.Parameters.Add("@Cteacher", OleDbType.VarChar);

        cmd.Parameters.Add("@CweekBegTime", OleDbType.VarChar);
        cmd.Parameters.Add("@Cdate", OleDbType.VarChar);
        cmd.Parameters.Add("@Ctime", OleDbType.VarChar);
        cmd.Parameters.Add("@CweekEndTime", OleDbType.VarChar);
        cmd.Parameters.Add("@CClass", OleDbType.VarChar);
        cmd.Parameters.Add("@Czhuanye", OleDbType.VarChar);
        cmd.Parameters.Add("@Cstudentname", OleDbType.VarChar);

        cmd.Parameters["@Cname"].Value = txtname.Text;
        cmd.Parameters["@Cteacher"].Value = txtlaoshi.Text;
        cmd.Parameters["@CweekBegTime"].Value = txtkaishi.Text;
        cmd.Parameters["@Cdate"].Value = txtweek.Text;
        cmd.Parameters["@Ctime"].Value = txtjieci.Text;
        cmd.Parameters["@CweekEndTime"].Value = txtjieshu.Text;
        cmd.Parameters["@CClass"].Value = txtxi.Text;
        cmd.Parameters["@Czhuanye"].Value = txtzhuanye.Text;
        cmd.Parameters["@Cstudentname"].Value = Session["sname"].ToString();
      
        cmd.ExecuteNonQuery();

        con.Close();
        Response.Write("<script language='javascript'>alert('选课成功！')</script>");
    }
}