form_jzg.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_jzg : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Panel pnl_jzg1;
		private System.Windows.Forms.Panel pnl_jzg2;
		private System.Windows.Forms.Button btn_xxzl;
		private System.Windows.Forms.ComboBox cbb_zyjszw;
		private System.Windows.Forms.Label lbl_sfjs;
		private System.Windows.Forms.Label lbl_zjcymmsj;
		private System.Windows.Forms.Label lbl_sccymtsj;
		private System.Windows.Forms.TextBox txt_fzbm;
		private System.Windows.Forms.Label lbl_fzbm;
		private System.Windows.Forms.Label lbl_fzrq;
		private System.Windows.Forms.TextBox txt_jszgzbh;
		private System.Windows.Forms.Label lbl_jszgzbh;
		private System.Windows.Forms.Label lbl_zyjszw;
		private System.Windows.Forms.TextBox txt_zy;
		private System.Windows.Forms.Label lbl_zy;
		private System.Windows.Forms.TextBox txt_byyx;
		private System.Windows.Forms.Label lbl_byyx;
		private System.Windows.Forms.Label lbl_whcd;
		private System.Windows.Forms.Button btn_sfzhcx;
		private System.Windows.Forms.ComboBox cbb_hyzk;
		private System.Windows.Forms.ComboBox cbb_zzmm;
		private System.Windows.Forms.ComboBox cbb_jg1;
		private System.Windows.Forms.ComboBox cbb_mz;
		private System.Windows.Forms.ComboBox cbb_xb;
		private System.Windows.Forms.Button btn_jzgbhcx;
		private System.Windows.Forms.Label lbl_hyzk;
		private System.Windows.Forms.TextBox txt_lxdh;
		private System.Windows.Forms.Label lbl_lxdh;
		private System.Windows.Forms.TextBox txt_jtdh;
		private System.Windows.Forms.Label lbl_jtdh;
		private System.Windows.Forms.Label lbl_zzmm;
		private System.Windows.Forms.TextBox txt_jtzz;
		private System.Windows.Forms.Label lbl_jtzz;
		private System.Windows.Forms.TextBox txt_lxdz;
		private System.Windows.Forms.Label lbl_lxdz;
		private System.Windows.Forms.TextBox txt_yzbm;
		private System.Windows.Forms.Label lbl_yzbm;
		private System.Windows.Forms.Label lbl_jg;
		private System.Windows.Forms.TextBox txt_dzyx;
		private System.Windows.Forms.Label lbl_dzyx;
		private System.Windows.Forms.TextBox txt_sfzh;
		private System.Windows.Forms.Label lbl_sfzh;
		private System.Windows.Forms.Label lbl_mz;
		private System.Windows.Forms.TextBox txt_xm;
		private System.Windows.Forms.Label lbl_xm;
		private System.Windows.Forms.Label lbl_xb;
		private System.Windows.Forms.Label lbl_csny;
		private System.Windows.Forms.TextBox txt_zjgbh;
		private System.Windows.Forms.Label lbl_jzgbh;
		private System.Windows.Forms.TextBox txt_bf;
		private System.Windows.Forms.ComboBox cbb_js;
		private System.Windows.Forms.Label lbl_bf;
		private System.Windows.Forms.Label lbl_js;
		private System.Windows.Forms.Button btn_sjr;
		private System.Windows.Forms.Button btn_qx;
		private System.Windows.Forms.Button btn_qdtj;
		private System.Windows.Forms.Button btn_sc;
		private System.Windows.Forms.Button btn_tj;
		private System.Windows.Forms.Button btn_bj;
		private System.Windows.Forms.Button btn_mjl;
		private System.Windows.Forms.Button btn_hyjl;
		private System.Windows.Forms.Button btn_qyjr;
		private System.Windows.Forms.ComboBox cbb_isT;
		private System.Windows.Forms.ComboBox cbb_whcd;
		private System.Windows.Forms.DateTimePicker dTP_csny;
		private System.Windows.Forms.DateTimePicker dTP_zjcymtsj;
		private System.Windows.Forms.DateTimePicker dTP_sccymtsj;
		private System.Windows.Forms.DateTimePicker dTP_fzrq;
		private System.Data.SqlClient.SqlConnection sqlcon;  //连接服务器
		private System.Data.DataSet dat;
		private int IsEorI=0;
		private string emp_id;
		private string table_name="1";
		private System.Windows.Forms.DataGrid dgd_jzg;
		private System.Windows.Forms.Button btn_xmcx;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label12;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public Form_jzg()
		{
			//
			// 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.pnl_jzg1 = new System.Windows.Forms.Panel();
			this.label12 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.label10 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.btn_xmcx = new System.Windows.Forms.Button();
			this.dTP_fzrq = new System.Windows.Forms.DateTimePicker();
			this.dTP_sccymtsj = new System.Windows.Forms.DateTimePicker();
			this.dTP_zjcymtsj = new System.Windows.Forms.DateTimePicker();
			this.dTP_csny = new System.Windows.Forms.DateTimePicker();
			this.cbb_whcd = new System.Windows.Forms.ComboBox();
			this.cbb_isT = new System.Windows.Forms.ComboBox();
			this.txt_bf = new System.Windows.Forms.TextBox();
			this.cbb_zyjszw = new System.Windows.Forms.ComboBox();
			this.cbb_js = new System.Windows.Forms.ComboBox();
			this.lbl_bf = new System.Windows.Forms.Label();
			this.lbl_sfjs = new System.Windows.Forms.Label();
			this.lbl_js = new System.Windows.Forms.Label();
			this.lbl_zjcymmsj = new System.Windows.Forms.Label();
			this.lbl_sccymtsj = new System.Windows.Forms.Label();
			this.txt_fzbm = new System.Windows.Forms.TextBox();
			this.lbl_fzbm = new System.Windows.Forms.Label();
			this.lbl_fzrq = new System.Windows.Forms.Label();
			this.txt_jszgzbh = new System.Windows.Forms.TextBox();
			this.lbl_jszgzbh = new System.Windows.Forms.Label();
			this.lbl_zyjszw = new System.Windows.Forms.Label();
			this.txt_zy = new System.Windows.Forms.TextBox();
			this.lbl_zy = new System.Windows.Forms.Label();
			this.txt_byyx = new System.Windows.Forms.TextBox();
			this.lbl_byyx = new System.Windows.Forms.Label();
			this.lbl_whcd = new System.Windows.Forms.Label();
			this.btn_sfzhcx = new System.Windows.Forms.Button();
			this.cbb_hyzk = new System.Windows.Forms.ComboBox();
			this.cbb_zzmm = new System.Windows.Forms.ComboBox();
			this.cbb_jg1 = new System.Windows.Forms.ComboBox();
			this.cbb_mz = new System.Windows.Forms.ComboBox();
			this.cbb_xb = new System.Windows.Forms.ComboBox();
			this.btn_jzgbhcx = new System.Windows.Forms.Button();
			this.lbl_hyzk = new System.Windows.Forms.Label();
			this.txt_lxdh = new System.Windows.Forms.TextBox();
			this.lbl_lxdh = new System.Windows.Forms.Label();
			this.txt_jtdh = new System.Windows.Forms.TextBox();
			this.lbl_jtdh = new System.Windows.Forms.Label();
			this.lbl_zzmm = new System.Windows.Forms.Label();
			this.txt_jtzz = new System.Windows.Forms.TextBox();
			this.lbl_jtzz = new System.Windows.Forms.Label();
			this.txt_lxdz = new System.Windows.Forms.TextBox();
			this.lbl_lxdz = new System.Windows.Forms.Label();
			this.txt_yzbm = new System.Windows.Forms.TextBox();
			this.lbl_yzbm = new System.Windows.Forms.Label();
			this.lbl_jg = new System.Windows.Forms.Label();
			this.txt_dzyx = new System.Windows.Forms.TextBox();
			this.lbl_dzyx = new System.Windows.Forms.Label();
			this.txt_sfzh = new System.Windows.Forms.TextBox();
			this.lbl_sfzh = new System.Windows.Forms.Label();
			this.lbl_mz = new System.Windows.Forms.Label();
			this.txt_xm = new System.Windows.Forms.TextBox();
			this.lbl_xm = new System.Windows.Forms.Label();
			this.lbl_xb = new System.Windows.Forms.Label();
			this.lbl_csny = new System.Windows.Forms.Label();
			this.txt_zjgbh = new System.Windows.Forms.TextBox();
			this.lbl_jzgbh = new System.Windows.Forms.Label();
			this.btn_xxzl = new System.Windows.Forms.Button();
			this.btn_qx = new System.Windows.Forms.Button();
			this.btn_qdtj = 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_qyjr = new System.Windows.Forms.Button();
			this.btn_sjr = new System.Windows.Forms.Button();
			this.pnl_jzg2 = new System.Windows.Forms.Panel();
			this.dgd_jzg = new System.Windows.Forms.DataGrid();
			this.pnl_jzg1.SuspendLayout();
			this.pnl_jzg2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dgd_jzg)).BeginInit();
			this.SuspendLayout();
			// 
			// pnl_jzg1
			// 
			this.pnl_jzg1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
			this.pnl_jzg1.Controls.Add(this.label12);
			this.pnl_jzg1.Controls.Add(this.label11);
			this.pnl_jzg1.Controls.Add(this.label10);
			this.pnl_jzg1.Controls.Add(this.label9);
			this.pnl_jzg1.Controls.Add(this.label8);
			this.pnl_jzg1.Controls.Add(this.label7);
			this.pnl_jzg1.Controls.Add(this.label6);
			this.pnl_jzg1.Controls.Add(this.label5);
			this.pnl_jzg1.Controls.Add(this.label4);
			this.pnl_jzg1.Controls.Add(this.label3);
			this.pnl_jzg1.Controls.Add(this.label2);
			this.pnl_jzg1.Controls.Add(this.label1);
			this.pnl_jzg1.Controls.Add(this.btn_xmcx);
			this.pnl_jzg1.Controls.Add(this.dTP_fzrq);
			this.pnl_jzg1.Controls.Add(this.dTP_sccymtsj);
			this.pnl_jzg1.Controls.Add(this.dTP_zjcymtsj);
			this.pnl_jzg1.Controls.Add(this.dTP_csny);
			this.pnl_jzg1.Controls.Add(this.cbb_whcd);
			this.pnl_jzg1.Controls.Add(this.cbb_isT);
			this.pnl_jzg1.Controls.Add(this.txt_bf);
			this.pnl_jzg1.Controls.Add(this.cbb_zyjszw);
			this.pnl_jzg1.Controls.Add(this.cbb_js);
			this.pnl_jzg1.Controls.Add(this.lbl_bf);
			this.pnl_jzg1.Controls.Add(this.lbl_sfjs);
			this.pnl_jzg1.Controls.Add(this.lbl_js);
			this.pnl_jzg1.Controls.Add(this.lbl_zjcymmsj);
			this.pnl_jzg1.Controls.Add(this.lbl_sccymtsj);
			this.pnl_jzg1.Controls.Add(this.txt_fzbm);
			this.pnl_jzg1.Controls.Add(this.lbl_fzbm);
			this.pnl_jzg1.Controls.Add(this.lbl_fzrq);
			this.pnl_jzg1.Controls.Add(this.txt_jszgzbh);
			this.pnl_jzg1.Controls.Add(this.lbl_jszgzbh);
			this.pnl_jzg1.Controls.Add(this.lbl_zyjszw);
			this.pnl_jzg1.Controls.Add(this.txt_zy);
			this.pnl_jzg1.Controls.Add(this.lbl_zy);
			this.pnl_jzg1.Controls.Add(this.txt_byyx);
			this.pnl_jzg1.Controls.Add(this.lbl_byyx);
			this.pnl_jzg1.Controls.Add(this.lbl_whcd);
			this.pnl_jzg1.Controls.Add(this.btn_sfzhcx);
			this.pnl_jzg1.Controls.Add(this.cbb_hyzk);
			this.pnl_jzg1.Controls.Add(this.cbb_zzmm);
			this.pnl_jzg1.Controls.Add(this.cbb_jg1);
			this.pnl_jzg1.Controls.Add(this.cbb_mz);
			this.pnl_jzg1.Controls.Add(this.cbb_xb);
			this.pnl_jzg1.Controls.Add(this.btn_jzgbhcx);
			this.pnl_jzg1.Controls.Add(this.lbl_hyzk);
			this.pnl_jzg1.Controls.Add(this.txt_lxdh);
			this.pnl_jzg1.Controls.Add(this.lbl_lxdh);
			this.pnl_jzg1.Controls.Add(this.txt_jtdh);
			this.pnl_jzg1.Controls.Add(this.lbl_jtdh);
			this.pnl_jzg1.Controls.Add(this.lbl_zzmm);
			this.pnl_jzg1.Controls.Add(this.txt_jtzz);
			this.pnl_jzg1.Controls.Add(this.lbl_jtzz);
			this.pnl_jzg1.Controls.Add(this.txt_lxdz);
			this.pnl_jzg1.Controls.Add(this.lbl_lxdz);
			this.pnl_jzg1.Controls.Add(this.txt_yzbm);
			this.pnl_jzg1.Controls.Add(this.lbl_yzbm);
			this.pnl_jzg1.Controls.Add(this.lbl_jg);
			this.pnl_jzg1.Controls.Add(this.txt_dzyx);
			this.pnl_jzg1.Controls.Add(this.lbl_dzyx);
			this.pnl_jzg1.Controls.Add(this.txt_sfzh);
			this.pnl_jzg1.Controls.Add(this.lbl_sfzh);
			this.pnl_jzg1.Controls.Add(this.lbl_mz);
			this.pnl_jzg1.Controls.Add(this.txt_xm);
			this.pnl_jzg1.Controls.Add(this.lbl_xm);
			this.pnl_jzg1.Controls.Add(this.lbl_xb);
			this.pnl_jzg1.Controls.Add(this.lbl_csny);
			this.pnl_jzg1.Controls.Add(this.txt_zjgbh);
			this.pnl_jzg1.Controls.Add(this.lbl_jzgbh);
			this.pnl_jzg1.Location = new System.Drawing.Point(0, 296);
			this.pnl_jzg1.Name = "pnl_jzg1";
			this.pnl_jzg1.Size = new System.Drawing.Size(792, 200);
			this.pnl_jzg1.TabIndex = 1;
			this.pnl_jzg1.Paint += new System.Windows.Forms.PaintEventHandler(this.panel2_Paint);
			// 
			// label12
			// 
			this.label12.Location = new System.Drawing.Point(16, 328);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(16, 16);
			this.label12.TabIndex = 208;
			this.label12.Text = "*";
			// 
			// label11
			// 
			this.label11.Location = new System.Drawing.Point(8, 288);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(16, 16);
			this.label11.TabIndex = 207;
			this.label11.Text = "*";