?? studentinfo.cs
字號:
using System;using System.Collections;using System.ComponentModel;using System.Drawing;using System.Windows.Forms;namespace 教務管理系統{ public class StudentInfo : 醫院管理系統.ParentForm {
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Data.SqlClient.SqlDataAdapter da3;
private System.Data.SqlClient.SqlDataAdapter da4;
private System.Data.SqlClient.SqlCommand sqlSelectCommand3;
private System.Data.SqlClient.SqlCommand sqlSelectCommand4;
private System.Data.SqlClient.SqlDataAdapter da5;
private System.Data.SqlClient.SqlCommand sqlSelectCommand5;
private System.Data.SqlClient.SqlCommand sqlSelectCommand6;
private System.Windows.Forms.TextBox txt4;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.TextBox txt5;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.TextBox txt7;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.ComboBox cmb1;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.ComboBox cmb2;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Label label10;
private System.Windows.Forms.ComboBox cmb3;
private System.Windows.Forms.Label label11;
private System.Windows.Forms.ComboBox cmb4;
private System.Windows.Forms.Label label12;
private System.Windows.Forms.ComboBox cmb5;
private System.Windows.Forms.Label label13;
private System.Windows.Forms.ComboBox cmb6;
private 教務管理系統.DataSet1 dataSet11;
private System.Data.SqlClient.SqlDataAdapter da2;
private System.Windows.Forms.TextBox txt6;
private System.Data.SqlClient.SqlDataAdapter da6;
private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand1; private System.ComponentModel.IContainer components = null; public StudentInfo() { // 該調用是 Windows 窗體設計器所必需的。 InitializeComponent(); // TODO: 在 InitializeComponent 調用后添加任何初始化 } /// <summary> /// 清理所有正在使用的資源。 /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region 設計器生成的代碼 /// <summary> /// 設計器支持所需的方法 - 不要使用代碼編輯器修改 /// 此方法的內容。 /// </summary> private void InitializeComponent() { this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.da3 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
this.da4 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand();
this.da5 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand();
this.da2 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand6 = new System.Data.SqlClient.SqlCommand();
this.txt4 = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.txt5 = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.txt7 = new System.Windows.Forms.TextBox();
this.txt6 = new System.Windows.Forms.TextBox();
this.label9 = new System.Windows.Forms.Label();
this.cmb1 = new System.Windows.Forms.ComboBox();
this.label7 = new System.Windows.Forms.Label();
this.cmb2 = new System.Windows.Forms.ComboBox();
this.label8 = new System.Windows.Forms.Label();
this.label10 = new System.Windows.Forms.Label();
this.cmb3 = new System.Windows.Forms.ComboBox();
this.dataSet11 = new 教務管理系統.DataSet1();
this.label11 = new System.Windows.Forms.Label();
this.cmb4 = new System.Windows.Forms.ComboBox();
this.label12 = new System.Windows.Forms.Label();
this.cmb5 = new System.Windows.Forms.ComboBox();
this.label13 = new System.Windows.Forms.Label();
this.cmb6 = new System.Windows.Forms.ComboBox();
this.da6 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
//
// groupBox1
//
this.groupBox1.Name = "groupBox1";
//
// txt2
//
this.txt2.Name = "txt2";
//
// label1
//
this.label1.Name = "label1";
this.label1.Text = "姓名";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// btnSearch
//
this.btnSearch.Name = "btnSearch";
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
//
// txt1
//
this.txt1.Name = "txt1";
//
// label2
//
this.label2.Name = "label2";
this.label2.Text = "學號";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// txt3
//
this.txt3.Name = "txt3";
//
// label3
//
this.label3.Name = "label3";
this.label3.Text = "年級";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// toolBar1
//
this.toolBar1.Name = "toolBar1";
this.toolBar1.Size = new System.Drawing.Size(728, 41);
//
// dataGrid1
//
this.dataGrid1.DataMember = "學生信息";
this.dataGrid1.DataSource = this.dataSet11;
this.dataGrid1.Name = "dataGrid1";
//
// groupBox2
//
this.groupBox2.Controls.Add(this.cmb1);
this.groupBox2.Controls.Add(this.txt4);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.txt5);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.txt7);
this.groupBox2.Controls.Add(this.txt6);
this.groupBox2.Controls.Add(this.label9);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.cmb2);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.label10);
this.groupBox2.Controls.Add(this.cmb3);
this.groupBox2.Controls.Add(this.label11);
this.groupBox2.Controls.Add(this.cmb4);
this.groupBox2.Controls.Add(this.label12);
this.groupBox2.Controls.Add(this.cmb5);
this.groupBox2.Controls.Add(this.label13);
this.groupBox2.Controls.Add(this.cmb6);
this.groupBox2.Location = new System.Drawing.Point(0, 378);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(728, 120);
//
// da1
//
this.da1.DeleteCommand = this.sqlDeleteCommand1;
this.da1.InsertCommand = this.sqlInsertCommand1;
this.da1.SelectCommand = this.sqlSelectCommand1;
this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "學生信息", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("學號", "學號"),
new System.Data.Common.DataColumnMapping("姓名", "姓名"),
new System.Data.Common.DataColumnMapping("班級編號", "班級編號"),
new System.Data.Common.DataColumnMapping("性別", "性別"),
new System.Data.Common.DataColumnMapping("年級", "年級"),
new System.Data.Common.DataColumnMapping("政治面貌編號", "政治面貌編號"),
new System.Data.Common.DataColumnMapping("民族編號", "民族編號"),
new System.Data.Common.DataColumnMapping("籍貫編號", "籍貫編號"),
new System.Data.Common.DataColumnMapping("身份證號", "身份證號"),
new System.Data.Common.DataColumnMapping("學籍編號", "學籍編號")})});
this.da1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;data source=\"." +
"\";persist security info=False;initial catalog=eisbook";
//
// da3
//
this.da3.SelectCommand = this.sqlSelectCommand3;
this.da3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "籍貫代碼表", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("籍貫編號", "籍貫編號"),
new System.Data.Common.DataColumnMapping("籍貫", "籍貫")})});
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT 籍貫編號, 籍貫 FROM 籍貫代碼表";
this.sqlSelectCommand3.Connection = this.sqlConnection1;
//
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -