📄 form1.cs
字号:
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO student(id, name, score, MajorPrize, cet6) VALUES (?, ?, ?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection2;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("id", System.Data.OleDb.OleDbType.Integer, 0, "学号"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("name", System.Data.OleDb.OleDbType.VarWChar, 50, "姓名"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("score", System.Data.OleDb.OleDbType.Single, 0, "成绩"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("MajorPrize", System.Data.OleDb.OleDbType.Integer, 0, "重大发明奖"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("cet6", System.Data.OleDb.OleDbType.VarWChar, 50, "六级"));
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = @"UPDATE student SET id = ?, name = ?, score = ?, MajorPrize = ?, cet6 = ? WHERE (id = ?) AND (MajorPrize = ? OR ? IS NULL AND MajorPrize IS NULL) AND (cet6 = ? OR ? IS NULL AND cet6 IS NULL) AND (name = ? OR ? IS NULL AND name IS NULL) AND (score = ? OR ? IS NULL AND score IS NULL)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection2;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("id", System.Data.OleDb.OleDbType.Integer, 0, "学号"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("name", System.Data.OleDb.OleDbType.VarWChar, 50, "姓名"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("score", System.Data.OleDb.OleDbType.Single, 0, "成绩"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("MajorPrize", System.Data.OleDb.OleDbType.Integer, 0, "重大发明奖"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("cet6", System.Data.OleDb.OleDbType.VarWChar, 50, "六级"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_id", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学号", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_MajorPrize", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "重大发明奖", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_MajorPrize1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "重大发明奖", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_cet6", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "六级", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_cet61", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "六级", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_name", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_name1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_score", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "成绩", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_score1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "成绩", System.Data.DataRowVersion.Original, null));
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM student WHERE (id = ?) AND (MajorPrize = ? OR ? IS NULL AND MajorPriz" +
"e IS NULL) AND (cet6 = ? OR ? IS NULL AND cet6 IS NULL) AND (name = ? OR ? IS NU" +
"LL AND name IS NULL) AND (score = ? OR ? IS NULL AND score IS NULL)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection2;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_id", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学号", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_MajorPrize", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "重大发明奖", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_MajorPrize1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "重大发明奖", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_cet6", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "六级", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_cet61", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "六级", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_name", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_name1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_score", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "成绩", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_score1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "成绩", System.Data.DataRowVersion.Original, null));
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT actionid AS 行为项目编号, actionname AS 行为项目名称, actionscore AS 所加分数 FROM actioni" +
"tem ORDER BY actionid";
this.oleDbSelectCommand2.Connection = this.oleDbConnection2;
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = "INSERT INTO actionitem(actionid, actionname, actionscore) VALUES (?, ?, ?)";
this.oleDbInsertCommand2.Connection = this.oleDbConnection2;
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionid", System.Data.OleDb.OleDbType.VarWChar, 50, "行为项目编号"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionname", System.Data.OleDb.OleDbType.VarWChar, 50, "行为项目名称"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionscore", System.Data.OleDb.OleDbType.Integer, 0, "所加分数"));
//
// oleDbUpdateCommand2
//
this.oleDbUpdateCommand2.CommandText = "UPDATE actionitem SET actionid = ?, actionname = ?, actionscore = ? WHERE (action" +
"id = ?) AND (actionname = ? OR ? IS NULL AND actionname IS NULL) AND (actionscor" +
"e = ? OR ? IS NULL AND actionscore IS NULL)";
this.oleDbUpdateCommand2.Connection = this.oleDbConnection2;
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionid", System.Data.OleDb.OleDbType.VarWChar, 50, "行为项目编号"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionname", System.Data.OleDb.OleDbType.VarWChar, 50, "行为项目名称"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionscore", System.Data.OleDb.OleDbType.Integer, 0, "所加分数"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionid", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "行为项目编号", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "行为项目名称", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionname1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "行为项目名称", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionscore", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "所加分数", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionscore1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "所加分数", System.Data.DataRowVersion.Original, null));
//
// oleDbDeleteCommand2
//
this.oleDbDeleteCommand2.CommandText = "DELETE FROM actionitem WHERE (actionid = ?) AND (actionname = ? OR ? IS NULL AND " +
"actionname IS NULL) AND (actionscore = ? OR ? IS NULL AND actionscore IS NULL)";
this.oleDbDeleteCommand2.Connection = this.oleDbConnection2;
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionid", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "行为项目编号", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "行为项目名称", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionname1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "行为项目名称", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionscore", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "所加分数", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionscore1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "所加分数", System.Data.DataRowVersion.Original, null));
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT studentid AS 学号, actionid AS 项编号, actionname AS 项名称, num AS 数目 FROM num OR" +
"DER BY studentid";
this.oleDbSelectCommand3.Connection = this.oleDbConnection2;
//
// oleDbInsertCommand3
//
this.oleDbInsertCommand3.CommandText = "INSERT INTO num(studentid, actionid, actionname, num) VALUES (?, ?, ?, ?)";
this.oleDbInsertCommand3.Connection = this.oleDbConnection2;
this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("studentid", System.Data.OleDb.OleDbType.Integer, 0, "学号"));
this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionid", System.Data.OleDb.OleDbType.VarWChar, 50, "项编号"));
this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionname", System.Data.OleDb.OleDbType.VarWChar, 50, "项名称"));
this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("num", System.Data.OleDb.OleDbType.Integer, 0, "数目"));
//
// oleDbUpdateCommand3
//
this.oleDbUpdateCommand3.CommandText = "UPDATE num SET studentid = ?, actionid = ?, actionname = ?, num = ? WHERE (action" +
"id = ?) AND (studentid = ?) AND (actionname = ? OR ? IS NULL AND actionname IS N" +
"ULL) AND (num = ? OR ? IS NULL AND num IS NULL)";
this.oleDbUpdateCommand3.Connection = this.oleDbConnection2;
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("studentid", System.Data.OleDb.OleDbType.Integer, 0, "学号"));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionid", System.Data.OleDb.OleDbType.VarWChar, 50, "项编号"));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("actionname", System.Data.OleDb.OleDbType.VarWChar, 50, "项名称"));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("num", System.Data.OleDb.OleDbType.Integer, 0, "数目"));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionid", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "项编号", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_studentid", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学号", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "项名称", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionname1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "项名称", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_num", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "数目", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_num1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "数目", System.Data.DataRowVersion.Original, null));
//
// oleDbDeleteCommand3
//
this.oleDbDeleteCommand3.CommandText = "DELETE FROM num WHERE (actionid = ?) AND (studentid = ?) AND (actionname = ? OR ?" +
" IS NULL AND actionname IS NULL) AND (num = ? OR ? IS NULL AND num IS NULL)";
this.oleDbDeleteCommand3.Connection = this.oleDbConnection2;
this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionid", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "项编号", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_studentid", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学号", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "项名称", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_actionname1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "项名称", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_num", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "数目", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_num1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "数目", System.Data.DataRowVersion.Original, null));
//
// oleDbSelectCommand4
//
this.oleDbSelectCommand4.CommandText = "SELECT ID AS 学号, name AS 姓名, bianyi AS 编译原理, C AS c语言, [database] AS 数据库, English" +
" AS 英语, gaoshu AS 高等数学, network AS 计算机网络, os AS 操作系统, zhengzhi AS 政治 FROM origin" +
"al ORDER BY ID";
this.oleDbSelectCommand4.Connection = this.oleDbConnection2;
//
// oleDbInsertCommand4
//
this.oleDbInsertCommand4.CommandText = "INSERT INTO original(ID, name, bianyi, C, [database], English, gaoshu, network, o" +
"s, zhengzhi) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand4.Connection = this.oleDbConnection2;
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("ID", System.Data.OleDb.OleDbType.Integer, 0, "学号"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("name", System.Data.OleDb.OleDbType.VarWChar, 50, "姓名"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("bianyi", System.Data.OleDb.OleDbType.Integer, 0, "编译原理"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("C", System.Data.OleDb.OleDbType.Integer, 0, "c语言"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("database", System.Data.OleDb.OleDbType.Integer, 0, "数据库"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("English", System.Data.OleDb.OleDbType.Integer, 0, "英语"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("gaoshu", System.Data.OleDb.OleDbType.Integer, 0, "高等数学"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("network", System.Data.OleDb.OleDbType.Integer, 0, "计算机网络"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("os", System.Data.OleDb.OleDbType.Integer, 0, "操作系统"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("zhengzhi", System.Data.OleDb.OleDbType.Integer, 0, "政治"));
//
// oleDbUpdateCommand4
//
this.oleDbUpdateCommand4.CommandText = @"UPDATE original SET ID = ?, name = ?, bianyi = ?, C = ?, [database] = ?, English = ?, gaoshu = ?, network = ?, os = ?, zhengzhi = ? WHERE (ID = ?) AND (C = ? OR ? IS NULL AND C IS NULL) AND (English = ? OR ? IS NULL AND English IS NULL) AND (bianyi = ? OR ? IS NULL AND bianyi IS NULL) AND ([database] = ? OR ? IS NULL AND [database] IS NULL) AND (gaoshu = ? OR ? IS NULL AND gaoshu IS NULL) AND (name = ? OR ? IS NULL AND name IS NULL) AND (network = ? OR ? IS NULL AND network IS NULL) AND (os = ? OR ? IS NULL AND os IS NULL) AND (zhengzhi = ? OR ? IS NULL AND zhengzhi IS NULL)";
this.oleDbUpdateCommand4.Connection = this.oleDbConnection2;
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("ID", System.Data.OleDb.OleDbType.Integer, 0, "学号"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("name", System.Data.OleDb.OleDbType.VarWChar, 50, "姓名"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("bianyi", System.Data.OleDb.OleDbType.Integer, 0, "编译原理"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("C", System.Data.OleDb.OleDbType.Integer, 0, "c语言"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("database", System.Data.OleDb.OleDbType.Integer, 0, "数据库"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("English", System.Data.OleDb.OleDbType.Integer, 0, "英语"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("gaoshu", System.Data.OleDb.OleDbType.Integer, 0, "高等数学"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("network", System.Data.OleDb.OleDbType.Integer, 0, "计算机网络"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("os", System.Data.OleDb.OleDbType.Integer, 0, "操作系统"));
this.oleDbUpdateCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("zhengzhi", System.Data.OleDb.OleDbType.Integer, 0, "政治"));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -