form_kqsb.cs

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

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


namespace bizdb
{
	/// <summary>
	/// Form_kqsb 的摘要说明。
	/// </summary>
	public class Form_kqsb : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Button btn_tj;
		private System.Windows.Forms.GroupBox gpb_stu_mes;
		private System.Windows.Forms.PictureBox pic_stu_img;
		private System.Windows.Forms.Label lbl_stu_name;
		private System.Windows.Forms.Button btn_dy;
		private System.Windows.Forms.Button btn_cx;
		private System.Windows.Forms.GroupBox gpb_exam_mes;
		private System.Windows.Forms.TextBox txt_zkzh;
		private System.Windows.Forms.DateTimePicker dtp_ksrq;
		private System.Windows.Forms.ComboBox cbo_kskm;
		private System.Windows.Forms.ComboBox cbo_yxfx;
		private System.Windows.Forms.Label lbl_kskm;
		private System.Windows.Forms.Label lbl_ksdd;
		private System.Windows.Forms.Label lbl_ksrq;
		private System.Windows.Forms.Label lbl_zkzh;
		private System.Windows.Forms.ComboBox cbo_ksdd;
		private System.Windows.Forms.TextBox txt_stu_sex;
		private System.Windows.Forms.TextBox txt_nat;
		private System.Windows.Forms.TextBox txt_stu_diploma;
		private System.Windows.Forms.Label lbl_stu_sex;
		private System.Windows.Forms.Label lbl_stu_identityno;
		private System.Windows.Forms.Label lbl_stu_tel;
		private System.Windows.Forms.Label lbl_stu_email;
		private System.Windows.Forms.Label lbl_stu_diploma;
		private System.Windows.Forms.TextBox txt_stu_identityno;
		private System.Windows.Forms.TextBox txt__stu_tel;
		private System.Windows.Forms.TextBox txt_stu_email;
		private System.Windows.Forms.Label lbl_nat;
		private System.Windows.Forms.Label lbl_stu_college;
		private System.Windows.Forms.TextBox txt__stu_college;
		private System.Windows.Forms.Label lbl_stu_address;
		private System.Windows.Forms.TextBox txt_stu_address;
		private System.Windows.Forms.Label lbl_yxfx;
		private System.Windows.Forms.GroupBox gpb_ExaI_memo;
		private System.Windows.Forms.Label lbl_zyfx;
		private System.Windows.Forms.ComboBox cbo_zyfx;
		private System.Windows.Forms.TextBox txt_ExaI_memo;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox textBox1;
		private System.Windows.Forms.TextBox textBox2;
		private System.Windows.Forms.Label label2;
		private dbAccess db = new dbAccess();
		private System.Windows.Forms.ComboBox cbo_stu_name;
		private System.Windows.Forms.TextBox txt_stu_id;

		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public Form_kqsb()
		{
			//
			// 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.btn_tj = new System.Windows.Forms.Button();
			this.gpb_stu_mes = new System.Windows.Forms.GroupBox();
			this.txt_stu_sex = new System.Windows.Forms.TextBox();
			this.txt_nat = new System.Windows.Forms.TextBox();
			this.txt_stu_diploma = new System.Windows.Forms.TextBox();
			this.pic_stu_img = new System.Windows.Forms.PictureBox();
			this.lbl_stu_name = new System.Windows.Forms.Label();
			this.lbl_stu_sex = new System.Windows.Forms.Label();
			this.lbl_stu_identityno = new System.Windows.Forms.Label();
			this.lbl_stu_tel = new System.Windows.Forms.Label();
			this.lbl_stu_email = new System.Windows.Forms.Label();
			this.lbl_stu_diploma = new System.Windows.Forms.Label();
			this.txt_stu_identityno = new System.Windows.Forms.TextBox();
			this.txt__stu_tel = new System.Windows.Forms.TextBox();
			this.txt_stu_email = new System.Windows.Forms.TextBox();
			this.lbl_nat = new System.Windows.Forms.Label();
			this.lbl_stu_college = new System.Windows.Forms.Label();
			this.txt__stu_college = new System.Windows.Forms.TextBox();
			this.lbl_stu_address = new System.Windows.Forms.Label();
			this.txt_stu_address = new System.Windows.Forms.TextBox();
			this.btn_dy = new System.Windows.Forms.Button();
			this.btn_cx = new System.Windows.Forms.Button();
			this.gpb_exam_mes = new System.Windows.Forms.GroupBox();
			this.label2 = new System.Windows.Forms.Label();
			this.textBox2 = new System.Windows.Forms.TextBox();
			this.textBox1 = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			this.cbo_zyfx = new System.Windows.Forms.ComboBox();
			this.lbl_zyfx = new System.Windows.Forms.Label();
			this.txt_zkzh = new System.Windows.Forms.TextBox();
			this.dtp_ksrq = new System.Windows.Forms.DateTimePicker();
			this.cbo_kskm = new System.Windows.Forms.ComboBox();
			this.cbo_yxfx = new System.Windows.Forms.ComboBox();
			this.lbl_yxfx = new System.Windows.Forms.Label();
			this.lbl_kskm = new System.Windows.Forms.Label();
			this.lbl_ksdd = new System.Windows.Forms.Label();
			this.lbl_ksrq = new System.Windows.Forms.Label();
			this.lbl_zkzh = new System.Windows.Forms.Label();
			this.cbo_ksdd = new System.Windows.Forms.ComboBox();
			this.gpb_ExaI_memo = new System.Windows.Forms.GroupBox();
			this.txt_ExaI_memo = new System.Windows.Forms.TextBox();
			this.cbo_stu_name = new System.Windows.Forms.ComboBox();
			this.txt_stu_id = new System.Windows.Forms.TextBox();
			this.gpb_stu_mes.SuspendLayout();
			this.gpb_exam_mes.SuspendLayout();
			this.gpb_ExaI_memo.SuspendLayout();
			this.SuspendLayout();
			// 
			// btn_tj
			// 
			this.btn_tj.Location = new System.Drawing.Point(584, 432);
			this.btn_tj.Name = "btn_tj";
			this.btn_tj.Size = new System.Drawing.Size(75, 32);
			this.btn_tj.TabIndex = 21;
			this.btn_tj.Text = "提交";
			this.btn_tj.Click += new System.EventHandler(this.btn_tj_Click);
			// 
			// gpb_stu_mes
			// 
			this.gpb_stu_mes.Controls.Add(this.cbo_stu_name);
			this.gpb_stu_mes.Controls.Add(this.txt_stu_sex);
			this.gpb_stu_mes.Controls.Add(this.txt_nat);
			this.gpb_stu_mes.Controls.Add(this.txt_stu_diploma);
			this.gpb_stu_mes.Controls.Add(this.pic_stu_img);
			this.gpb_stu_mes.Controls.Add(this.lbl_stu_name);
			this.gpb_stu_mes.Controls.Add(this.lbl_stu_sex);
			this.gpb_stu_mes.Controls.Add(this.lbl_stu_identityno);
			this.gpb_stu_mes.Controls.Add(this.lbl_stu_tel);
			this.gpb_stu_mes.Controls.Add(this.lbl_stu_email);
			this.gpb_stu_mes.Controls.Add(this.lbl_stu_diploma);
			this.gpb_stu_mes.Controls.Add(this.txt_stu_identityno);
			this.gpb_stu_mes.Controls.Add(this.txt__stu_tel);
			this.gpb_stu_mes.Controls.Add(this.txt_stu_email);
			this.gpb_stu_mes.Controls.Add(this.lbl_nat);
			this.gpb_stu_mes.Controls.Add(this.lbl_stu_college);
			this.gpb_stu_mes.Controls.Add(this.txt__stu_college);
			this.gpb_stu_mes.Controls.Add(this.lbl_stu_address);
			this.gpb_stu_mes.Controls.Add(this.txt_stu_address);
			this.gpb_stu_mes.Location = new System.Drawing.Point(56, 40);
			this.gpb_stu_mes.Name = "gpb_stu_mes";
			this.gpb_stu_mes.Size = new System.Drawing.Size(396, 424);
			this.gpb_stu_mes.TabIndex = 20;
			this.gpb_stu_mes.TabStop = false;
			this.gpb_stu_mes.Text = "学员信息";
			// 
			// txt_stu_sex
			// 
			this.txt_stu_sex.Location = new System.Drawing.Point(88, 80);
			this.txt_stu_sex.Name = "txt_stu_sex";
			this.txt_stu_sex.ReadOnly = true;
			this.txt_stu_sex.Size = new System.Drawing.Size(48, 21);
			this.txt_stu_sex.TabIndex = 6;
			this.txt_stu_sex.Text = "";
			// 
			// txt_nat
			// 
			this.txt_nat.Location = new System.Drawing.Point(88, 120);
			this.txt_nat.Name = "txt_nat";
			this.txt_nat.ReadOnly = true;
			this.txt_nat.Size = new System.Drawing.Size(72, 21);
			this.txt_nat.TabIndex = 5;
			this.txt_nat.Text = "";
			// 
			// txt_stu_diploma
			// 
			this.txt_stu_diploma.Location = new System.Drawing.Point(88, 384);
			this.txt_stu_diploma.Name = "txt_stu_diploma";
			this.txt_stu_diploma.ReadOnly = true;
			this.txt_stu_diploma.Size = new System.Drawing.Size(296, 21);
			this.txt_stu_diploma.TabIndex = 4;
			this.txt_stu_diploma.Text = "";
			// 
			// pic_stu_img
			// 
			this.pic_stu_img.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
			this.pic_stu_img.Location = new System.Drawing.Point(264, 24);
			this.pic_stu_img.Name = "pic_stu_img";
			this.pic_stu_img.Size = new System.Drawing.Size(120, 144);
			this.pic_stu_img.TabIndex = 3;
			this.pic_stu_img.TabStop = false;
			// 
			// lbl_stu_name
			// 
			this.lbl_stu_name.Location = new System.Drawing.Point(16, 48);
			this.lbl_stu_name.Name = "lbl_stu_name";
			this.lbl_stu_name.Size = new System.Drawing.Size(48, 16);
			this.lbl_stu_name.TabIndex = 0;
			this.lbl_stu_name.Text = "姓   名";
			// 
			// lbl_stu_sex
			// 
			this.lbl_stu_sex.Location = new System.Drawing.Point(16, 88);
			this.lbl_stu_sex.Name = "lbl_stu_sex";
			this.lbl_stu_sex.Size = new System.Drawing.Size(48, 16);
			this.lbl_stu_sex.TabIndex = 0;
			this.lbl_stu_sex.Text = "性   别";
			// 
			// lbl_stu_identityno
			// 
			this.lbl_stu_identityno.Location = new System.Drawing.Point(16, 168);
			this.lbl_stu_identityno.Name = "lbl_stu_identityno";
			this.lbl_stu_identityno.Size = new System.Drawing.Size(56, 16);
			this.lbl_stu_identityno.TabIndex = 0;
			this.lbl_stu_identityno.Text = "身份证号";
			// 
			// lbl_stu_tel
			// 
			this.lbl_stu_tel.Location = new System.Drawing.Point(16, 216);
			this.lbl_stu_tel.Name = "lbl_stu_tel";
			this.lbl_stu_tel.Size = new System.Drawing.Size(56, 16);
			this.lbl_stu_tel.TabIndex = 0;
			this.lbl_stu_tel.Text = "联系电话";
			// 
			// lbl_stu_email
			// 
			this.lbl_stu_email.Location = new System.Drawing.Point(16, 264);
			this.lbl_stu_email.Name = "lbl_stu_email";
			this.lbl_stu_email.Size = new System.Drawing.Size(56, 16);
			this.lbl_stu_email.TabIndex = 0;
			this.lbl_stu_email.Text = "电子邮件";
			// 
			// lbl_stu_diploma
			// 
			this.lbl_stu_diploma.Location = new System.Drawing.Point(16, 392);
			this.lbl_stu_diploma.Name = "lbl_stu_diploma";
			this.lbl_stu_diploma.Size = new System.Drawing.Size(56, 16);
			this.lbl_stu_diploma.TabIndex = 0;
			this.lbl_stu_diploma.Text = "最高学历";
			// 
			// txt_stu_identityno
			// 
			this.txt_stu_identityno.Location = new System.Drawing.Point(88, 160);
			this.txt_stu_identityno.Name = "txt_stu_identityno";
			this.txt_stu_identityno.ReadOnly = true;
			this.txt_stu_identityno.Size = new System.Drawing.Size(160, 21);
			this.txt_stu_identityno.TabIndex = 1;
			this.txt_stu_identityno.Text = "";
			// 
			// txt__stu_tel
			// 
			this.txt__stu_tel.Location = new System.Drawing.Point(88, 208);
			this.txt__stu_tel.Name = "txt__stu_tel";
			this.txt__stu_tel.ReadOnly = true;
			this.txt__stu_tel.Size = new System.Drawing.Size(296, 21);
			this.txt__stu_tel.TabIndex = 1;
			this.txt__stu_tel.Text = "";
			// 
			// txt_stu_email
			// 
			this.txt_stu_email.Location = new System.Drawing.Point(88, 256);
			this.txt_stu_email.Name = "txt_stu_email";
			this.txt_stu_email.ReadOnly = true;
			this.txt_stu_email.Size = new System.Drawing.Size(296, 21);
			this.txt_stu_email.TabIndex = 1;
			this.txt_stu_email.Text = "";
			// 
			// lbl_nat
			// 
			this.lbl_nat.Location = new System.Drawing.Point(16, 128);
			this.lbl_nat.Name = "lbl_nat";
			this.lbl_nat.Size = new System.Drawing.Size(48, 16);
			this.lbl_nat.TabIndex = 0;
			this.lbl_nat.Text = "民   族";
			// 
			// lbl_stu_college
			// 
			this.lbl_stu_college.Location = new System.Drawing.Point(16, 352);
			this.lbl_stu_college.Name = "lbl_stu_college";
			this.lbl_stu_college.Size = new System.Drawing.Size(56, 16);
			this.lbl_stu_college.TabIndex = 0;
			this.lbl_stu_college.Text = "毕业院校";
			// 
			// txt__stu_college
			// 
			this.txt__stu_college.Location = new System.Drawing.Point(88, 344);
			this.txt__stu_college.Name = "txt__stu_college";
			this.txt__stu_college.ReadOnly = true;
			this.txt__stu_college.Size = new System.Drawing.Size(296, 21);
			this.txt__stu_college.TabIndex = 1;
			this.txt__stu_college.Text = "";
			// 
			// lbl_stu_address
			// 
			this.lbl_stu_address.Location = new System.Drawing.Point(16, 304);
			this.lbl_stu_address.Name = "lbl_stu_address";
			this.lbl_stu_address.Size = new System.Drawing.Size(56, 16);
			this.lbl_stu_address.TabIndex = 0;
			this.lbl_stu_address.Text = "通讯地址";
			// 
			// txt_stu_address
			// 
			this.txt_stu_address.Location = new System.Drawing.Point(88, 296);
			this.txt_stu_address.Name = "txt_stu_address";
			this.txt_stu_address.ReadOnly = true;
			this.txt_stu_address.Size = new System.Drawing.Size(296, 21);
			this.txt_stu_address.TabIndex = 1;
			this.txt_stu_address.Text = "";
			// 
			// btn_dy
			// 
			this.btn_dy.Location = new System.Drawing.Point(680, 432);
			this.btn_dy.Name = "btn_dy";
			this.btn_dy.Size = new System.Drawing.Size(75, 32);
			this.btn_dy.TabIndex = 22;
			this.btn_dy.Text = "打印";
			// 
			// btn_cx
			// 
			this.btn_cx.Location = new System.Drawing.Point(488, 432);
			this.btn_cx.Name = "btn_cx";
			this.btn_cx.Size = new System.Drawing.Size(72, 32);
			this.btn_cx.TabIndex = 18;
			this.btn_cx.Text = "查询";
			this.btn_cx.Click += new System.EventHandler(this.btn_cx_Click);
			// 
			// gpb_exam_mes
			// 
			this.gpb_exam_mes.Controls.Add(this.label2);
			this.gpb_exam_mes.Controls.Add(this.textBox2);
			this.gpb_exam_mes.Controls.Add(this.textBox1);
			this.gpb_exam_mes.Controls.Add(this.label1);
			this.gpb_exam_mes.Controls.Add(this.cbo_zyfx);
			this.gpb_exam_mes.Controls.Add(this.lbl_zyfx);
			this.gpb_exam_mes.Controls.Add(this.txt_zkzh);
			this.gpb_exam_mes.Controls.Add(this.dtp_ksrq);
			this.gpb_exam_mes.Controls.Add(this.cbo_kskm);
			this.gpb_exam_mes.Controls.Add(this.cbo_yxfx);
			this.gpb_exam_mes.Controls.Add(this.lbl_yxfx);
			this.gpb_exam_mes.Controls.Add(this.lbl_kskm);
			this.gpb_exam_mes.Controls.Add(this.lbl_ksdd);
			this.gpb_exam_mes.Controls.Add(this.lbl_ksrq);
			this.gpb_exam_mes.Controls.Add(this.lbl_zkzh);
			this.gpb_exam_mes.Controls.Add(this.cbo_ksdd);
			this.gpb_exam_mes.Location = new System.Drawing.Point(472, 40);
			this.gpb_exam_mes.Name = "gpb_exam_mes";
			this.gpb_exam_mes.Size = new System.Drawing.Size(304, 304);
			this.gpb_exam_mes.TabIndex = 19;
			this.gpb_exam_mes.TabStop = false;
			this.gpb_exam_mes.Text = "考试信息";
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(176, 232);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(16, 16);
			this.label2.TabIndex = 11;
			this.label2.Text = "至";
			// 
			// textBox2
			// 
			this.textBox2.Location = new System.Drawing.Point(200, 224);
			this.textBox2.Name = "textBox2";
			this.textBox2.Size = new System.Drawing.Size(88, 21);
			this.textBox2.TabIndex = 10;
			this.textBox2.Text = "";
			// 
			// textBox1
			// 
			this.textBox1.Location = new System.Drawing.Point(80, 224);
			this.textBox1.Name = "textBox1";