dzcx.cs

这是本人学习语言来第一次写的程序

			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_姓名", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_性别", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "性别", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_手机", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "手机", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_手机1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "手机", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电子邮箱", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电子邮箱", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_电子邮箱1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电子邮箱", System.Data.DataRowVersion.Original, null));
			// 
			// dzcx
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(968, 358);
			this.Controls.Add(this.tabControl1);
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
			this.Name = "dzcx";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "读者查询";
			this.Activated += new System.EventHandler(this.dzcx_Activated);
			this.tabControl1.ResumeLayout(false);
			this.tabPage1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
			this.tabPage2.ResumeLayout(false);
			this.groupBox4.ResumeLayout(false);
			this.groupBox3.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
			this.tabPage3.ResumeLayout(false);
			this.groupBox6.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid3)).EndInit();
			this.groupBox5.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		private void button1_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.dataSet21.Clear();
				System.Data.OleDb.OleDbCommand MySelect = this.oleDbConnection1.CreateCommand();
				MySelect.CommandText = "SELECT * FROM dzxxb";
				this.oleDbDataAdapter1.SelectCommand = MySelect;
				this.oleDbConnection1.Open();
				this.oleDbDataAdapter1.Fill(this.dataSet21,"dzxxb");
				this.oleDbConnection1.Close();
			}
			catch(Exception Exc)
			{
				MessageBox.Show(Exc.Message);
				this.oleDbConnection1.Close();
			}
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.oleDbConnection1.Open();
				this.oleDbDataAdapter1.Fill(this.dataSet21,"dzxxb");
				this.oleDbConnection1.Close();
			}
			catch(Exception Exc)
			{
				MessageBox.Show(Exc.Message);
				this.oleDbConnection1.Close();
			}
		}

		private void button3_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void button5_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void button4_Click(object sender, System.EventArgs e)
		{
			try
			{

				System.Data.OleDb.OleDbCommand MySelect = this.oleDbConnection1.CreateCommand();
				MySelect.CommandText = "SELECT * FROM dzxxb WHERE 编号='"+this.textBox1.Text+"'";
				this.oleDbDataAdapter1.SelectCommand = MySelect;
				this.dataSet21.Clear();
				this.oleDbConnection1.Open();
				this.oleDbDataAdapter1.Fill(this.dataSet21,"dzxxb");
				this.oleDbConnection1.Close();
			}
			catch(Exception Exc)
			{
				MessageBox.Show(Exc.Message);
				this.oleDbConnection1.Close();
			}
		}

		private void button5_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
		{
			switch((int)e.KeyCode)
			{
				case 13:
					button4_Click(null,null);
					break;
				case 27:
					this.Close();
					break;
				case 38:
				case 37:
					if(this.button5.Focused)
					{
						this.button4.Focus();
					}
					else
					{
						if(this.button4.Focused)
						{
							this.textBox1.Focus();
						}
						else
						{
							if(this.textBox1.Focused)
							{
								this.button5.Focus();
							}
						}
					}
					break;
				case 40:
				case 39:
					if(this.textBox1.Focused)
					{
						this.button4.Focus();
					}
					else
					{
						if(this.button4.Focused)
						{
							this.button5.Focus();
						}
						else
						{
							if(this.button5.Focused)
							{
								this.textBox1.Focus();
							}
						}
					}
					break;
			}
		}

		private void button7_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void button6_Click(object sender, System.EventArgs e)
		{			
			try
			{
				System.Data.OleDb.OleDbCommand MySelect = this.oleDbConnection1.CreateCommand();
				MySelect.CommandText = "SELECT * FROM dzxxb WHERE 姓名='"+this.textBox2.Text+"'";
				this.oleDbDataAdapter1.SelectCommand = MySelect;
				this.dataSet21.Clear();
				this.oleDbConnection1.Open();
				this.oleDbDataAdapter1.Fill(this.dataSet21,"dzxxb");
				this.oleDbConnection1.Close();
			}
			catch(Exception Exc)
			{
				MessageBox.Show(Exc.Message);
				this.oleDbConnection1.Close();
			}
		}

		private void textBox2_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
		{
			switch((int)e.KeyCode)
			{
				case 13:
					button6_Click(null,null);
					break;
				case 27:
					this.Close();
					break;
				case 38:
				case 37:
					if(this.button7.Focused)
					{
						this.button6.Focus();
					}
					else
					{
						if(this.button6.Focused)
						{
							this.textBox2.Focus();
						}
						else
						{
							if(this.textBox2.Focused)
							{
								this.button7.Focus();
							}
						}
					}
					break;
				case 40:
				case 39:
					if(this.textBox2.Focused)
					{
						this.button6.Focus();
					}
					else
					{
						if(this.button6.Focused)
						{
							this.button7.Focus();
						}
						else
						{
							if(this.button7.Focused)
							{
								this.textBox2.Focus();
							}
						}
					}
					break;
			}
		}

		private void dzcx_Activated(object sender, System.EventArgs e)
		{
			this.button1.Focus();
		}
	}
}