form_xy.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_xy : System.Windows.Forms.Form
	{
		private System.Windows.Forms.DataGrid dgd_xy;
		private System.Windows.Forms.Panel panel2;
		private System.Windows.Forms.Label lbl_bz;
		private System.Windows.Forms.Label lbl_jl;
		internal System.Windows.Forms.TextBox txt_bz;
		internal System.Windows.Forms.TextBox txt_jl;
		internal System.Windows.Forms.TextBox txt_dnnl;
		internal System.Windows.Forms.TextBox txt_byyx;
		internal System.Windows.Forms.TextBox txt_dzyj;
		internal System.Windows.Forms.TextBox txt_txdz;
		internal System.Windows.Forms.TextBox txt_zcf;
		internal System.Windows.Forms.TextBox txt_jcf;
		internal System.Windows.Forms.TextBox txt_wycd;
		internal System.Windows.Forms.TextBox txt_xl;
		internal System.Windows.Forms.TextBox txt_zw;
		internal System.Windows.Forms.TextBox txt_gzdw;
		internal System.Windows.Forms.TextBox txt_xf;
		internal System.Windows.Forms.TextBox txt_zyjs;
		internal System.Windows.Forms.Label lbl_zsf;
		internal System.Windows.Forms.Label lbl_dnnl;
		internal System.Windows.Forms.Label lbl_byyx;
		internal System.Windows.Forms.Label lbl_whcd;
		internal System.Windows.Forms.Label lbl_txdz;
		internal System.Windows.Forms.Label lbl_zzmm;
		internal System.Windows.Forms.Label lbl_dzyj;
		internal System.Windows.Forms.Label lbl_jcf;
		internal System.Windows.Forms.Label lbl_wycd;
		internal System.Windows.Forms.Label lbl_xl;
		internal System.Windows.Forms.Label lbl_zw;
		internal System.Windows.Forms.Label lbl_gzdw;
		internal System.Windows.Forms.Label lbl_mz;
		internal System.Windows.Forms.Label lbl_kbrq;
		internal System.Windows.Forms.Label lbl_xf;
		internal System.Windows.Forms.Label lbl_zyjs;
		internal System.Windows.Forms.Label lbl_hy;
		internal System.Windows.Forms.Label lbl_hyzk;
		internal System.Windows.Forms.Label lbl_jg;
		internal System.Windows.Forms.ComboBox cbb_xb;
		internal System.Windows.Forms.Button btn_sfzhcx;
		internal System.Windows.Forms.Button btn_xhcx;
		internal System.Windows.Forms.TextBox txt_jtdz;
		internal System.Windows.Forms.TextBox txt_jtdh;
		internal System.Windows.Forms.TextBox txt_yzbm;
		internal System.Windows.Forms.TextBox txt_xm;
		internal System.Windows.Forms.TextBox txt_sfzh;
		internal System.Windows.Forms.TextBox txt_lxdh;
		internal System.Windows.Forms.TextBox txt_xh;
		internal System.Windows.Forms.Label lbl_hmrq;
		internal System.Windows.Forms.Label lbl_xxfs;
		internal System.Windows.Forms.Label lbl_jtdz;
		internal System.Windows.Forms.Label lbl_xb;
		internal System.Windows.Forms.Label lbl_bj;
		internal System.Windows.Forms.Label lbl_jtdh;
		internal System.Windows.Forms.Label lbl_yzbm;
		internal System.Windows.Forms.Label lbl_xm;
		internal System.Windows.Forms.Label lbl_sfzh;
		internal System.Windows.Forms.Label lbl_lxdh;
		internal System.Windows.Forms.Label lbl_csny;
		internal System.Windows.Forms.Label lbl_xh;
		internal System.Windows.Forms.Button btn_xxxx;
		private System.Windows.Forms.Panel pnl_xy1;
		internal System.Windows.Forms.Button btn_qx;
		internal System.Windows.Forms.Button btn_qdtj;
		internal System.Windows.Forms.Button btn_sc;
		internal System.Windows.Forms.Button btn_tj;
		internal System.Windows.Forms.Button btn_bj;
		internal System.Windows.Forms.Button btn_mjl;
		internal System.Windows.Forms.Button btn_hyjr;
		internal System.Windows.Forms.Button btn_qyjl;
		internal System.Windows.Forms.Button btn_sjl;
		private System.Windows.Forms.ComboBox cbb_jg;
		private System.Windows.Forms.ComboBox cbb_hyzk;
		private System.Windows.Forms.ComboBox cbb_zzmm;
		private System.Windows.Forms.ComboBox cbb_whcd;
		private System.Windows.Forms.ComboBox cbb_hy;
		private System.Windows.Forms.ComboBox cbb_bj;
		private System.Windows.Forms.ComboBox cbb_mz;
		private System.Windows.Forms.Label lbl_zyjszu;
		private System.Windows.Forms.ComboBox cbb_zyjszw;

		private System.Data.SqlClient.SqlConnection sqlcon;  //连接服务器
		private System.Data.DataSet dat;
		private int IsEorI=0;
		private string stu_id;
		private string table_name="1";
		private System.Windows.Forms.DateTimePicker dtp_csny;
		private System.Windows.Forms.DateTimePicker dtp_bnrq;
		private System.Windows.Forms.DateTimePicker dtp_kbrq;
		private System.Windows.Forms.ComboBox cbb_xxfs;
		private System.Windows.Forms.Label lbl_yj;
		private System.Windows.Forms.TextBox txt_yj;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		internal System.Windows.Forms.Button btn_xmcx;
		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;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label15;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public Form_xy()
		{
			//
			// 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_xy1 = new System.Windows.Forms.Panel();
			this.label15 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.label13 = new System.Windows.Forms.Label();
			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.btn_xmcx = new System.Windows.Forms.Button();
			this.label3 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.txt_yj = new System.Windows.Forms.TextBox();
			this.lbl_yj = new System.Windows.Forms.Label();
			this.cbb_xxfs = new System.Windows.Forms.ComboBox();
			this.dtp_bnrq = new System.Windows.Forms.DateTimePicker();
			this.dtp_csny = new System.Windows.Forms.DateTimePicker();
			this.cbb_zyjszw = new System.Windows.Forms.ComboBox();
			this.lbl_zyjszu = new System.Windows.Forms.Label();
			this.cbb_mz = new System.Windows.Forms.ComboBox();
			this.cbb_bj = new System.Windows.Forms.ComboBox();
			this.cbb_hy = new System.Windows.Forms.ComboBox();
			this.cbb_whcd = new System.Windows.Forms.ComboBox();
			this.cbb_zzmm = new System.Windows.Forms.ComboBox();
			this.cbb_hyzk = new System.Windows.Forms.ComboBox();
			this.cbb_jg = new System.Windows.Forms.ComboBox();
			this.lbl_bz = new System.Windows.Forms.Label();
			this.lbl_jl = new System.Windows.Forms.Label();
			this.txt_bz = new System.Windows.Forms.TextBox();
			this.txt_jl = new System.Windows.Forms.TextBox();
			this.txt_dnnl = new System.Windows.Forms.TextBox();
			this.txt_byyx = new System.Windows.Forms.TextBox();
			this.txt_dzyj = new System.Windows.Forms.TextBox();
			this.txt_txdz = new System.Windows.Forms.TextBox();
			this.txt_zcf = new System.Windows.Forms.TextBox();
			this.txt_jcf = new System.Windows.Forms.TextBox();
			this.txt_wycd = new System.Windows.Forms.TextBox();
			this.txt_xl = new System.Windows.Forms.TextBox();
			this.txt_zw = new System.Windows.Forms.TextBox();
			this.txt_gzdw = new System.Windows.Forms.TextBox();
			this.txt_xf = new System.Windows.Forms.TextBox();
			this.txt_zyjs = new System.Windows.Forms.TextBox();
			this.lbl_zsf = new System.Windows.Forms.Label();
			this.lbl_dnnl = new System.Windows.Forms.Label();
			this.lbl_byyx = new System.Windows.Forms.Label();
			this.lbl_whcd = new System.Windows.Forms.Label();
			this.lbl_txdz = new System.Windows.Forms.Label();
			this.lbl_zzmm = new System.Windows.Forms.Label();
			this.lbl_dzyj = new System.Windows.Forms.Label();
			this.lbl_jcf = new System.Windows.Forms.Label();
			this.lbl_wycd = new System.Windows.Forms.Label();
			this.lbl_xl = new System.Windows.Forms.Label();
			this.lbl_zw = new System.Windows.Forms.Label();
			this.lbl_gzdw = new System.Windows.Forms.Label();
			this.lbl_mz = new System.Windows.Forms.Label();
			this.lbl_kbrq = new System.Windows.Forms.Label();
			this.lbl_xf = new System.Windows.Forms.Label();
			this.lbl_zyjs = new System.Windows.Forms.Label();
			this.lbl_hy = new System.Windows.Forms.Label();
			this.lbl_hyzk = new System.Windows.Forms.Label();
			this.lbl_jg = new System.Windows.Forms.Label();
			this.cbb_xb = new System.Windows.Forms.ComboBox();
			this.btn_sfzhcx = new System.Windows.Forms.Button();
			this.btn_xhcx = new System.Windows.Forms.Button();
			this.txt_jtdz = new System.Windows.Forms.TextBox();
			this.txt_jtdh = new System.Windows.Forms.TextBox();
			this.txt_yzbm = new System.Windows.Forms.TextBox();
			this.txt_xm = new System.Windows.Forms.TextBox();
			this.txt_sfzh = new System.Windows.Forms.TextBox();
			this.txt_lxdh = new System.Windows.Forms.TextBox();
			this.txt_xh = new System.Windows.Forms.TextBox();
			this.lbl_hmrq = new System.Windows.Forms.Label();
			this.lbl_xxfs = new System.Windows.Forms.Label();
			this.lbl_jtdz = new System.Windows.Forms.Label();
			this.lbl_xb = new System.Windows.Forms.Label();
			this.lbl_bj = new System.Windows.Forms.Label();
			this.lbl_jtdh = new System.Windows.Forms.Label();
			this.lbl_yzbm = new System.Windows.Forms.Label();
			this.lbl_xm = new System.Windows.Forms.Label();
			this.lbl_sfzh = new System.Windows.Forms.Label();
			this.lbl_lxdh = new System.Windows.Forms.Label();
			this.lbl_csny = new System.Windows.Forms.Label();
			this.lbl_xh = new System.Windows.Forms.Label();
			this.dtp_kbrq = new System.Windows.Forms.DateTimePicker();
			this.dgd_xy = new System.Windows.Forms.DataGrid();
			this.panel2 = new System.Windows.Forms.Panel();
			this.btn_xxxx = 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_hyjr = new System.Windows.Forms.Button();
			this.btn_qyjl = new System.Windows.Forms.Button();
			this.btn_sjl = new System.Windows.Forms.Button();
			this.pnl_xy1.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dgd_xy)).BeginInit();
			this.panel2.SuspendLayout();
			this.SuspendLayout();
			// 
			// pnl_xy1
			// 
			this.pnl_xy1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
			this.pnl_xy1.Controls.Add(this.label15);
			this.pnl_xy1.Controls.Add(this.label14);
			this.pnl_xy1.Controls.Add(this.label13);
			this.pnl_xy1.Controls.Add(this.label12);
			this.pnl_xy1.Controls.Add(this.label11);
			this.pnl_xy1.Controls.Add(this.label10);
			this.pnl_xy1.Controls.Add(this.label9);
			this.pnl_xy1.Controls.Add(this.label8);
			this.pnl_xy1.Controls.Add(this.label7);
			this.pnl_xy1.Controls.Add(this.label6);
			this.pnl_xy1.Controls.Add(this.label5);
			this.pnl_xy1.Controls.Add(this.label4);
			this.pnl_xy1.Controls.Add(this.btn_xmcx);
			this.pnl_xy1.Controls.Add(this.label3);
			this.pnl_xy1.Controls.Add(this.label2);
			this.pnl_xy1.Controls.Add(this.label1);
			this.pnl_xy1.Controls.Add(this.txt_yj);
			this.pnl_xy1.Controls.Add(this.lbl_yj);
			this.pnl_xy1.Controls.Add(this.cbb_xxfs);
			this.pnl_xy1.Controls.Add(this.dtp_bnrq);
			this.pnl_xy1.Controls.Add(this.dtp_csny);
			this.pnl_xy1.Controls.Add(this.cbb_zyjszw);
			this.pnl_xy1.Controls.Add(this.lbl_zyjszu);
			this.pnl_xy1.Controls.Add(this.cbb_mz);
			this.pnl_xy1.Controls.Add(this.cbb_bj);
			this.pnl_xy1.Controls.Add(this.cbb_hy);
			this.pnl_xy1.Controls.Add(this.cbb_whcd);
			this.pnl_xy1.Controls.Add(this.cbb_zzmm);
			this.pnl_xy1.Controls.Add(this.cbb_hyzk);
			this.pnl_xy1.Controls.Add(this.cbb_jg);
			this.pnl_xy1.Controls.Add(this.lbl_bz);
			this.pnl_xy1.Controls.Add(this.lbl_jl);
			this.pnl_xy1.Controls.Add(this.txt_bz);
			this.pnl_xy1.Controls.Add(this.txt_jl);
			this.pnl_xy1.Controls.Add(this.txt_dnnl);
			this.pnl_xy1.Controls.Add(this.txt_byyx);
			this.pnl_xy1.Controls.Add(this.txt_dzyj);
			this.pnl_xy1.Controls.Add(this.txt_txdz);
			this.pnl_xy1.Controls.Add(this.txt_zcf);
			this.pnl_xy1.Controls.Add(this.txt_jcf);
			this.pnl_xy1.Controls.Add(this.txt_wycd);
			this.pnl_xy1.Controls.Add(this.txt_xl);
			this.pnl_xy1.Controls.Add(this.txt_zw);
			this.pnl_xy1.Controls.Add(this.txt_gzdw);
			this.pnl_xy1.Controls.Add(this.txt_xf);
			this.pnl_xy1.Controls.Add(this.txt_zyjs);
			this.pnl_xy1.Controls.Add(this.lbl_zsf);
			this.pnl_xy1.Controls.Add(this.lbl_dnnl);
			this.pnl_xy1.Controls.Add(this.lbl_byyx);
			this.pnl_xy1.Controls.Add(this.lbl_whcd);
			this.pnl_xy1.Controls.Add(this.lbl_txdz);
			this.pnl_xy1.Controls.Add(this.lbl_zzmm);
			this.pnl_xy1.Controls.Add(this.lbl_dzyj);
			this.pnl_xy1.Controls.Add(this.lbl_jcf);
			this.pnl_xy1.Controls.Add(this.lbl_wycd);
			this.pnl_xy1.Controls.Add(this.lbl_xl);
			this.pnl_xy1.Controls.Add(this.lbl_zw);
			this.pnl_xy1.Controls.Add(this.lbl_gzdw);
			this.pnl_xy1.Controls.Add(this.lbl_mz);
			this.pnl_xy1.Controls.Add(this.lbl_kbrq);
			this.pnl_xy1.Controls.Add(this.lbl_xf);
			this.pnl_xy1.Controls.Add(this.lbl_zyjs);
			this.pnl_xy1.Controls.Add(this.lbl_hy);
			this.pnl_xy1.Controls.Add(this.lbl_hyzk);
			this.pnl_xy1.Controls.Add(this.lbl_jg);
			this.pnl_xy1.Controls.Add(this.cbb_xb);
			this.pnl_xy1.Controls.Add(this.btn_sfzhcx);
			this.pnl_xy1.Controls.Add(this.btn_xhcx);
			this.pnl_xy1.Controls.Add(this.txt_jtdz);
			this.pnl_xy1.Controls.Add(this.txt_jtdh);
			this.pnl_xy1.Controls.Add(this.txt_yzbm);
			this.pnl_xy1.Controls.Add(this.txt_xm);
			this.pnl_xy1.Controls.Add(this.txt_sfzh);
			this.pnl_xy1.Controls.Add(this.txt_lxdh);
			this.pnl_xy1.Controls.Add(this.txt_xh);
			this.pnl_xy1.Controls.Add(this.lbl_hmrq);
			this.pnl_xy1.Controls.Add(this.lbl_xxfs);