form1.cs

《学籍管理系统》 “c# WinForm 数据库操作的简单范例 （SQL Server 2000）”

			#region 事件
		
		private void menuItem8_Click(object sender, System.EventArgs e)
		{
			Application.Exit();
		}

		private void menuItem22_Click(object sender, System.EventArgs e)
		{
			View_All();
		}
		private void menuItem23_Click(object sender, System.EventArgs e)
		{
			i = 0;
			j = 0;
			show();
			View_OneByOne();
		}
		private void textBox1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
		{
			if(e.KeyCode == Keys.F1)//  "用来表示 完全匹配
			{
				sign = "=";
				menuItem30.Checked = true;
				menuItem31.Checked = false;
				menuItem35.Text = "当前查询状态：完全匹配";
			}
			if(e.KeyCode == Keys.F2)// "F2"  用来表示 相关信息 
			{
				sign = "LIKE";	
				menuItem31.Checked = true;
				menuItem30.Checked = false;
				menuItem35.Text = "当前查询状态：相关信息";
			}
			if(e.KeyCode == Keys.F3) // 用来切换查询方式  
			{
				if(e.KeyCode == Keys.F3)
				{
					if(!menuItem23.Checked)
					{
						i = 0;
						j = 0;
						show();
						View_OneByOne();
					}
					else
					{
						View_All();
					}
				}
			}			
			if(e.KeyCode == Keys.Enter) // 回车键 
			{
				LookUp();
			}			
		}
		
		private void button1_Click(object sender, System.EventArgs e)
		{
			LookUp();
		}
		private void button6_Click(object sender, System.EventArgs e)
		{
			if(i > 0)
			{
				i--;
				View_OneByOne();
			}
		}

		private void button7_Click(object sender, System.EventArgs e)
		{
			if(i < dataSet11.EssentialInfo.Count - 1)
			{
				i++;
				View_OneByOne();
			}
		}

		private void listBox1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			i = listBox1.SelectedIndex;
			View_OneByOne();
		}

		private void comboBox2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			switch(comboBox2.Text)
			{
				case "姓    名" : j = 0 ;    break;
				case "性    别" : j = 1 ;    break;
				case "学    号" : j = 2 ;    break;
				case "学    院" : j = 3 ;    break;
				case "专    业" : j = 4 ;    break;
				case "班    级" : j = 5 ;    break;
				case "电    话" : j = 6 ;    break;
				case "出生年月" : j = 7 ;    break;
				case "民    族" : j = 8 ;    break;
				case "籍    贯" : j = 9 ;    break;
				case "住    址" : j = 10 ;    break;
				case "来自何校" : j = 11 ;    break;
				case "政治面貌" : j = 12 ;    break;
				case "备    注" : j = 13 ;    break;
				default:MessageBox.Show("请选择条件 ！");return;
			}			
			show();
		}

		private void button8_Click(object sender, System.EventArgs e)
		{
			openFileDialog1.Title = "添加照片";
			openFileDialog1.Filter =  "Jpeg文件(*.jpg)|*.jpg|Bitmap文件(*.bmp)|*.bmp|所有文件(*.*)|*.*";			
			if (openFileDialog1.ShowDialog() == DialogResult.OK)
			{
				this.pictureBox1.Image = (Bitmap)Bitmap.FromFile(openFileDialog1.FileName, false );
				img_path = openFileDialog1.FileName;				
			}
		}

		private void button9_Click(object sender, System.EventArgs e)
		{
			pictureBox1.Image = null;
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			textBox2.Text = null; textBox3.Text = null;	textBox4.Text = null;
			textBox5.Text = null; textBox6.Text = null;	textBox7.Text = null; 
			textBox8.Text = null; textBox9.Text = null;	textBox10.Text = null;
			textBox11.Text = null; textBox12.Text = null;textBox13.Text = null;
			textBox14.Text = null; richTextBox1.Text = null;pictureBox1.Image = null;
			textBox15.Text = null;
		}

		private void button3_Click(object sender, System.EventArgs e)
		{
			Info_Add();
			operate = " 添  加 ";
			rigester();

		}
		private void button4_Click(object sender, System.EventArgs e)
		{
			delete_info();
			operate = " 删  除 ";
			rigester();
		}

		private void button5_Click(object sender, System.EventArgs e)
		{
			upData_Info();
			operate = " 修  改 ";
			rigester();
		}
		private void Form1_Closed(object sender, System.EventArgs e)
		{
			Application.Exit();
		}
		private void menuItem6_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form2 f2 = new Form2();
			f2.Show();
		}

		private void menuItem14_Click(object sender, System.EventArgs e)
		{
			Info_Add();
		}

		private void menuItem15_Click(object sender, System.EventArgs e)
		{
			delete_info();
		}

		private void menuItem16_Click(object sender, System.EventArgs e)
		{
			upData_Info();
		}

		private void menuItem30_Click(object sender, System.EventArgs e)
		{
			sign = "=";
			menuItem35.Text = "当前查询状态：完全匹配";
			menuItem30.Checked = true;
			menuItem31.Checked = false;
		}

		private void menuItem31_Click(object sender, System.EventArgs e)
		{
			sign = "LIKE";	
			menuItem35.Text = "当前查询状态：相关信息";
			menuItem31.Checked = true;
			menuItem30.Checked = false;
		}
			
		private void menuItem27_Click(object sender, System.EventArgs e)
		{
			show_OperateInfo();
		}
		private void menuItem4_Click(object sender, System.EventArgs e)
		{
			Form3 f3 = new Form3();
			f3.Show();
		}
		private void menuItem13_Click(object sender, System.EventArgs e)
		{
			Form5 f5 = new Form5();
			f5.Show();
		}

		private void menuItem5_Click(object sender, System.EventArgs e)
		{
			//配置服务器
			groupBox6.Visible = true;
		}
		private void button11_Click(object sender, System.EventArgs e)
		{
			groupBox6.Visible = false;
		}

		private void button10_Click(object sender, System.EventArgs e)
		{
			Server_Info();
			groupBox6.Visible = false;
		}
		private void textBox19_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
		{
			if(e.KeyCode == Keys.Enter)
			{
				Server_Info();
				groupBox6.Visible = false;
			}
		}
		private void Form1_Load(object sender, System.EventArgs e)
		{
			Read_SystemInfo();
		}
		private void menuItem12_Click(object sender, System.EventArgs e)
		{
			try
			{
				string s = Application.ExecutablePath;
				s = s.Replace("StudentManage.exe","Help.chm");
				Process.Start(s);
			}
			catch(Exception e1)
			{
				MessageBox.Show(e1.Message);
			}
		}
		#endregion

		#region 事件处理方法
		// 用 “DataGrid” 控键浏览全部信息
		private void View_All()
		{
			menuItem23.Checked  = false;
			menuItem22.Checked  = true;
			dataGrid1.Visible = true;
			groupBox1.Visible = false;
			dataSet11.Clear();
			try
			{
				sqlConnection1.Open();
				sqlDataAdapter1.Fill(dataSet11.EssentialInfo);
				dataGrid1.DataSource = dataSet11.EssentialInfo;	
			}
			catch(SqlException sqle)
			{
				MessageBox.Show(sqle.Message);
			}
			finally
			{
				sqlConnection1.Close();				
			}
		}

		
		//逐条信息查看
		private void View_OneByOne()
		{
			menuItem22.Checked  = false;
			menuItem23.Checked  = true;
			dataGrid1.Visible = false;
			groupBox1.Visible = true;			
			try
			{				
				textBox2.Text = dataSet11.Tables[0].Rows[i]["姓名"].ToString();
				textBox3.Text = dataSet11.Tables[0].Rows[i]["性别"].ToString();
				textBox4.Text = dataSet11.Tables[0].Rows[i]["学号"].ToString();
				textBox15.Text = dataSet11.Tables[0].Rows[i]["学号"].ToString();
				textBox5.Text = dataSet11.Tables[0].Rows[i]["学院"].ToString();
				textBox6.Text = dataSet11.Tables[0].Rows[i]["专业"].ToString();
				textBox7.Text = dataSet11.Tables[0].Rows[i]["班级"].ToString();
				textBox8.Text = dataSet11.Tables[0].Rows[i]["电话"].ToString();
				textBox9.Text = dataSet11.Tables[0].Rows[i]["出生年月"].ToString();
				textBox10.Text = dataSet11.Tables[0].Rows[i]["民族"].ToString();
				textBox11.Text = dataSet11.Tables[0].Rows[i]["籍贯"].ToString();
				textBox12.Text = dataSet11.Tables[0].Rows[i]["住址"].ToString();
				textBox13.Text = dataSet11.Tables[0].Rows[i]["来自何校"].ToString();
				textBox14.Text = dataSet11.Tables[0].Rows[i]["政治面貌"].ToString();				
				richTextBox1.Text = dataSet11.Tables[0].Rows[i]["备注"].ToString();

				
				if(dataSet11.Tables[0].Rows[i]["照片"].ToString().Length > 10)
				{
					Byte[] byteBLOBData =  new Byte[0];
					byteBLOBData = (Byte[])dataSet11.Tables[0].Rows[i]["照片"];
					MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);
					pictureBox1.Image = Image.FromStream(stmBLOBData);
				}
				else
				{
					pictureBox1.Image = null;
				}
			}
			catch(SqlException sql2)
			{
				MessageBox.Show(sql2.Message);
			}
			catch(Exception e2)
			{
				MessageBox.Show(e2.Message)