frmmanager.cs

毕业生管理系统:分为六个模块：身份验证模块、毕业生资料模块,考试成绩录入模块、通信录及数据输出与系统设置模块、毕业生成绩统计模块、数据库维护模块。

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.IO;

namespace 毕业生信息管理系统
{
	/// <summary>
	/// frmManager 的摘要说明。
	/// </summary>
	public class frmManager : System.Windows.Forms.Form
	{
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Button btnXianShi;
		private System.Windows.Forms.Button btnFile;
		private System.Windows.Forms.Button btnDelete;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.TabControl tabControl1;
		private System.Windows.Forms.TabPage tabPage1;
		private System.Windows.Forms.TabPage tabPage2;
		private System.Windows.Forms.GroupBox groupBox3;
		private System.Windows.Forms.Button btnDataOut;
		private System.Windows.Forms.Button btnPrintPreview;
		private System.Windows.Forms.Button btnPrint;
		private System.Windows.Forms.Button btnExit;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox txtStuNum;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.TextBox txtName;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.ComboBox cboMinZu;
		private System.Windows.Forms.Button button8;
		private System.Windows.Forms.PictureBox pictureBox1;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.DateTimePicker txtbirthday;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.TextBox txtAge;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.ComboBox cboWenHua;
		private System.Windows.Forms.Button button9;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.TextBox txtShenNumber;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.TextBox txtGuanJi;
		private System.Windows.Forms.ComboBox cboHunyin;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.ComboBox cboSex;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.ComboBox cboZhengZhi;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Button btnChoose;
		private System.Windows.Forms.Button btnClear;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.ComboBox cboRuXue;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.ComboBox cboZhuanYe;
		private System.Windows.Forms.Button button12;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.TextBox txtZhuanChang;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.TextBox txtQuXiang;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.TextBox txtYaoQiu;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.TextBox txtPhoto;
		private System.Windows.Forms.Label label18;
		private System.Windows.Forms.TextBox txtEmail;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.TextBox txtYouZheng;
		private System.Windows.Forms.Label label20;
		private System.Windows.Forms.TextBox txtBiYeTime;
		private System.Windows.Forms.Label label21;
		private System.Windows.Forms.DateTimePicker txtBiYedateTime;
		private System.Windows.Forms.Label label22;
		private System.Windows.Forms.TextBox txtAddress;
		private System.Windows.Forms.Button btnSave;
		private System.Windows.Forms.Button btnReset;
		private System.Windows.Forms.Label label23;
		private System.Windows.Forms.TextBox txtJianLi;
		private System.Windows.Forms.Button button1;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		private OleDbDataAdapter objSqlDataAdapter,objDataAdapter;
		private OleDbConnection objSqlConn;
		private DataSet objDataSet,objDataSet2;
		private System.Windows.Forms.DataGrid dbgBooksDt;
		private OleDbParameter objParam;
		private System.Windows.Forms.GroupBox groupBox4;
		private System.Windows.Forms.GroupBox groupBox5;
		private System.Windows.Forms.Label label24;
		private System.Windows.Forms.ComboBox comboBox1;
		private System.Windows.Forms.Label label25;
		private System.Windows.Forms.ComboBox comboBox2;
		private System.Windows.Forms.TextBox txtSelectName;
		private System.Windows.Forms.Button btnSelect;
		private System.Windows.Forms.Label label26;
		private System.Windows.Forms.RadioButton rad2;
		private System.Windows.Forms.RadioButton rad1;
		private System.Windows.Forms.PageSetupDialog pageSetupDialog1;
		private System.Windows.Forms.PrintPreviewDialog printPreviewDialog1;
		private System.Drawing.Printing.PrintDocument printDocument1;
		private System.Windows.Forms.PrintPreviewDialog printPreviewDialog2;
		private OleDbCommand objSqlCommand;

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

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmManager));
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.btnDelete = new System.Windows.Forms.Button();
			this.btnFile = new System.Windows.Forms.Button();
			this.dbgBooksDt = new System.Windows.Forms.DataGrid();
			this.btnXianShi = new System.Windows.Forms.Button();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.tabControl1 = new System.Windows.Forms.TabControl();
			this.tabPage1 = new System.Windows.Forms.TabPage();
			this.label23 = new System.Windows.Forms.Label();
			this.btnReset = new System.Windows.Forms.Button();
			this.btnSave = new System.Windows.Forms.Button();
			this.txtAddress = new System.Windows.Forms.TextBox();
			this.label22 = new System.Windows.Forms.Label();
			this.txtBiYedateTime = new System.Windows.Forms.DateTimePicker();
			this.label21 = new System.Windows.Forms.Label();
			this.txtBiYeTime = new System.Windows.Forms.TextBox();
			this.label20 = new System.Windows.Forms.Label();
			this.txtYouZheng = new System.Windows.Forms.TextBox();
			this.label19 = new System.Windows.Forms.Label();
			this.txtEmail = new System.Windows.Forms.TextBox();
			this.label18 = new System.Windows.Forms.Label();
			this.txtPhoto = new System.Windows.Forms.TextBox();
			this.label17 = new System.Windows.Forms.Label();
			this.txtYaoQiu = new System.Windows.Forms.TextBox();
			this.label16 = new System.Windows.Forms.Label();
			this.txtQuXiang = new System.Windows.Forms.TextBox();
			this.label15 = new System.Windows.Forms.Label();
			this.txtZhuanChang = new System.Windows.Forms.TextBox();
			this.label14 = new System.Windows.Forms.Label();
			this.button12 = new System.Windows.Forms.Button();
			this.cboZhuanYe = new System.Windows.Forms.ComboBox();
			this.label13 = new System.Windows.Forms.Label();
			this.cboRuXue = new System.Windows.Forms.ComboBox();
			this.label12 = new System.Windows.Forms.Label();
			this.btnClear = new System.Windows.Forms.Button();
			this.btnChoose = new System.Windows.Forms.Button();
			this.label11 = new System.Windows.Forms.Label();
			this.cboZhengZhi = new System.Windows.Forms.ComboBox();
			this.label10 = new System.Windows.Forms.Label();
			this.cboSex = new System.Windows.Forms.ComboBox();
			this.label9 = new System.Windows.Forms.Label();
			this.cboHunyin = new System.Windows.Forms.ComboBox();
			this.txtGuanJi = new System.Windows.Forms.TextBox();
			this.label8 = new System.Windows.Forms.Label();
			this.txtShenNumber = new System.Windows.Forms.TextBox();
			this.label7 = new System.Windows.Forms.Label();
			this.button9 = new System.Windows.Forms.Button();
			this.cboWenHua = new System.Windows.Forms.ComboBox();
			this.label6 = new System.Windows.Forms.Label();
			this.txtAge = new System.Windows.Forms.TextBox();
			this.label5 = new System.Windows.Forms.Label();
			this.txtbirthday = new System.Windows.Forms.DateTimePicker();
			this.label4 = new System.Windows.Forms.Label();
			this.pictureBox1 = new System.Windows.Forms.PictureBox();
			this.button8 = new System.Windows.Forms.Button();
			this.cboMinZu = new System.Windows.Forms.ComboBox();
			this.label3 = new System.Windows.Forms.Label();
			this.txtName = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.txtStuNum = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			this.tabPage2 = new System.Windows.Forms.TabPage();
			this.button1 = new System.Windows.Forms.Button();
			this.txtJianLi = new System.Windows.Forms.TextBox();
			this.groupBox3 = new System.Windows.Forms.GroupBox();
			this.btnExit = new System.Windows.Forms.Button();
			this.btnPrint = new System.Windows.Forms.Button();
			this.btnPrintPreview = new System.Windows.Forms.Button();
			this.btnDataOut = new System.Windows.Forms.Button();
			this.groupBox4 = new System.Windows.Forms.GroupBox();
			this.comboBox2 = new System.Windows.Forms.ComboBox();
			this.label25 = new System.Windows.Forms.Label();
			this.comboBox1 = new System.Windows.Forms.ComboBox();
			this.label24 = new System.Windows.Forms.Label();
			this.groupBox5 = new System.Windows.Forms.GroupBox();
			this.label26 = new System.Windows.Forms.Label();
			this.btnSelect = new System.Windows.Forms.Button();
			this.txtSelectName = new System.Windows.Forms.TextBox();
			this.rad2 = new System.Windows.Forms.RadioButton();
			this.rad1 = new System.Windows.Forms.RadioButton();
			this.pageSetupDialog1 = new System.Windows.Forms.PageSetupDialog();
			this.printDocument1 = new System.Drawing.Printing.PrintDocument();
			this.printPreviewDialog1 = new System.Windows.Forms.PrintPreviewDialog();
			this.printPreviewDialog2 = new System.Windows.Forms.PrintPreviewDialog();
			this.groupBox1.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dbgBooksDt)).BeginInit();
			this.groupBox2.SuspendLayout();
			this.tabControl1.SuspendLayout();
			this.tabPage1.SuspendLayout();
			this.tabPage2.SuspendLayout();
			this.groupBox3.SuspendLayout();
			this.groupBox4.SuspendLayout();
			this.groupBox5.SuspendLayout();
			this.SuspendLayout();
			// 
			// groupBox1
			// 
			this.groupBox1.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(255)), ((System.Byte)(192)));
			this.groupBox1.Controls.Add(this.btnDelete);
			this.groupBox1.Controls.Add(this.btnFile);
			this.groupBox1.Controls.Add(this.dbgBooksDt);
			this.groupBox1.Controls.Add(this.btnXianShi);
			this.groupBox1.Location = new System.Drawing.Point(8, 56);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(184, 480);
			this.groupBox1.TabIndex = 0;
			this.groupBox1.TabStop = false;
			// 
			// btnDelete
			// 
			this.btnDelete.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnDelete.ForeColor = System.Drawing.Color.DeepPink;
			this.btnDelete.Location = new System.Drawing.Point(104, 448);
			this.btnDelete.Name = "btnDelete";
			this.btnDelete.Size = new System.Drawing.Size(72, 24);
			this.btnDelete.TabIndex = 3;
			this.btnDelete.Text = "删除";
			this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
			// 
			// btnFile
			// 
			this.btnFile.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnFile.ForeColor = System.Drawing.Color.DeepPink;
			this.btnFile.Location = new System.Drawing.Point(8, 448);
			this.btnFile.Name = "btnFile";
			this.btnFile.Size = new System.Drawing.Size(72, 24);
			this.btnFile.TabIndex = 2;
			this.btnFile.Text = "新建";
			this.btnFile.Click += new System.EventHandler(this.btnFile_Click);
			// 
			// dbgBooksDt
			// 
			this.dbgBooksDt.BackgroundColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(255)), ((System.Byte)(192)));
			this.dbgBooksDt.CaptionBackColor = System.Drawing.Color.Silver;
			this.dbgBooksDt.DataMember = "";
			this.dbgBooksDt.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dbgBooksDt.ImeMode = System.Windows.Forms.ImeMode.NoControl;
			this.dbgBooksDt.Location = new System.Drawing.Point(8, 48);
			this.dbgBooksDt.Name = "dbgBooksDt";
			this.dbgBooksDt.ReadOnly = true;
			this.dbgBooksDt.RowHeaderWidth = 20;
			this.dbgBooksDt.Size = new System.Drawing.Size(168, 384);