f94计2.cs

vb 图书馆管理系统。

			this.menuItem19.Index = 1;
			this.menuItem19.Text = "学生表";
			this.menuItem19.Click += new System.EventHandler(this.menuItem19_Click);
			// 
			// menuItem20
			// 
			this.menuItem20.Index = 2;
			this.menuItem20.Text = "课程表";
			this.menuItem20.Click += new System.EventHandler(this.menuItem20_Click);
			// 
			// menuItem21
			// 
			this.menuItem21.Index = 3;
			this.menuItem21.Text = "综合表";
			this.menuItem21.Click += new System.EventHandler(this.menuItem21_Click);
			// 
			// menuItem22
			// 
			this.menuItem22.Index = 5;
			this.menuItem22.Text = "帮助";
			this.menuItem22.Click += new System.EventHandler(this.menuItem22_Click);
			// 
			// menuItem23
			// 
			this.menuItem23.Index = 6;
			this.menuItem23.Text = "版本信息";
			this.menuItem23.Click += new System.EventHandler(this.menuItem23_Click);
			// 
			// menuItem24
			// 
			this.menuItem24.Index = 7;
			this.menuItem24.Text = "退出";
			this.menuItem24.Click += new System.EventHandler(this.menuItem24_Click);
			// 
			// textBox1
			// 
			this.textBox1.Location = new System.Drawing.Point(240, 56);
			this.textBox1.Name = "textBox1";
			this.textBox1.Size = new System.Drawing.Size(104, 21);
			this.textBox1.TabIndex = 0;
			this.textBox1.Text = "";
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(608, 64);
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(104, 32);
			this.button1.TabIndex = 1;
			this.button1.Text = "计算";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// dataGrid1
			// 
			this.dataGrid1.DataMember = "";
			this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid1.Location = new System.Drawing.Point(16, 120);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(712, 176);
			this.dataGrid1.TabIndex = 2;
			// 
			// dataGrid2
			// 
			this.dataGrid2.DataMember = "";
			this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid2.Location = new System.Drawing.Point(16, 296);
			this.dataGrid2.Name = "dataGrid2";
			this.dataGrid2.Size = new System.Drawing.Size(712, 120);
			this.dataGrid2.TabIndex = 3;
			// 
			// label1
			// 
			this.label1.BackColor = System.Drawing.SystemColors.Control;
			this.label1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label1.Location = new System.Drawing.Point(96, 56);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(144, 24);
			this.label1.TabIndex = 4;
			this.label1.Text = "请输入学生学号：";
			// 
			// Form13
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(742, 473);
			this.Controls.AddRange(new System.Windows.Forms.Control[] {
																		  this.label1,
																		  this.dataGrid2,
																		  this.dataGrid1,
																		  this.button1,
																		  this.textBox1});
			this.MaximizeBox = false;
			this.Menu = this.mainMenu1;
			this.Name = "Form13";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.Text = "计算各类成绩";
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

	

		private void menuItem24_Click(object sender, System.EventArgs e)
		{
			Application.Exit();
		}

		private void menuItem23_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show("               数据库课程设计\r                        -------教学管理系统\r\r小组成员：金铎，汪欣，齐肖西，李莎，王丽芳");
		}

		private void menuItem22_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show("暂无帮助信息！");
		}

		private void menuItem2_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form2=new Form2();
			form2.ShowDialog ();
		}

		private void menuItem3_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form3=new Form3();
			form3.ShowDialog ();
		}

		private void menuItem4_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form4=new Form4();
			form4.ShowDialog ();
		}

		private void menuItem6_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form5=new Form5();
			form5.ShowDialog ();
		}

		private void menuItem7_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form6=new Form6();
			form6.ShowDialog ();
		}

		private void menuItem8_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form7=new Form7();
			form7.ShowDialog ();
		}

		private void menuItem10_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form8=new Form8();
			form8.ShowDialog ();
		}

		private void menuItem11_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form9=new Form9();
			form9.ShowDialog ();
		}

		private void menuItem12_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form10=new Form10();
			form10.ShowDialog ();
		}

		private void menuItem13_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form11=new Form11();
			form11.ShowDialog ();
		}

		private void menuItem15_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form12=new Form12();
			form12.ShowDialog ();
		}

		private void menuItem16_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form13=new Form13();
			form13.ShowDialog ();
		}

		private void menuItem18_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form14=new Form14();
			form14.ShowDialog ();
		}

		private void menuItem19_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form15=new Form15();
			form15.ShowDialog ();
		}

		private void menuItem20_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form16=new Form16();
			form16.ShowDialog ();
		}

		private void menuItem21_Click(object sender, System.EventArgs e)
		{
			this.Hide();
			Form form17=new Form17();
			form17.ShowDialog ();
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			string constr1= "workstation id=S0353;packet size=4096;integrated security=SSPI;data source=S0353;pe" +
				"rsist security info=False;initial catalog=TSC";
			string sq1="select * from t_s_c1 where (Sno='"+textBox1.Text+"')";
			SqlConnection cn1=new SqlConnection(constr1);
			SqlDataAdapter sqlDataAdapter1=new SqlDataAdapter(sq1,cn1);
			DataSet dt1=new DataSet();
			sqlDataAdapter1.Fill(dt1,"t_s_c1");
			dataGrid1.SetDataBinding(dt1,"t_s_c1");

			string constr2= "workstation id=S0353;packet size=4096;integrated security=SSPI;data source=S0353;pe" +
				"rsist security info=False;initial catalog=TSC";
			string sq2="select * from t_s_c2 where (Sno='"+textBox1.Text+"')";
			SqlConnection cn2=new SqlConnection(constr2);
			SqlDataAdapter sqlDataAdapter2=new SqlDataAdapter(sq2,cn2);
			DataSet dt2=new DataSet();
			sqlDataAdapter2.Fill(dt2,"t_s_c2");
			dataGrid2.SetDataBinding(dt2,"t_s_c2");

			
		}
	}
}