studentinfo.cs

数据库的课程设计作业。管理有关学生、课程的基本信息

			this.Controls.Add(this.lable4);
			this.Controls.Add(this.cmb2);
			this.Controls.Add(this.cmb1);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.dataGrid1);
			this.Name = "StudentInfo";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "学生信息维护";
			this.Load += new System.EventHandler(this.StudentInfo_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.groupBox1.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		
		private void btsearch_Click(object sender, System.EventArgs e)
		{
			da1.SelectCommand.Parameters[0].Value="%%";
			da1.SelectCommand.Parameters[1].Value="%%";
			if(txt1.Text.Trim()!="")
			{
				da1.SelectCommand.Parameters[0].Value="%"+txt1.Text.Trim()+"%";
			}
			if(txt2.Text!="")
			{
				da1.SelectCommand.Parameters[1].Value="%"+txt2.Text+"%";
			}
			dataSet11.学生表.Clear();//刷新数据集
			da1.Fill(dataSet11);
		}

		private void txt1_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txt2_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txt3_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txt5_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void cmb1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txt6_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txt7_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txt8_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void cmb2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void toolBar1_ButtonClick_1(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if (e.Button.ToolTipText == "首记录")
			{
				this.dataGrid1.UnSelect(cmOrders.Position); //取消原选中的行
				cmOrders.Position = 0;
				this.dataGrid1.Select(cmOrders.Position); //选中当前行
				this.dataGrid1.CurrentRowIndex = cmOrders.Position; //移动表头指示图标
				return;
				
			}
			if (e.Button.ToolTipText == "上一记录")
			{
				if (cmOrders.Position >= 0)
				{
					this.dataGrid1.UnSelect(cmOrders.Position); 
					cmOrders.Position--;
					this.dataGrid1.Select(cmOrders.Position);      
					this.dataGrid1.CurrentRowIndex = cmOrders.Position; 
				}
				return;
			}
			if (e.Button.ToolTipText == "下一记录")
			{
				if (cmOrders.Position <= cmOrders.Count-1)
				{
					this.dataGrid1.UnSelect(cmOrders.Position); 
					cmOrders.Position++;
					this.dataGrid1.Select(cmOrders.Position);       
					this.dataGrid1.CurrentRowIndex = cmOrders.Position; 
				}
				return;
			}
			if (e.Button.ToolTipText == "尾记录")
			{
				this.dataGrid1.UnSelect(cmOrders.Position); 
				cmOrders.Position = cmOrders.Count-1;
				this.dataGrid1.Select(cmOrders.Position);       
				this.dataGrid1.CurrentRowIndex = cmOrders.Position; 
				return;
			}
			if (e.Button.ToolTipText=="添加")
			{
				cmOrders.AddNew();
				SetModifyMode(true);
			}
			if (e.Button.ToolTipText=="修改")
			{
				SetModifyMode(true);
			}
			if (e.Button.ToolTipText=="删除")
			{
				DialogResult result=MessageBox.Show("确认删除？","删除数据",MessageBoxButtons.OKCancel);
				if (result==DialogResult.OK)
					if(cmOrders.Count>0)
					{
						cmOrders.RemoveAt(cmOrders.Position);
						da1.Update(dataSet11.学生表);
					}
					else
						MessageBox.Show("表中为空，已无可删除信息","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
			}
			if (e.Button.ToolTipText=="提交")
			{
				if(txt4.Text.Trim()=="")
				{
					MessageBox.Show("请输入学号","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
					return;
				}
				if(txt5.Text.Trim()=="")
				{
					MessageBox.Show("请输入姓名","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
					return;
				}
				cmOrders.EndCurrentEdit();
				if(dataSet11.GetChanges()!=null)
				{
					try
					{
						da1.Update(dataSet11.学生表);
						SetModifyMode(false);
					}
					catch(Exception express)
					{
						MessageBox.Show(express.ToString(),"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
						dataSet11.RejectChanges();
					}
				}
				return;
			}
			if (e.Button.ToolTipText=="取消")
			{
				try
				{
					cmOrders.CancelCurrentEdit();
					SetModifyMode(false);
				}
				catch(Exception express)
				{
					MessageBox.Show(express.ToString(),"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
				}
				return;
			}
			if (e.Button.ToolTipText=="退出")
				this.Close();
		}
		private void SetModifyMode(bool blnEdit)
		{
			txt4.ReadOnly=!blnEdit;
			txt5.ReadOnly=!blnEdit;
			cmb1.Enabled=blnEdit;
			cmb2.Enabled=blnEdit;
			cmb3.Enabled=blnEdit;
            cmb4.Enabled=blnEdit;
			cmb5.Enabled=blnEdit;
			btnSearch.Enabled=!blnEdit;
			dateTimePicker1.Enabled=blnEdit;
		}

		private void da1_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
		{
		
		}

		private void dataGrid1_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
		{
		
		}
		
					

				

	}
}