📄 courseelect1.cs
字号:
this.button1.Size = new System.Drawing.Size(88, 23);
this.button1.TabIndex = 17;
this.button1.Text = "查找选课记录";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// dateTimePicker2
//
this.dateTimePicker2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "选课表.上课结束日期"));
this.dateTimePicker2.Location = new System.Drawing.Point(88, 504);
this.dateTimePicker2.Name = "dateTimePicker2";
this.dateTimePicker2.Size = new System.Drawing.Size(120, 21);
this.dateTimePicker2.TabIndex = 14;
//
// dateTimePicker1
//
this.dateTimePicker1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "选课表.上课起始日期"));
this.dateTimePicker1.Location = new System.Drawing.Point(88, 472);
this.dateTimePicker1.Name = "dateTimePicker1";
this.dateTimePicker1.Size = new System.Drawing.Size(120, 21);
this.dateTimePicker1.TabIndex = 13;
//
// label4
//
this.label4.Location = new System.Drawing.Point(8, 504);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(80, 23);
this.label4.TabIndex = 6;
this.label4.Text = "上课结束日期";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.label4.Click += new System.EventHandler(this.label4_Click);
//
// label3
//
this.label3.Location = new System.Drawing.Point(8, 472);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(80, 23);
this.label3.TabIndex = 5;
this.label3.Text = "上课起始日期";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// 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("上课结束日期", "上课结束日期")})});
this.da1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 选课表 WHERE (课程号 = @Original_课程号) AND (上课结束日期 = @Original_上课结束日期 OR @Original_上课结束日期 IS NULL AND 上课结束日期 IS NULL) AND (上课起始日期 = @Original_上课起始日期 OR @Original_上课起始日期 IS NULL AND 上课起始日期 IS NULL) AND (学号 = @Original_学号) AND (成绩 = @Original_成绩 OR @Original_成绩 IS NULL AND 成绩 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程号", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上课结束日期", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上课结束日期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上课起始日期", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上课起始日期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_学号", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_成绩", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "成绩", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=\"IBM-1A298E66873\";packet size=4096;integrated security=SSPI;initia" +
"l catalog=\"study&teach\";persist security info=False";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 选课表(学号, 课程号, 成绩, 上课起始日期, 上课结束日期) VALUES (@学号, @课程号, @成绩, @上课起始日期, @上课" +
"结束日期); SELECT 学号, 课程号, 成绩, 上课起始日期, 上课结束日期 FROM 选课表 WHERE (课程号 = @课程号)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学号", System.Data.SqlDbType.VarChar, 8, "学号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程号", System.Data.SqlDbType.VarChar, 8, "课程号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@成绩", System.Data.SqlDbType.Int, 4, "成绩"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上课起始日期", System.Data.SqlDbType.DateTime, 8, "上课起始日期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上课结束日期", System.Data.SqlDbType.DateTime, 8, "上课结束日期"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 学号, 课程号, 成绩, 上课起始日期, 上课结束日期 FROM 选课表 WHERE (学号 LIKE @Param3) AND (课程号 LIKE" +
" @Param4)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 8, "学号"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 8, "课程号"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 选课表 SET 学号 = @学号, 课程号 = @课程号, 成绩 = @成绩, 上课起始日期 = @上课起始日期, 上课结束日期 = @上课结束日期 WHERE (课程号 = @Original_课程号) AND (上课结束日期 = @Original_上课结束日期 OR @Original_上课结束日期 IS NULL AND 上课结束日期 IS NULL) AND (上课起始日期 = @Original_上课起始日期 OR @Original_上课起始日期 IS NULL AND 上课起始日期 IS NULL) AND (学号 = @Original_学号) AND (成绩 = @Original_成绩 OR @Original_成绩 IS NULL AND 成绩 IS NULL); SELECT 学号, 课程号, 成绩, 上课起始日期, 上课结束日期 FROM 选课表 WHERE (课程号 = @课程号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学号", System.Data.SqlDbType.VarChar, 8, "学号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程号", System.Data.SqlDbType.VarChar, 8, "课程号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@成绩", System.Data.SqlDbType.Int, 4, "成绩"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上课起始日期", System.Data.SqlDbType.DateTime, 8, "上课起始日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上课结束日期", System.Data.SqlDbType.DateTime, 8, "上课结束日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程号", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上课结束日期", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上课结束日期", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上课起始日期", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上课起始日期", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_学号", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_成绩", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "成绩", System.Data.DataRowVersion.Original, null));
//
// cmb1
//
this.cmb1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "选课表.课程号"));
this.cmb1.DataSource = this.dataSet71.课程表;
this.cmb1.DisplayMember = "课程号";
this.cmb1.Location = new System.Drawing.Point(88, 408);
this.cmb1.Name = "cmb1";
this.cmb1.Size = new System.Drawing.Size(121, 20);
this.cmb1.TabIndex = 7;
//
// dataSet71
//
this.dataSet71.DataSetName = "DataSet7";
this.dataSet71.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// cmb2
//
this.cmb2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet71, "课程表.课程名"));
this.cmb2.DataSource = this.dataSet71.课程表;
this.cmb2.DisplayMember = "课程名";
this.cmb2.Location = new System.Drawing.Point(88, 440);
this.cmb2.Name = "cmb2";
this.cmb2.Size = new System.Drawing.Size(121, 20);
this.cmb2.TabIndex = 8;
//
// label1
//
this.label1.Location = new System.Drawing.Point(16, 408);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(48, 23);
this.label1.TabIndex = 15;
this.label1.Text = "课程号";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.label1.Click += new System.EventHandler(this.label1_Click);
//
// label2
//
this.label2.Location = new System.Drawing.Point(16, 440);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(56, 23);
this.label2.TabIndex = 16;
this.label2.Text = "课程名称";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// dataGrid2
//
this.dataGrid2.CaptionVisible = false;
this.dataGrid2.DataMember = "";
this.dataGrid2.DataSource = this.dataSet71.课程表;
this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid2.Location = new System.Drawing.Point(224, 408);
this.dataGrid2.Name = "dataGrid2";
this.dataGrid2.Size = new System.Drawing.Size(376, 168);
this.dataGrid2.TabIndex = 17;
//
// sqlConnection2
//
this.sqlConnection2.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;data source=\"I" +
"BM-1A298E66873\";persist security info=False;initial catalog=chooseclass";
//
// btnElect
//
this.btnElect.Location = new System.Drawing.Point(120, 536);
this.btnElect.Name = "btnElect";
this.btnElect.TabIndex = 18;
this.btnElect.Text = "选课";
this.btnElect.Click += new System.EventHandler(this.btnElect_Click);
//
// btnSearch
//
this.btnSearch.Location = new System.Drawing.Point(16, 536);
this.btnSearch.Name = "btnSearch";
this.btnSearch.TabIndex = 20;
this.btnSearch.Text = "查询";
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
//
// da2
//
this.da2.DeleteCommand = this.sqlDeleteCommand2;
this.da2.InsertCommand = this.sqlInsertCommand2;
this.da2.SelectCommand = this.sqlSelectCommand2;
this.da2.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("是否本学期课程", "是否本学期课程")})});
this.da2.UpdateCommand = this.sqlUpdateCommand2;
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = @"DELETE FROM 课程表 WHERE (课程号 = @Original_课程号) AND (上课地点 = @Original_上课地点 OR @Original_上课地点 IS NULL AND 上课地点 IS NULL) AND (学分 = @Original_学分 OR @Original_学分 IS NULL AND 学分 IS NULL) AND (学时 = @Original_学时 OR @Original_学时 IS NULL AND 学时 IS NULL) AND (必修或选修 = @Original_必修或选修) AND (教师 = @Original_教师 OR @Original_教师 IS NULL AND 教师 IS NULL) AND (是否本学期课程 = @Original_是否本学期课程 OR @Original_是否本学期课程 IS NULL AND 是否本学期课程 IS NULL) AND (课程名 = @Original_课程名 OR @Original_课程名 IS NULL AND 课程名 IS NULL)";
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程号", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上课地点", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上课地点", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_学分", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学分", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_学时", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学时", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_必修或选修", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "必修或选修", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_教师", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "教师", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否本学期课程", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否本学期课程", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程名", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程名", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO 课程表(课程号, 课程名, 必修或选修, 教师, 学分, 学时, 上课地点, 是否本学期课程) VALUES (@课程号, @课程名, @" +
"必修或选修, @教师, @学分, @学时, @上课地点, @是否本学期课程); SELECT 课程号, 课程名, 必修或选修, 教师, 学分, 学时, 上课地点" +
", 是否本学期课程 FROM 课程表 WHERE (课程号 = @课程号)";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程号", System.Data.SqlDbType.VarChar, 8, "课程号"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程名", System.Data.SqlDbType.VarChar, 40, "课程名"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@必修或选修", System.Data.SqlDbType.VarChar, 6, "必修或选修"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@教师", System.Data.SqlDbType.VarChar, 50, "教师"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学分", System.Data.SqlDbType.Real, 4, "学分"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学时", System.Data.SqlDbType.Int, 4, "学时"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上课地点", System.Data.SqlDbType.VarChar, 40, "上课地点"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否本学期课程", System.Data.SqlDbType.VarChar, 2, "是否本学期课程"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT 课程号, 课程名, 必修或选修, 教师, 学分, 学时, 上课地点, 是否本学期课程 FROM 课程表 WHERE (课程号 LIKE @Param" +
"3) AND (课程名 LIKE @Param4)";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 8, "课程号"));
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 40, "课程名"));
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.CommandText = @"UPDATE 课程表 SET 课程号 = @课程号, 课程名 = @课程名, 必修或选修 = @必修或选修, 教师 = @教师, 学分 = @学分, 学时 = @学时, 上课地点 = @上课地点, 是否本学期课程 = @是否本学期课程 WHERE (课程号 = @Original_课程号) AND (上课地点 = @Original_上课地点 OR @Original_上课地点 IS NULL AND 上课地点 IS NULL) AND (学分 = @Original_学分 OR @Original_学分 IS NULL AND 学分 IS NULL) AND (学时 = @Original_学时 OR @Original_学时 IS NULL AND 学时 IS NULL) AND (必修或选修 = @Original_必修或选修) AND (教师 = @Original_教师 OR @Original_教师 IS NULL AND 教师 IS NULL) AND (是否本学期课程 = @Original_是否本学期课程 OR @Original_是否本学期课程 IS NULL AND 是否本学期课程 IS NULL) AND (课程名 = @Original_课程名 OR @Original_课程名 IS NULL AND 课程名 IS NULL); SELECT 课程号, 课程名, 必修或选修, 教师, 学分, 学时, 上课地点, 是否本学期课程 FROM 课程表 WHERE (课程号 = @课程号)";
this.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程号", System.Data.SqlDbType.VarChar, 8, "课程号"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程名", System.Data.SqlDbType.VarChar, 40, "课程名"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@必修或选修", System.Data.SqlDbType.VarChar, 6, "必修或选修"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@教师", System.Data.SqlDbType.VarChar, 50, "教师"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学分", System.Data.SqlDbType.Real, 4, "学分"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学时", System.Data.SqlDbType.Int, 4, "学时"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上课地点", System.Data.SqlDbType.VarChar, 40, "上课地点"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否本学期课程", System.Data.SqlDbType.VarChar, 2, "是否本学期课程"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程号", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上课地点", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上课地点", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_学分", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学分", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_学时", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学时", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_必修或选修", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "必修或选修", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_教师", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "教师", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否本学期课程", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否本学期课程", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程名", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程名", System.Data.DataRowVersion.Original, null));
//
// toolBarButton1
//
this.toolBarButton1.Text = "删除选课";
this.toolBarButton1.ToolTipText = "删除选课";
//
// toolBarButton7
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -