addusers.cs

这是用SQL数据库做的学生信息管理系统。简明

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

namespace 学生与成绩
{
	/// <summary>
	/// AddUsers 的摘要说明。
	/// </summary>
	public class AddUsers : System.Windows.Forms.Form
	{
		public static string Class;
		private string sendStrSQL="select * from 用户";
		private DataSet ds=new DataSet();
		private LinkDataBase link=new LinkDataBase();
		private string sendTableName="用户";
		private CurrencyManager cmOrders;
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.Button btnChange;
		private System.Windows.Forms.Button btnCancel;
		private System.Windows.Forms.Button btnSave;
		private System.Windows.Forms.Button btn;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public AddUsers()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

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

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.btnChange = new System.Windows.Forms.Button();
			this.btnCancel = new System.Windows.Forms.Button();
			this.btnSave = new System.Windows.Forms.Button();
			this.btn = new System.Windows.Forms.Button();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			this.SuspendLayout();
			// 
			// dataGrid1
			// 
			this.dataGrid1.DataMember = "";
			this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid1.Location = new System.Drawing.Point(16, 8);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(560, 304);
			this.dataGrid1.TabIndex = 0;
			this.dataGrid1.CurrentCellChanged += new System.EventHandler(this.dataGrid1_CurrentCellChanged);
			// 
			// btnChange
			// 
			this.btnChange.Location = new System.Drawing.Point(63, 328);
			this.btnChange.Name = "btnChange";
			this.btnChange.TabIndex = 1;
			this.btnChange.Text = "添加与修改";
			this.btnChange.Click += new System.EventHandler(this.btnChange_Click);
			// 
			// btnCancel
			// 
			this.btnCancel.Location = new System.Drawing.Point(193, 328);
			this.btnCancel.Name = "btnCancel";
			this.btnCancel.TabIndex = 2;
			this.btnCancel.Text = "删除";
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			// 
			// btnSave
			// 
			this.btnSave.Location = new System.Drawing.Point(323, 328);
			this.btnSave.Name = "btnSave";
			this.btnSave.TabIndex = 3;
			this.btnSave.Text = "保存";
			this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
			// 
			// btn
			// 
			this.btn.Location = new System.Drawing.Point(453, 328);
			this.btn.Name = "btn";
			this.btn.TabIndex = 4;
			this.btn.Text = "取消";
			this.btn.Click += new System.EventHandler(this.btn_Click);
			// 
			// AddUsers
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(592, 366);
			this.Controls.Add(this.btn);
			this.Controls.Add(this.btnSave);
			this.Controls.Add(this.btnCancel);
			this.Controls.Add(this.btnChange);
			this.Controls.Add(this.dataGrid1);
			this.Name = "AddUsers";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.Text = "添加用户";
			this.Load += new System.EventHandler(this.AddUsers_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void AddUsers_Load(object sender, System.EventArgs e)
		{
			this.ds=link.SelectDataBase(sendStrSQL,sendTableName);
			this.dataGrid1.DataSource=ds;
			this.dataGrid1.DataMember="用户";
			cmOrders=(CurrencyManager)BindingContext[ds,"用户"];
			this.dataGrid1.CaptionText="                                        添加用户";
		}

		private void btnChange_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show("请直接在表格的空行中输入要添加的数据,\n可以直接对表格的现有数据进行修改.","温馨提示");
		}

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			string User=ds.Tables[0].Rows[cmOrders.Position][0].ToString().Trim();
			MessageBox.Show("编号为"+User.Trim()+"的记录将被删除,\n可以单击取消按钮撤销此次操作.","温馨提示");
			ds.Tables[0].Rows[cmOrders.Position].Delete();//删除当前行
		}

		private void btnSave_Click(object sender, System.EventArgs e)
		{
			cmOrders.EndCurrentEdit();
			link.UpdateDataBase(ds,"用户");
		}

		private void btn_Click(object sender, System.EventArgs e)
		{
			ds.RejectChanges();//撤销此次操作
			MessageBox.Show("取消操作仅对单击了“保存”按钮之后又进行的操作有效.");
		
		}

		private void dataGrid1_CurrentCellChanged(object sender, System.EventArgs e)
		{
			if(this.dataGrid1.CurrentCell.ColumnNumber==4)//确保单击数据表格第四列列值时出现新窗体
			{
				SeleClass newFrm=new SeleClass();
				newFrm.ShowDialog();
				ds.Tables[0].Rows[cmOrders.Position][4]=Class;//对数据表格中选中行第四列进行赋值
			}
		}
	}
}