form_xyxk.cs

一个很简单的考试系统。实用性很强啊！数据库在里面

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;

namespace bizdb
{
	/// <summary>
	/// Form1 的摘要说明。
	/// </summary>
	public class Form_xyxk : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Label lbl_tjkc;
		private System.Windows.Forms.Label lbl_kcmc;
		private System.Windows.Forms.ComboBox cbo_yxfx;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label lbl_wxkxy;
		private System.Windows.Forms.Label lbl_yxkxy;
		private System.Windows.Forms.ComboBox cbo_wxkxy;
		private System.Windows.Forms.ComboBox cbo_yxkxy;
		private System.Windows.Forms.ComboBox cbo_zyk;
		private System.Windows.Forms.Label lbl_zyk;
		private System.Windows.Forms.DataGrid Grd_xyxk;
		private System.Windows.Forms.Button btn_view;
		private System.Windows.Forms.Button btn_commit;
		private System.Windows.Forms.Button btn_delall;
		private System.Windows.Forms.Button btn_addall;
		private System.Windows.Forms.Button btn_del;
		private System.Windows.Forms.Button btn_add;
		private System.Windows.Forms.ListBox lst_xkxy;
		private System.Windows.Forms.ListBox lst_xyxk;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		private OperateDtset opDtset = new OperateDtset();  ///实例化私有的OperateDtset类
		private common com = new common();
		public static ArrayList aryList = new ArrayList();
		public static int yxfxNo;

		public Form_xyxk()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.lbl_tjkc = new System.Windows.Forms.Label();
			this.lbl_kcmc = new System.Windows.Forms.Label();
			this.cbo_yxfx = new System.Windows.Forms.ComboBox();
			this.label1 = new System.Windows.Forms.Label();
			this.lbl_wxkxy = new System.Windows.Forms.Label();
			this.lbl_yxkxy = new System.Windows.Forms.Label();
			this.cbo_wxkxy = new System.Windows.Forms.ComboBox();
			this.cbo_yxkxy = new System.Windows.Forms.ComboBox();
			this.cbo_zyk = new System.Windows.Forms.ComboBox();
			this.lbl_zyk = new System.Windows.Forms.Label();
			this.Grd_xyxk = new System.Windows.Forms.DataGrid();
			this.btn_view = new System.Windows.Forms.Button();
			this.btn_commit = new System.Windows.Forms.Button();
			this.btn_delall = new System.Windows.Forms.Button();
			this.btn_addall = new System.Windows.Forms.Button();
			this.btn_del = new System.Windows.Forms.Button();
			this.btn_add = new System.Windows.Forms.Button();
			this.lst_xkxy = new System.Windows.Forms.ListBox();
			this.lst_xyxk = new System.Windows.Forms.ListBox();
			((System.ComponentModel.ISupportInitialize)(this.Grd_xyxk)).BeginInit();
			this.SuspendLayout();
			// 
			// lbl_tjkc
			// 
			this.lbl_tjkc.Location = new System.Drawing.Point(464, 312);
			this.lbl_tjkc.Name = "lbl_tjkc";
			this.lbl_tjkc.Size = new System.Drawing.Size(96, 16);
			this.lbl_tjkc.TabIndex = 81;
			this.lbl_tjkc.Text = "添加课程：";
			// 
			// lbl_kcmc
			// 
			this.lbl_kcmc.Location = new System.Drawing.Point(20, 312);
			this.lbl_kcmc.Name = "lbl_kcmc";
			this.lbl_kcmc.Size = new System.Drawing.Size(96, 16);
			this.lbl_kcmc.TabIndex = 80;
			this.lbl_kcmc.Text = "课程名称：";
			// 
			// cbo_yxfx
			// 
			this.cbo_yxfx.Location = new System.Drawing.Point(120, 238);
			this.cbo_yxfx.Name = "cbo_yxfx";
			this.cbo_yxfx.Size = new System.Drawing.Size(232, 20);
			this.cbo_yxfx.TabIndex = 1;
			this.cbo_yxfx.SelectedIndexChanged += new System.EventHandler(this.cbo_yxfx_SelectedIndexChanged);
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(20, 240);
			this.label1.Name = "label1";
			this.label1.TabIndex = 78;
			this.label1.Text = "研修方向：";
			// 
			// lbl_wxkxy
			// 
			this.lbl_wxkxy.Location = new System.Drawing.Point(416, 272);
			this.lbl_wxkxy.Name = "lbl_wxkxy";
			this.lbl_wxkxy.Size = new System.Drawing.Size(100, 16);
			this.lbl_wxkxy.TabIndex = 77;
			this.lbl_wxkxy.Text = "未选课学员：";
			// 
			// lbl_yxkxy
			// 
			this.lbl_yxkxy.Location = new System.Drawing.Point(416, 240);
			this.lbl_yxkxy.Name = "lbl_yxkxy";
			this.lbl_yxkxy.Size = new System.Drawing.Size(96, 16);
			this.lbl_yxkxy.TabIndex = 76;
			this.lbl_yxkxy.Text = "已选课学员：";
			// 
			// cbo_wxkxy
			// 
			this.cbo_wxkxy.Location = new System.Drawing.Point(520, 268);
			this.cbo_wxkxy.Name = "cbo_wxkxy";
			this.cbo_wxkxy.Size = new System.Drawing.Size(248, 20);
			this.cbo_wxkxy.TabIndex = 4;
			// 
			// cbo_yxkxy
			// 
			this.cbo_yxkxy.Location = new System.Drawing.Point(520, 238);
			this.cbo_yxkxy.Name = "cbo_yxkxy";
			this.cbo_yxkxy.Size = new System.Drawing.Size(248, 20);
			this.cbo_yxkxy.TabIndex = 3;
			// 
			// cbo_zyk
			// 
			this.cbo_zyk.ImeMode = System.Windows.Forms.ImeMode.NoControl;
			this.cbo_zyk.Location = new System.Drawing.Point(120, 268);
			this.cbo_zyk.Name = "cbo_zyk";
			this.cbo_zyk.Size = new System.Drawing.Size(232, 20);
			this.cbo_zyk.TabIndex = 2;
			this.cbo_zyk.SelectedIndexChanged += new System.EventHandler(this.cbo_zyk_SelectedIndexChanged);
			// 
			// lbl_zyk
			// 
			this.lbl_zyk.Location = new System.Drawing.Point(20, 272);
			this.lbl_zyk.Name = "lbl_zyk";
			this.lbl_zyk.Size = new System.Drawing.Size(92, 16);
			this.lbl_zyk.TabIndex = 72;
			this.lbl_zyk.Text = "专业名称：";
			// 
			// Grd_xyxk
			// 
			this.Grd_xyxk.DataMember = "";
			this.Grd_xyxk.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.Grd_xyxk.Location = new System.Drawing.Point(20, 8);
			this.Grd_xyxk.Name = "Grd_xyxk";
			this.Grd_xyxk.Size = new System.Drawing.Size(752, 208);
			this.Grd_xyxk.TabIndex = 71;
			// 
			// btn_view
			// 
			this.btn_view.Location = new System.Drawing.Point(352, 534);
			this.btn_view.Name = "btn_view";
			this.btn_view.Size = new System.Drawing.Size(88, 24);
			this.btn_view.TabIndex = 12;
			this.btn_view.Text = "详细资料";
			// 
			// btn_commit
			// 
			this.btn_commit.Location = new System.Drawing.Point(352, 496);
			this.btn_commit.Name = "btn_commit";
			this.btn_commit.Size = new System.Drawing.Size(88, 24);
			this.btn_commit.TabIndex = 11;
			this.btn_commit.Text = "提交选课记录";
			// 
			// btn_delall
			// 
			this.btn_delall.Location = new System.Drawing.Point(352, 456);
			this.btn_delall.Name = "btn_delall";
			this.btn_delall.Size = new System.Drawing.Size(88, 24);
			this.btn_delall.TabIndex = 10;
			this.btn_delall.Text = "<< 全部删除";
			this.btn_delall.Click += new System.EventHandler(this.btn_delall_Click);
			// 
			// btn_addall
			// 
			this.btn_addall.Location = new System.Drawing.Point(352, 416);
			this.btn_addall.Name = "btn_addall";
			this.btn_addall.Size = new System.Drawing.Size(88, 24);
			this.btn_addall.TabIndex = 9;
			this.btn_addall.Text = "全部添加 >>";
			this.btn_addall.Click += new System.EventHandler(this.btn_addall_Click);
			// 
			// btn_del
			// 
			this.btn_del.Location = new System.Drawing.Point(352, 376);
			this.btn_del.Name = "btn_del";
			this.btn_del.Size = new System.Drawing.Size(88, 24);
			this.btn_del.TabIndex = 8;
			this.btn_del.Text = "＜ 删除";
			this.btn_del.Click += new System.EventHandler(this.btn_del_Click);
			// 
			// btn_add
			// 
			this.btn_add.Location = new System.Drawing.Point(352, 336);
			this.btn_add.Name = "btn_add";
			this.btn_add.Size = new System.Drawing.Size(88, 24);
			this.btn_add.TabIndex = 7;
			this.btn_add.Text = "添加 ＞";
			this.btn_add.Click += new System.EventHandler(this.btn_add_Click);
			// 
			// lst_xkxy
			// 
			this.lst_xkxy.ItemHeight = 12;
			this.lst_xkxy.Location = new System.Drawing.Point(464, 336);
			this.lst_xkxy.Name = "lst_xkxy";
			this.lst_xkxy.Size = new System.Drawing.Size(300, 220);
			this.lst_xkxy.TabIndex = 6;
			this.lst_xkxy.MouseDown += new System.Windows.Forms.MouseEventHandler(this.lst_xkxy_MouseDown);
			this.lst_xkxy.DoubleClick += new System.EventHandler(this.lst_xkxy_DoubleClick);
			// 
			// lst_xyxk
			// 
			this.lst_xyxk.ItemHeight = 12;
			this.lst_xyxk.Location = new System.Drawing.Point(20, 336);
			this.lst_xyxk.Name = "lst_xyxk";
			this.lst_xyxk.Size = new System.Drawing.Size(300, 220);
			this.lst_xyxk.TabIndex = 5;