form_mbwh.cs

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

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

namespace bizdb
{
	/// <summary>
	/// Form_mbwh 的摘要说明。
	/// </summary>
	public class Form_mbwh : System.Windows.Forms.Form
	{
		private System.Windows.Forms.GroupBox gpb_mb;
		private System.Windows.Forms.Button btn_mz;
		private System.Windows.Forms.Button btn_zzmm;
		private System.Windows.Forms.Button btn_xb;
		private System.Windows.Forms.Button btn_hyzk;
		private System.Windows.Forms.Button btn_jg;
		private System.Windows.Forms.Button btn_whcd;
		private System.Windows.Forms.Button btn_hy;
		private System.Windows.Forms.Button btn_zyjszw;
		private System.Windows.Forms.Label lbl_xqck;
		private System.Windows.Forms.Label lbl_dm;
		private System.Windows.Forms.TextBox txt_dm;
		private System.Windows.Forms.Label lbl_mc;
		private System.Windows.Forms.TextBox txt_mc;
		private System.Windows.Forms.Button btn_sjl;
		private System.Windows.Forms.Button btn_qyjl;
		private System.Windows.Forms.Button btn_hyjl;
		private System.Windows.Forms.Button btn_mjl;
		private System.Windows.Forms.Button btn_bj;
		private System.Windows.Forms.Button btn_tj;
		private System.Windows.Forms.Button btn_sc;
		private System.Windows.Forms.Button btn_qrtj;
		private System.Windows.Forms.Button btn_qx;
		private System.Windows.Forms.Button btn_js;
		private System.Windows.Forms.DataGrid dgd_mbwh;
		private System.Windows.Forms.Panel pnl_mbwh1;
		private System.Windows.Forms.Panel pnl_mbwh2;
		private System.Data.SqlClient.SqlDataAdapter sqlada1;
		private System.Data.SqlClient.SqlDataAdapter sqlada2;
		private System.Data.SqlClient.SqlDataAdapter sqlada3;
		private System.Data.SqlClient.SqlDataAdapter sqlada4;
		private System.Data.SqlClient.SqlDataAdapter sqlada5;
		private System.Data.SqlClient.SqlDataAdapter sqlada6;
		private System.Data.SqlClient.SqlDataAdapter sqlada7;
		private System.Data.SqlClient.SqlDataAdapter sqlada8;
		private System.Data.SqlClient.SqlDataAdapter sqlada9;
		private System.Data.SqlClient.SqlDataAdapter sqlada10;
		private System.Data.SqlClient.SqlDataAdapter sqlada11;
		private int change=0;
		private System.Data.SqlClient.SqlConnection sqlcon;
		private System.Data.DataSet dst;
		private string dataset_table;
		private int notable;
		private System.Windows.Forms.Button btn_baj;
		private System.Windows.Forms.Button btn_bm;
		private System.Windows.Forms.Label lbl_bngw;
		private System.Windows.Forms.Label lbl_bmms;
		private System.Windows.Forms.TextBox txt_bmgw;
		private System.Windows.Forms.TextBox txt_bmms;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

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

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

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

		#region Windows Form Designer generated code
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.dgd_mbwh = new System.Windows.Forms.DataGrid();
			this.gpb_mb = new System.Windows.Forms.GroupBox();
			this.btn_bm = new System.Windows.Forms.Button();
			this.btn_baj = new System.Windows.Forms.Button();
			this.btn_js = new System.Windows.Forms.Button();
			this.btn_zyjszw = new System.Windows.Forms.Button();
			this.btn_hy = new System.Windows.Forms.Button();
			this.btn_whcd = new System.Windows.Forms.Button();
			this.btn_jg = new System.Windows.Forms.Button();
			this.btn_hyzk = new System.Windows.Forms.Button();
			this.btn_xb = new System.Windows.Forms.Button();
			this.btn_zzmm = new System.Windows.Forms.Button();
			this.btn_mz = new System.Windows.Forms.Button();
			this.pnl_mbwh1 = new System.Windows.Forms.Panel();
			this.txt_bmms = new System.Windows.Forms.TextBox();
			this.txt_bmgw = new System.Windows.Forms.TextBox();
			this.lbl_bmms = new System.Windows.Forms.Label();
			this.lbl_bngw = new System.Windows.Forms.Label();
			this.txt_mc = new System.Windows.Forms.TextBox();
			this.lbl_mc = new System.Windows.Forms.Label();
			this.txt_dm = new System.Windows.Forms.TextBox();
			this.lbl_dm = new System.Windows.Forms.Label();
			this.pnl_mbwh2 = new System.Windows.Forms.Panel();
			this.btn_qx = new System.Windows.Forms.Button();
			this.btn_qrtj = new System.Windows.Forms.Button();
			this.btn_sc = new System.Windows.Forms.Button();
			this.btn_tj = new System.Windows.Forms.Button();
			this.btn_bj = new System.Windows.Forms.Button();
			this.btn_mjl = new System.Windows.Forms.Button();
			this.btn_hyjl = new System.Windows.Forms.Button();
			this.btn_qyjl = new System.Windows.Forms.Button();
			this.btn_sjl = new System.Windows.Forms.Button();
			this.lbl_xqck = new System.Windows.Forms.Label();
			((System.ComponentModel.ISupportInitialize)(this.dgd_mbwh)).BeginInit();
			this.gpb_mb.SuspendLayout();
			this.pnl_mbwh1.SuspendLayout();
			this.pnl_mbwh2.SuspendLayout();
			this.SuspendLayout();
			// 
			// dgd_mbwh
			// 
			this.dgd_mbwh.DataMember = "";
			this.dgd_mbwh.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dgd_mbwh.Location = new System.Drawing.Point(0, 0);
			this.dgd_mbwh.Name = "dgd_mbwh";
			this.dgd_mbwh.ReadOnly = true;
			this.dgd_mbwh.Size = new System.Drawing.Size(656, 256);
			this.dgd_mbwh.TabIndex = 0;
			this.dgd_mbwh.Click += new System.EventHandler(this.dgd_mbwh_Click);
			this.dgd_mbwh.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dgd_mbwh_MouseUp);
			// 
			// gpb_mb
			// 
			this.gpb_mb.Controls.Add(this.btn_bm);
			this.gpb_mb.Controls.Add(this.btn_baj);
			this.gpb_mb.Controls.Add(this.btn_js);
			this.gpb_mb.Controls.Add(this.btn_zyjszw);
			this.gpb_mb.Controls.Add(this.btn_hy);
			this.gpb_mb.Controls.Add(this.btn_whcd);
			this.gpb_mb.Controls.Add(this.btn_jg);
			this.gpb_mb.Controls.Add(this.btn_hyzk);
			this.gpb_mb.Controls.Add(this.btn_xb);
			this.gpb_mb.Controls.Add(this.btn_zzmm);
			this.gpb_mb.Controls.Add(this.btn_mz);
			this.gpb_mb.Location = new System.Drawing.Point(664, 8);
			this.gpb_mb.Name = "gpb_mb";
			this.gpb_mb.Size = new System.Drawing.Size(120, 480);
			this.gpb_mb.TabIndex = 2;
			this.gpb_mb.TabStop = false;
			this.gpb_mb.Text = "请选择码表";
			this.gpb_mb.Enter += new System.EventHandler(this.gpb_mb_Enter);
			// 
			// btn_bm
			// 
			this.btn_bm.Location = new System.Drawing.Point(16, 432);
			this.btn_bm.Name = "btn_bm";
			this.btn_bm.Size = new System.Drawing.Size(88, 32);
			this.btn_bm.TabIndex = 10;
			this.btn_bm.Text = "部门";
			this.btn_bm.Click += new System.EventHandler(this.button1_Click);
			// 
			// btn_baj
			// 
			this.btn_baj.Location = new System.Drawing.Point(16, 392);
			this.btn_baj.Name = "btn_baj";
			this.btn_baj.Size = new System.Drawing.Size(88, 32);
			this.btn_baj.TabIndex = 9;
			this.btn_baj.Text = "班级";
			this.btn_baj.Click += new System.EventHandler(this.btn_baj_Click);
			// 
			// btn_js
			// 
			this.btn_js.Location = new System.Drawing.Point(16, 352);
			this.btn_js.Name = "btn_js";
			this.btn_js.Size = new System.Drawing.Size(88, 32);
			this.btn_js.TabIndex = 8;
			this.btn_js.Text = "角色";
			this.btn_js.Click += new System.EventHandler(this.btn_js_Click);
			// 
			// btn_zyjszw
			// 
			this.btn_zyjszw.Location = new System.Drawing.Point(16, 312);
			this.btn_zyjszw.Name = "btn_zyjszw";
			this.btn_zyjszw.Size = new System.Drawing.Size(88, 32);
			this.btn_zyjszw.TabIndex = 7;
			this.btn_zyjszw.Text = "专业技术职务";
			this.btn_zyjszw.Click += new System.EventHandler(this.btn_zyjszw_Click);
			// 
			// btn_hy
			// 
			this.btn_hy.Location = new System.Drawing.Point(16, 272);
			this.btn_hy.Name = "btn_hy";
			this.btn_hy.Size = new System.Drawing.Size(88, 32);
			this.btn_hy.TabIndex = 6;
			this.btn_hy.Text = "行业";
			this.btn_hy.Click += new System.EventHandler(this.btn_hy_Click);
			// 
			// btn_whcd
			// 
			this.btn_whcd.Location = new System.Drawing.Point(16, 232);
			this.btn_whcd.Name = "btn_whcd";
			this.btn_whcd.Size = new System.Drawing.Size(88, 32);
			this.btn_whcd.TabIndex = 5;
			this.btn_whcd.Text = "文化程度";
			this.btn_whcd.Click += new System.EventHandler(this.btn_whcd_Click);
			// 
			// btn_jg
			// 
			this.btn_jg.Location = new System.Drawing.Point(16, 192);
			this.btn_jg.Name = "btn_jg";
			this.btn_jg.Size = new System.Drawing.Size(88, 32);
			this.btn_jg.TabIndex = 4;
			this.btn_jg.Text = "籍贯";
			this.btn_jg.Click += new System.EventHandler(this.btn_jg_Click);
			// 
			// btn_hyzk
			// 
			this.btn_hyzk.Location = new System.Drawing.Point(16, 152);
			this.btn_hyzk.Name = "btn_hyzk";
			this.btn_hyzk.Size = new System.Drawing.Size(88, 32);
			this.btn_hyzk.TabIndex = 3;
			this.btn_hyzk.Text = "婚姻状况";
			this.btn_hyzk.Click += new System.EventHandler(this.btn_hyzk_Click);
			// 
			// btn_xb
			// 
			this.btn_xb.Location = new System.Drawing.Point(16, 72);
			this.btn_xb.Name = "btn_xb";
			this.btn_xb.Size = new System.Drawing.Size(88, 32);
			this.btn_xb.TabIndex = 2;
			this.btn_xb.Text = "性别";
			this.btn_xb.Click += new System.EventHandler(this.btn_xb_Click);
			// 
			// btn_zzmm
			// 
			this.btn_zzmm.Location = new System.Drawing.Point(16, 112);
			this.btn_zzmm.Name = "btn_zzmm";
			this.btn_zzmm.Size = new System.Drawing.Size(88, 32);
			this.btn_zzmm.TabIndex = 1;
			this.btn_zzmm.Text = "政治面貌";
			this.btn_zzmm.Click += new System.EventHandler(this.btn_zzmm_Click);
			// 
			// btn_mz
			// 
			this.btn_mz.Location = new System.Drawing.Point(16, 32);
			this.btn_mz.Name = "btn_mz";
			this.btn_mz.Size = new System.Drawing.Size(88, 32);
			this.btn_mz.TabIndex = 0;
			this.btn_mz.Text = "民族";
			this.btn_mz.Click += new System.EventHandler(this.btn_mz_Click);
			// 
			// pnl_mbwh1
			// 
			this.pnl_mbwh1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
			this.pnl_mbwh1.Controls.Add(this.txt_bmms);
			this.pnl_mbwh1.Controls.Add(this.txt_bmgw);
			this.pnl_mbwh1.Controls.Add(this.lbl_bmms);
			this.pnl_mbwh1.Controls.Add(this.lbl_bngw);
			this.pnl_mbwh1.Controls.Add(this.txt_mc);
			this.pnl_mbwh1.Controls.Add(this.lbl_mc);
			this.pnl_mbwh1.Controls.Add(this.txt_dm);
			this.pnl_mbwh1.Controls.Add(this.lbl_dm);
			this.pnl_mbwh1.Location = new System.Drawing.Point(0, 296);
			this.pnl_mbwh1.Name = "pnl_mbwh1";
			this.pnl_mbwh1.Size = new System.Drawing.Size(656, 192);
			this.pnl_mbwh1.TabIndex = 3;
			this.pnl_mbwh1.Paint += new System.Windows.Forms.PaintEventHandler(this.pnl_mbwh1_Paint);
			// 
			// txt_bmms
			// 
			this.txt_bmms.Location = new System.Drawing.Point(168, 128);
			this.txt_bmms.Name = "txt_bmms";
			this.txt_bmms.Size = new System.Drawing.Size(104, 21);
			this.txt_bmms.TabIndex = 7;
			this.txt_bmms.Text = "";
			this.txt_bmms.Visible = false;
			// 
			// txt_bmgw
			// 
			this.txt_bmgw.Location = new System.Drawing.Point(168, 88);
			this.txt_bmgw.Name = "txt_bmgw";
			this.txt_bmgw.Size = new System.Drawing.Size(104, 21);
			this.txt_bmgw.TabIndex = 6;
			this.txt_bmgw.Text = "";
			this.txt_bmgw.Visible = false;
			// 
			// lbl_bmms
			// 
			this.lbl_bmms.Location = new System.Drawing.Point(8, 128);
			this.lbl_bmms.Name = "lbl_bmms";
			this.lbl_bmms.Size = new System.Drawing.Size(144, 24);
			this.lbl_bmms.TabIndex = 5;
			this.lbl_bmms.Text = "部门描述";
			this.lbl_bmms.Visible = false;
			// 
			// lbl_bngw
			// 
			this.lbl_bngw.Location = new System.Drawing.Point(8, 88);
			this.lbl_bngw.Name = "lbl_bngw";
			this.lbl_bngw.Size = new System.Drawing.Size(144, 24);
			this.lbl_bngw.TabIndex = 4;
			this.lbl_bngw.Text = "部门岗位";
			this.lbl_bngw.Visible = false;
			// 
			// txt_mc
			// 
			this.txt_mc.Location = new System.Drawing.Point(168, 56);
			this.txt_mc.Name = "txt_mc";
			this.txt_mc.Size = new System.Drawing.Size(104, 21);
			this.txt_mc.TabIndex = 3;
			this.txt_mc.Text = "";
			// 
			// lbl_mc
			// 
			this.lbl_mc.Location = new System.Drawing.Point(8, 56);
			this.lbl_mc.Name = "lbl_mc";
			this.lbl_mc.Size = new System.Drawing.Size(144, 23);
			this.lbl_mc.TabIndex = 2;
			this.lbl_mc.Text = "名称";
			// 
			// txt_dm
			// 
			this.txt_dm.Location = new System.Drawing.Point(168, 16);
			this.txt_dm.Name = "txt_dm";
			this.txt_dm.Size = new System.Drawing.Size(104, 21);
			this.txt_dm.TabIndex = 1;
			this.txt_dm.Text = "";
			// 
			// lbl_dm
			// 
			this.lbl_dm.Location = new System.Drawing.Point(8, 16);
			this.lbl_dm.Name = "lbl_dm";
			this.lbl_dm.Size = new System.Drawing.Size(144, 23);
			this.lbl_dm.TabIndex = 0;
			this.lbl_dm.Text = "代码";
			// 
			// pnl_mbwh2
			// 
			this.pnl_mbwh2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
			this.pnl_mbwh2.Controls.Add(this.btn_qx);
			this.pnl_mbwh2.Controls.Add(this.btn_qrtj);
			this.pnl_mbwh2.Controls.Add(this.btn_sc);
			this.pnl_mbwh2.Controls.Add(this.btn_tj);
			this.pnl_mbwh2.Controls.Add(this.btn_bj);
			this.pnl_mbwh2.Controls.Add(this.btn_mjl);
			this.pnl_mbwh2.Controls.Add(this.btn_hyjl);
			this.pnl_mbwh2.Controls.Add(this.btn_qyjl);
			this.pnl_mbwh2.Controls.Add(this.btn_sjl);
			this.pnl_mbwh2.Location = new System.Drawing.Point(0, 488);
			this.pnl_mbwh2.Name = "pnl_mbwh2";
			this.pnl_mbwh2.Size = new System.Drawing.Size(784, 64);
			this.pnl_mbwh2.TabIndex = 4;
			//