form_xycx.cs

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

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

namespace bizdb
{
	/// <summary>
	/// Form3 的摘要说明。
	/// </summary>
	public class Form_xycx : System.Windows.Forms.Form
	{
		private System.Windows.Forms.GroupBox gpb_zhcx;
		private System.Windows.Forms.GroupBox gpb_tbcx;
		private System.Windows.Forms.DataGrid dgd_xycx;
		private System.Windows.Forms.GroupBox gpb_cxfs;
		private System.Windows.Forms.RadioButton rdb_zhcx;
		private System.Windows.Forms.RadioButton rdb_tbcx;
		private System.Windows.Forms.CheckBox ckb_xm;
		private System.Windows.Forms.CheckBox ckb_xb;
		private System.Windows.Forms.CheckBox ckb_mz;
		private System.Windows.Forms.CheckBox ckb_bj;
		private System.Windows.Forms.TextBox txt_xm;
		private System.Windows.Forms.Label lbl_bmrq;
		private System.Windows.Forms.Label blb_z;
		private System.Windows.Forms.DateTimePicker ddtp_bmrq1;
		private System.Windows.Forms.DateTimePicker ddtp_bmrq2;
		private System.Windows.Forms.Button but_find;
		private System.Windows.Forms.ComboBox cbb_xb;
		private System.Windows.Forms.ComboBox cbb_bj;
		private System.Windows.Forms.ComboBox cbb_mz;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public Form_xycx()
		{
			//
			// 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.gpb_zhcx = new System.Windows.Forms.GroupBox();
			this.cbb_mz = new System.Windows.Forms.ComboBox();
			this.cbb_bj = new System.Windows.Forms.ComboBox();
			this.cbb_xb = new System.Windows.Forms.ComboBox();
			this.txt_xm = new System.Windows.Forms.TextBox();
			this.ckb_bj = new System.Windows.Forms.CheckBox();
			this.ckb_mz = new System.Windows.Forms.CheckBox();
			this.ckb_xb = new System.Windows.Forms.CheckBox();
			this.ckb_xm = new System.Windows.Forms.CheckBox();
			this.gpb_tbcx = new System.Windows.Forms.GroupBox();
			this.ddtp_bmrq2 = new System.Windows.Forms.DateTimePicker();
			this.ddtp_bmrq1 = new System.Windows.Forms.DateTimePicker();
			this.blb_z = new System.Windows.Forms.Label();
			this.lbl_bmrq = new System.Windows.Forms.Label();
			this.dgd_xycx = new System.Windows.Forms.DataGrid();
			this.gpb_cxfs = new System.Windows.Forms.GroupBox();
			this.but_find = new System.Windows.Forms.Button();
			this.rdb_tbcx = new System.Windows.Forms.RadioButton();
			this.rdb_zhcx = new System.Windows.Forms.RadioButton();
			this.gpb_zhcx.SuspendLayout();
			this.gpb_tbcx.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dgd_xycx)).BeginInit();
			this.gpb_cxfs.SuspendLayout();
			this.SuspendLayout();
			// 
			// gpb_zhcx
			// 
			this.gpb_zhcx.Controls.AddRange(new System.Windows.Forms.Control[] {
																				   this.cbb_mz,
																				   this.cbb_bj,
																				   this.cbb_xb,
																				   this.txt_xm,
																				   this.ckb_bj,
																				   this.ckb_mz,
																				   this.ckb_xb,
																				   this.ckb_xm});
			this.gpb_zhcx.Enabled = false;
			this.gpb_zhcx.Location = new System.Drawing.Point(224, 32);
			this.gpb_zhcx.Name = "gpb_zhcx";
			this.gpb_zhcx.Size = new System.Drawing.Size(208, 160);
			this.gpb_zhcx.TabIndex = 3;
			this.gpb_zhcx.TabStop = false;
			this.gpb_zhcx.Text = "综合查询";
			// 
			// cbb_mz
			// 
			this.cbb_mz.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.cbb_mz.Location = new System.Drawing.Point(72, 128);
			this.cbb_mz.Name = "cbb_mz";
			this.cbb_mz.Size = new System.Drawing.Size(121, 20);
			this.cbb_mz.TabIndex = 7;
			// 
			// cbb_bj
			// 
			this.cbb_bj.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.cbb_bj.Location = new System.Drawing.Point(72, 96);
			this.cbb_bj.Name = "cbb_bj";
			this.cbb_bj.Size = new System.Drawing.Size(121, 20);
			this.cbb_bj.TabIndex = 6;
			// 
			// cbb_xb
			// 
			this.cbb_xb.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.cbb_xb.Location = new System.Drawing.Point(72, 64);
			this.cbb_xb.Name = "cbb_xb";
			this.cbb_xb.Size = new System.Drawing.Size(121, 20);
			this.cbb_xb.TabIndex = 5;
			// 
			// txt_xm
			// 
			this.txt_xm.Location = new System.Drawing.Point(72, 32);
			this.txt_xm.Name = "txt_xm";
			this.txt_xm.Size = new System.Drawing.Size(120, 21);
			this.txt_xm.TabIndex = 4;
			this.txt_xm.Text = "";
			// 
			// ckb_bj
			// 
			this.ckb_bj.Location = new System.Drawing.Point(16, 96);
			this.ckb_bj.Name = "ckb_bj";
			this.ckb_bj.Size = new System.Drawing.Size(48, 24);
			this.ckb_bj.TabIndex = 3;
			this.ckb_bj.Text = "班级";
			this.ckb_bj.CheckedChanged += new System.EventHandler(this.ckb_bj_CheckedChanged);
			// 
			// ckb_mz
			// 
			this.ckb_mz.Location = new System.Drawing.Point(16, 128);
			this.ckb_mz.Name = "ckb_mz";
			this.ckb_mz.Size = new System.Drawing.Size(48, 24);
			this.ckb_mz.TabIndex = 2;
			this.ckb_mz.Text = "民族";
			this.ckb_mz.CheckedChanged += new System.EventHandler(this.ckb_mz_CheckedChanged);
			// 
			// ckb_xb
			// 
			this.ckb_xb.Location = new System.Drawing.Point(16, 64);
			this.ckb_xb.Name = "ckb_xb";
			this.ckb_xb.Size = new System.Drawing.Size(48, 24);
			this.ckb_xb.TabIndex = 1;
			this.ckb_xb.Text = "性别";
			this.ckb_xb.CheckedChanged += new System.EventHandler(this.ckb_xb_CheckedChanged);
			// 
			// ckb_xm
			// 
			this.ckb_xm.Location = new System.Drawing.Point(16, 32);
			this.ckb_xm.Name = "ckb_xm";
			this.ckb_xm.Size = new System.Drawing.Size(48, 24);
			this.ckb_xm.TabIndex = 0;
			this.ckb_xm.Text = "姓名";
			this.ckb_xm.CheckedChanged += new System.EventHandler(this.ckb_xm_CheckedChanged);
			// 
			// gpb_tbcx
			// 
			this.gpb_tbcx.Controls.AddRange(new System.Windows.Forms.Control[] {
																				   this.ddtp_bmrq2,
																				   this.ddtp_bmrq1,
																				   this.blb_z,
																				   this.lbl_bmrq});
			this.gpb_tbcx.Enabled = false;
			this.gpb_tbcx.Location = new System.Drawing.Point(464, 32);
			this.gpb_tbcx.Name = "gpb_tbcx";
			this.gpb_tbcx.Size = new System.Drawing.Size(296, 160);
			this.gpb_tbcx.TabIndex = 4;
			this.gpb_tbcx.TabStop = false;
			this.gpb_tbcx.Text = "特别查询";
			// 
			// ddtp_bmrq2
			// 
			this.ddtp_bmrq2.Location = new System.Drawing.Point(104, 96);
			this.ddtp_bmrq2.Name = "ddtp_bmrq2";
			this.ddtp_bmrq2.Size = new System.Drawing.Size(144, 21);
			this.ddtp_bmrq2.TabIndex = 3;
			// 
			// ddtp_bmrq1
			// 
			this.ddtp_bmrq1.Location = new System.Drawing.Point(104, 32);
			this.ddtp_bmrq1.Name = "ddtp_bmrq1";
			this.ddtp_bmrq1.Size = new System.Drawing.Size(144, 21);
			this.ddtp_bmrq1.TabIndex = 2;
			// 
			// blb_z
			// 
			this.blb_z.Location = new System.Drawing.Point(16, 104);
			this.blb_z.Name = "blb_z";
			this.blb_z.Size = new System.Drawing.Size(24, 16);
			this.blb_z.TabIndex = 1;
			this.blb_z.Text = "至";
			// 
			// lbl_bmrq
			// 
			this.lbl_bmrq.Location = new System.Drawing.Point(16, 32);
			this.lbl_bmrq.Name = "lbl_bmrq";
			this.lbl_bmrq.Size = new System.Drawing.Size(56, 16);
			this.lbl_bmrq.TabIndex = 0;
			this.lbl_bmrq.Text = "报名日期";
			// 
			// dgd_xycx
			// 
			this.dgd_xycx.DataMember = "";
			this.dgd_xycx.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.dgd_xycx.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dgd_xycx.Location = new System.Drawing.Point(0, 221);
			this.dgd_xycx.Name = "dgd_xycx";
			this.dgd_xycx.ReadOnly = true;
			this.dgd_xycx.Size = new System.Drawing.Size(792, 352);
			this.dgd_xycx.TabIndex = 5;
			this.dgd_xycx.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dgd_xycx_MouseUp);
			// 
			// gpb_cxfs
			// 
			this.gpb_cxfs.Controls.AddRange(new System.Windows.Forms.Control[] {
																				   this.but_find,
																				   this.rdb_tbcx,
																				   this.rdb_zhcx});
			this.gpb_cxfs.Location = new System.Drawing.Point(32, 32);
			this.gpb_cxfs.Name = "gpb_cxfs";
			this.gpb_cxfs.Size = new System.Drawing.Size(160, 160);
			this.gpb_cxfs.TabIndex = 6;
			this.gpb_cxfs.TabStop = false;
			this.gpb_cxfs.Text = "查询方式";
			// 
			// but_find
			// 
			this.but_find.Location = new System.Drawing.Point(32, 120);
			this.but_find.Name = "but_find";
			this.but_find.Size = new System.Drawing.Size(96, 23);
			this.but_find.TabIndex = 2;
			this.but_find.Text = "查  询";
			this.but_find.Click += new System.EventHandler(this.but_find_Click);
			// 
			// rdb_tbcx
			// 
			this.rdb_tbcx.Location = new System.Drawing.Point(24, 72);
			this.rdb_tbcx.Name = "rdb_tbcx";