f92查4.cs

vb 图书馆管理系统。

			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);
			// 
			// label1
			// 
			this.label1.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(0)), ((System.Byte)(64)), ((System.Byte)(0)));
			this.label1.Location = new System.Drawing.Point(152, 24);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(48, 24);
			this.label1.TabIndex = 0;
			this.label1.Text = "用户名";
			this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			this.label1.Click += new System.EventHandler(this.label1_Click);
			// 
			// button1
			// 
			this.button1.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(0)), ((System.Byte)(0)), ((System.Byte)(192)));
			this.button1.Location = new System.Drawing.Point(200, 208);
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(88, 32);
			this.button1.TabIndex = 1;
			this.button1.Text = "查询";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// textBox1
			// 
			this.textBox1.Location = new System.Drawing.Point(216, 24);
			this.textBox1.Name = "textBox1";
			this.textBox1.Size = new System.Drawing.Size(88, 21);
			this.textBox1.TabIndex = 2;
			this.textBox1.Text = "";
			// 
			// dataGrid1
			// 
			this.dataGrid1.DataMember = "";
			this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid1.Location = new System.Drawing.Point(0, 56);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(536, 144);
			this.dataGrid1.TabIndex = 3;
			this.dataGrid1.Navigate += new System.Windows.Forms.NavigateEventHandler(this.dataGrid1_Navigate);
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "ABC", new System.Data.Common.DataColumnMapping[] {
																																																			 new System.Data.Common.DataColumnMapping("Sno", "Sno"),
																																																			 new System.Data.Common.DataColumnMapping("Sname", "Sname"),
																																																			 new System.Data.Common.DataColumnMapping("Cno", "Cno"),
																																																			 new System.Data.Common.DataColumnMapping("Cname", "Cname"),
																																																			 new System.Data.Common.DataColumnMapping("Cgrade", "Cgrade"),
																																																			 new System.Data.Common.DataColumnMapping("Tno", "Tno"),
																																																			 new System.Data.Common.DataColumnMapping("Tname", "Tname")})});
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT Sno, Sname, Cno, Cname, Cgrade, Tno, Tname FROM ABC";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = "INSERT INTO ABC(Sno, Sname, Cno, Cname, Cgrade, Tno, Tname) VALUES (@Sno, @Sname," +
				" @Cno, @Cname, @Cgrade, @Tno, @Tname); SELECT Sno, Sname, Cno, Cname, Cgrade, Tn" +
				"o, Tname FROM ABC";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Sno", System.Data.SqlDbType.VarChar, 10, "Sno"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Sname", System.Data.SqlDbType.VarChar, 10, "Sname"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Cno", System.Data.SqlDbType.VarChar, 10, "Cno"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Cname", System.Data.SqlDbType.VarChar, 10, "Cname"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Cgrade", System.Data.SqlDbType.Int, 4, "Cgrade"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Tno", System.Data.SqlDbType.VarChar, 10, "Tno"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Tname", System.Data.SqlDbType.VarChar, 10, "Tname"));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "data source=S0353;initial catalog=TSC;integrated security=SSPI;persist security i" +
				"nfo=False;workstation id=S0348;packet size=4096";
			// 
			// Form11
			// 
			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.dataGrid1,
																		  this.textBox1,
																		  this.button1,
																		  this.label1});
			this.MaximizeBox = false;
			this.Menu = this.mainMenu1;
			this.Name = "Form11";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.Text = "查询综合信息";
			((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 label1_Click(object sender, System.EventArgs e)
		{
		
		}

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

		private void button1_Click(object sender, System.EventArgs e)
		{
			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 ABC where (Sno='"+textBox1.Text+"')";
			SqlConnection cn1=new SqlConnection(constr);
			SqlDataAdapter sqlDataAdapter1=new SqlDataAdapter(sq1,cn1);
			DataSet dt1=new DataSet();
			sqlDataAdapter1.Fill(dt1,"ABC");
			dataGrid1.SetDataBinding(dt1,"ABC");
		}
	}
}