f2输1.cs

vb 图书馆管理系统。

			// textBox2
			// 
			this.textBox2.Location = new System.Drawing.Point(136, 88);
			this.textBox2.Name = "textBox2";
			this.textBox2.Size = new System.Drawing.Size(96, 21);
			this.textBox2.TabIndex = 1;
			this.textBox2.Text = "";
			// 
			// textBox3
			// 
			this.textBox3.Location = new System.Drawing.Point(256, 88);
			this.textBox3.Name = "textBox3";
			this.textBox3.Size = new System.Drawing.Size(96, 21);
			this.textBox3.TabIndex = 2;
			this.textBox3.Text = "";
			// 
			// textBox4
			// 
			this.textBox4.Location = new System.Drawing.Point(376, 88);
			this.textBox4.Name = "textBox4";
			this.textBox4.Size = new System.Drawing.Size(96, 21);
			this.textBox4.TabIndex = 3;
			this.textBox4.Text = "";
			// 
			// textBox5
			// 
			this.textBox5.Location = new System.Drawing.Point(496, 88);
			this.textBox5.Name = "textBox5";
			this.textBox5.Size = new System.Drawing.Size(96, 21);
			this.textBox5.TabIndex = 4;
			this.textBox5.Text = "";
			// 
			// groupBox1
			// 
			this.groupBox1.BackgroundImage = ((System.Drawing.Bitmap)(resources.GetObject("groupBox1.BackgroundImage")));
			this.groupBox1.Controls.AddRange(new System.Windows.Forms.Control[] {
																					this.label5,
																					this.label4,
																					this.label3,
																					this.label2,
																					this.label1,
																					this.textBox5,
																					this.textBox4,
																					this.textBox3,
																					this.textBox1,
																					this.textBox2,
																					this.button1});
			this.groupBox1.Location = new System.Drawing.Point(16, 32);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(712, 200);
			this.groupBox1.TabIndex = 5;
			this.groupBox1.TabStop = false;
			this.groupBox1.Enter += new System.EventHandler(this.groupBox1_Enter);
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(496, 40);
			this.label5.Name = "label5";
			this.label5.TabIndex = 9;
			this.label5.Text = "教授课程名";
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(376, 40);
			this.label4.Name = "label4";
			this.label4.TabIndex = 8;
			this.label4.Text = "性别";
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(256, 40);
			this.label3.Name = "label3";
			this.label3.TabIndex = 7;
			this.label3.Text = "年龄";
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(136, 40);
			this.label2.Name = "label2";
			this.label2.TabIndex = 6;
			this.label2.Text = "姓名";
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(16, 40);
			this.label1.Name = "label1";
			this.label1.TabIndex = 5;
			this.label1.Text = "教师号";
			this.label1.Click += new System.EventHandler(this.label1_Click);
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(616, 96);
			this.button1.Name = "button1";
			this.button1.TabIndex = 6;
			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, 304);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(696, 80);
			this.dataGrid1.TabIndex = 6;
			this.dataGrid1.Navigate += new System.Windows.Forms.NavigateEventHandler(this.dataGrid1_Navigate);
			// 
			// Form2
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.BackgroundImage = ((System.Drawing.Bitmap)(resources.GetObject("$this.BackgroundImage")));
			this.ClientSize = new System.Drawing.Size(742, 473);
			this.Controls.AddRange(new System.Windows.Forms.Control[] {
																		  this.dataGrid1,
																		  this.groupBox1});
			this.MaximizeBox = false;
			this.Menu = this.mainMenu1;
			this.Name = "Form2";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.Text = "输入教师表";
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).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 t_tno;
			int t_tage;
			string t_tname,t_tsex,t_tcourse;
			
			//  t_tage =int.Parse(textBox1.Text);
			t_tno =textBox1.Text;
			t_tname = textBox2.Text;
			t_tage =int.Parse(textBox3.Text);
			t_tsex=textBox4.Text;
			t_tcourse=textBox5.Text;
			

		
			MessageBox.Show("\t学号: "+t_tno+"\t姓名: "+t_tname+"\t年龄： "+t_tage+"\t性别: "+t_tsex+"\t教授课程: "+t_tcourse);
			SqlConnection connection = new SqlConnection("workstation id=S0353;packet size=4096;integrated security=SSPI;data source=S0353;persist security info=False;initial catalog=TSC");
			try
			{
				connection.Open();
				SqlCommand command = new SqlCommand("insert into T values ('"+t_tno+"','"+t_tname+"','"+t_tage+"','"+t_tsex+"','"+t_tcourse+"')",connection);
				command.ExecuteNonQuery();
				MessageBox.Show("插入成功");
           
			}
			catch (Exception ex)
			{
				MessageBox.Show(ex.Message);
			}

			string constr= "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 where (Tno='"+textBox1.Text+"')";
			SqlConnection cn1=new SqlConnection(constr);
			SqlDataAdapter sqlDataAdapter1=new SqlDataAdapter(sq1,cn1);
			DataSet dt1=new DataSet();
			sqlDataAdapter1.Fill(dt1,"T");
			dataGrid1.SetDataBinding(dt1,"T");
		}

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

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

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