cour_choose.aspx.cs

asp.net 学生信息管理系统！可以作为课程设计来使用

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.SqlClient;
 using UseDataBase;
using System.Collections.Generic;

public partial class stu_cour_choose : System.Web.UI.Page
{
    string connectionString = ConfigurationManager.ConnectionStrings["DataBaseConnectionString"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        /*
         if (Session["UserID"] == null)
          {
              Response.Write("<script language=javascript>alert('请先登录');location='Default.aspx'</script>");
          }
        
         if (Session["power"] != "0")
         {
             Response.Write("<script language=javascript>alert('你的权限不够');location='Default.aspx'</script>");
         }
        */

    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        bool success = false;
        int n = 0;
        List<int> tmp = new List<int>();
        for (int i = 0; i < checkBoxSelectCourse.Items.Count; i++)
        {
            if (checkBoxSelectCourse.Items[i].Selected)
            {
                n++;
                if (n >= 4)
                {
                    Response.Write("<script>alert('对不起，您选择的课程大于三门,请重新选择')</script>");
                    checkBoxSelectCourse.ClearSelection();
                    tmp = null;
                    break;
                }
                else
                    tmp.Add(i);
            }
        }
        if (tmp != null)
        {
            for (int m = 0; m < tmp.Count; m++)
            {
                string insertCmd = "insert tabstu_cour (Sid,Crid) values (@Sid,@Crid)";

                SqlParameter parSid = new SqlParameter("@Sid", SqlDbType.VarChar);
                parSid.Value = (string)Session["UserID"];
                SqlParameter parCrid = new SqlParameter("@Crid", SqlDbType.VarChar);
                parCrid.Value = checkBoxSelectCourse.Items[m].Value;

                DataBaseIO db = new DataBaseIO(connectionString);
                db.ExecuteSQL(insertCmd, parSid, parCrid);
                success = true;
            }
        }
        checkBoxSelectCourse.ClearSelection();
        if (success == true)
        {
            checkBoxSelectCourse.DataBind();
            Response.Write("<script>alert('选课成功!')</script>");
        }
    }
    protected void btnCalcelSubmit_Click(object sender, EventArgs e)
    {
        checkBoxSelectCourse.ClearSelection();
    }
}