mainform.cs

基于SQL CE存储数据的学生信息管理系统

using System;
using System.Drawing;
using System.Collections;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlServerCe;
using System.IO;

namespace StudInfo
{
	/// <summary>
	/// Form1 的摘要说明。
	/// </summary>
	public class MainForm : System.Windows.Forms.Form
	{
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.MainMenu mainMenu1;
		private System.Windows.Forms.MenuItem menuItem1;
		private System.Windows.Forms.MenuItem menuItem2;
		private System.Windows.Forms.MenuItem menuItem3;
		private System.Windows.Forms.MenuItem menuItem4;
		private System.Windows.Forms.MenuItem menuItem5;
		private System.Windows.Forms.MenuItem menuItem6;
		private System.Windows.Forms.MenuItem menuItem7;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.Button button2;

		private SqlCeConnection conn;
		private SqlCeCommand cmd;
		private SqlCeEngine  sqlEngine;
		private System.Windows.Forms.Button button3;
		private System.Windows.Forms.Button button4;
		private System.Windows.Forms.Button button5;
		private System.Windows.Forms.Button button6;
		private System.Windows.Forms.Button button7;
		private System.Windows.Forms.StatusBar statusBar1;			
		private DataSet ds;
	
		public MainForm()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}
		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			base.Dispose( disposing );
		}
		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
            this.dataGrid1 = new System.Windows.Forms.DataGrid();
            this.mainMenu1 = new System.Windows.Forms.MainMenu();
            this.menuItem1 = new System.Windows.Forms.MenuItem();
            this.menuItem3 = new System.Windows.Forms.MenuItem();
            this.menuItem4 = new System.Windows.Forms.MenuItem();
            this.menuItem5 = new System.Windows.Forms.MenuItem();
            this.menuItem6 = new System.Windows.Forms.MenuItem();
            this.menuItem7 = new System.Windows.Forms.MenuItem();
            this.menuItem2 = new System.Windows.Forms.MenuItem();
            this.button1 = new System.Windows.Forms.Button();
            this.button2 = new System.Windows.Forms.Button();
            this.button3 = new System.Windows.Forms.Button();
            this.button4 = new System.Windows.Forms.Button();
            this.button5 = new System.Windows.Forms.Button();
            this.button6 = new System.Windows.Forms.Button();
            this.button7 = new System.Windows.Forms.Button();
            this.statusBar1 = new System.Windows.Forms.StatusBar();
            this.SuspendLayout();
            // 
            // dataGrid1
            // 
            this.dataGrid1.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(128)))));
            this.dataGrid1.Location = new System.Drawing.Point(8, 32);
            this.dataGrid1.Name = "dataGrid1";
            this.dataGrid1.Size = new System.Drawing.Size(248, 162);
            this.dataGrid1.TabIndex = 8;
            this.dataGrid1.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dataGrid1_MouseUp);
            // 
            // mainMenu1
            // 
            this.mainMenu1.MenuItems.Add(this.menuItem1);
            this.mainMenu1.MenuItems.Add(this.menuItem2);
            // 
            // menuItem1
            // 
            this.menuItem1.MenuItems.Add(this.menuItem3);
            this.menuItem1.MenuItems.Add(this.menuItem4);
            this.menuItem1.MenuItems.Add(this.menuItem5);
            this.menuItem1.MenuItems.Add(this.menuItem6);
            this.menuItem1.MenuItems.Add(this.menuItem7);
            this.menuItem1.Text = "文件";
            // 
            // menuItem3
            // 
            this.menuItem3.Text = "创建数据库";
            this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
            // 
            // menuItem4
            // 
            this.menuItem4.Text = "创建学生表";
            this.menuItem4.Click += new System.EventHandler(this.menuItem4_Click);
            // 
            // menuItem5
            // 
            this.menuItem5.Text = "连接数据库";
            this.menuItem5.Click += new System.EventHandler(this.menuItem5_Click);
            // 
            // menuItem6
            // 
            this.menuItem6.Text = "关闭数据库";
            this.menuItem6.Click += new System.EventHandler(this.menuItem6_Click);
            // 
            // menuItem7
            // 
            this.menuItem7.Text = "退出";
            this.menuItem7.Click += new System.EventHandler(this.menuItem7_Click);
            // 
            // menuItem2
            // 
            this.menuItem2.Text = "帮助";
            // 
            // button1
            // 
            this.button1.Location = new System.Drawing.Point(3, 200);
            this.button1.Name = "button1";
            this.button1.Size = new System.Drawing.Size(50, 24);
            this.button1.TabIndex = 7;
            this.button1.Text = "添加";
            this.button1.Click += new System.EventHandler(this.button1_Click);
            // 
            // button2
            // 
            this.button2.Location = new System.Drawing.Point(59, 200);
            this.button2.Name = "button2";
            this.button2.Size = new System.Drawing.Size(44, 24);
            this.button2.TabIndex = 6;
            this.button2.Text = "编辑";
            this.button2.Click += new System.EventHandler(this.button2_Click);
            // 
            // button3
            // 
            this.button3.Location = new System.Drawing.Point(109, 200);
            this.button3.Name = "button3";
            this.button3.Size = new System.Drawing.Size(46, 24);
            this.button3.TabIndex = 5;
            this.button3.Text = "删除";
            this.button3.Click += new System.EventHandler(this.button3_Click);
            // 
            // button4
            // 
            this.button4.Location = new System.Drawing.Point(161, 200);
            this.button4.Name = "button4";
            this.button4.Size = new System.Drawing.Size(88, 24);
            this.button4.TabIndex = 4;
            this.button4.Text = "查询";
            this.button4.Click += new System.EventHandler(this.button4_Click);
            // 
            // button5
            // 
            this.button5.Location = new System.Drawing.Point(3, 230);
            this.button5.Name = "button5";
            this.button5.Size = new System.Drawing.Size(78, 22);
            this.button5.TabIndex = 3;
            this.button5.Text = "显示全部";
            this.button5.Click += new System.EventHandler(this.button5_Click);
            // 
            // button6
            // 
            this.button6.Location = new System.Drawing.Point(87, 231);
            this.button6.Name = "button6";
            this.button6.Size = new System.Drawing.Size(69, 21);
            this.button6.TabIndex = 2;
            this.button6.Text = "年龄排序";
            this.button6.Click += new System.EventHandler(this.button6_Click);
            // 
            // button7
            // 
            this.button7.Location = new System.Drawing.Point(162, 231);
            this.button7.Name = "button7";
            this.button7.Size = new System.Drawing.Size(72, 22);
            this.button7.TabIndex = 1;
            this.button7.Text = "年龄统计";
            this.button7.Click += new System.EventHandler(this.button7_Click);
            // 
            // statusBar1
            // 
            this.statusBar1.Location = new System.Drawing.Point(0, 261);
            this.statusBar1.Name = "statusBar1";
            this.statusBar1.Size = new System.Drawing.Size(262, 24);
            this.statusBar1.Text = "statusBar1";
            // 
            // MainForm
            // 
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Inherit;
            this.ClientSize = new System.Drawing.Size(262, 285);
            this.Controls.Add(this.statusBar1);
            this.Controls.Add(this.button7);
            this.Controls.Add(this.button6);
            this.Controls.Add(this.button5);
            this.Controls.Add(this.button4);
            this.Controls.Add(this.button3);
            this.Controls.Add(this.button2);
            this.Controls.Add(this.button1);
            this.Controls.Add(this.dataGrid1);
            this.MaximizeBox = false;
            this.Menu = this.mainMenu1;
            this.MinimizeBox = false;
            this.Name = "MainForm";
            this.Text = "学生信息管理";
            this.Load += new System.EventHandler(this.MainForm_Load_1);
            this.ResumeLayout(false);

		}
		#endregion

		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>

		static void Main() 
		{
			Application.Run(new MainForm());
		}

		private void menuItem5_Click(object sender, System.EventArgs e)
		{
			
			
			SqlCeConnection conn=null;     
			
			try
			{
				conn = new SqlCeConnection ("Data Source=\\My Documents\\studinfo.sdf;password=");
				conn.Open();
				SqlCeCommand cmd=conn.CreateCommand();
				cmd.CommandText="student";
				cmd.CommandType=CommandType.TableDirect;
				SqlCeDataAdapter da=new SqlCeDataAdapter(cmd);
				DataSet ds=new  DataSet ();
				da.Fill(ds);			
				

				DataGridTableStyle TSAuthors = new DataGridTableStyle();
				TSAuthors.MappingName = ds.Tables[0].ToString();
				
				// Add a GridColumnStyle and set the MappingName 
				// to the name of a DataColumn in the DataTable. 
				// Set the HeaderText and Width properties. 
				DataGridColumnStyle TCFirstName = new DataGridTextBoxColumn();
				TCFirstName.MappingName = "sid";
				TCFirstName.HeaderText = "手机号";				
				TCFirstName.Width = 75;
				TSAuthors.GridColumnStyles.Add(TCFirstName);
				//
				DataGridColumnStyle TName = new DataGridTextBoxColumn();				
				TName.MappingName="sname";
				TName.HeaderText="电子邮件地址";
				TName.Width = 75;
				TSAuthors.GridColumnStyles.Add(TName);

				DataGridColumnStyle Tsex = new DataGridTextBoxColumn();				
				Tsex.MappingName="ssex";
				Tsex.HeaderText="美中";
				Tsex.Width = 75;
				TSAuthors.GridColumnStyles.Add(Tsex);

				DataGridColumnStyle Tage = new DataGridTextBoxColumn();				
				Tage.MappingName="sage";
				Tage.HeaderText="价格";
				Tage.Width = 75;
				TSAuthors.GridColumnStyles.Add(Tage);

				DataGridColumnStyle Tdept = new DataGridTextBoxColumn();				
				Tdept.MappingName="sdept";
				Tdept.HeaderText="系部";
				Tdept.Width = 75;
				TSAuthors.GridColumnStyles.Add(Tdept);
								
				// Add the DataGridTableStyle instance to 
				// the GridTableStylesCollection. 
				dataGrid1.TableStyles.Add(TSAuthors);
				dataGrid1.DataSource=ds.Tables[0];
				

			}
			catch
			{
				
				MessageBox.Show("连接数据库失败！","连接错误",MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
			}
			finally
			{   
				
				conn.Close();
			}
		}

		private void menuItem3_Click(object sender, System.EventArgs e)
		{
			sqlEngine=null;
			try
			{
				if (File.Exists("\\My Documents\\studinfo.sdf"))  
				{
					File.Exists("\\My Documents\\studinfo.sdf");
				}