📄 form1.cs
字号:
oracleParameter18.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter18.ParameterName = ":original_ENAME_param9";
oracleParameter18.SourceColumn = "ENAME";
oracleParameter18.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter19.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter19.ParameterName = ":original_ENAME_param10";
oracleParameter19.SourceColumn = "ENAME";
oracleParameter19.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter20.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter20.ParameterName = ":original_JOB_param11";
oracleParameter20.SourceColumn = "JOB";
oracleParameter20.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter21.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter21.ParameterName = ":original_JOB_param12";
oracleParameter21.SourceColumn = "JOB";
oracleParameter21.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter22.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter22.ParameterName = ":original_MGR_param13";
oracleParameter22.SourceColumn = "MGR";
oracleParameter22.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter23.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter23.ParameterName = ":original_MGR_param14";
oracleParameter23.SourceColumn = "MGR";
oracleParameter23.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter24.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Date;
oracleParameter24.ParameterName = ":original_HIREDATE_param15";
oracleParameter24.SourceColumn = "HIREDATE";
oracleParameter24.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter25.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Date;
oracleParameter25.ParameterName = ":original_HIREDATE_param16";
oracleParameter25.SourceColumn = "HIREDATE";
oracleParameter25.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter26.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter26.ParameterName = ":original_SAL_param17";
oracleParameter26.SourceColumn = "SAL";
oracleParameter26.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter27.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter27.ParameterName = ":original_SAL_param18";
oracleParameter27.SourceColumn = "SAL";
oracleParameter27.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter28.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter28.ParameterName = ":original_COMM_param19";
oracleParameter28.SourceColumn = "COMM";
oracleParameter28.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter29.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter29.ParameterName = ":original_COMM_param20";
oracleParameter29.SourceColumn = "COMM";
oracleParameter29.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter30.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter30.ParameterName = ":original_DEPTNO_param21";
oracleParameter30.SourceColumn = "DEPTNO";
oracleParameter30.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter31.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter31.ParameterName = ":original_DEPTNO_param22";
oracleParameter31.SourceColumn = "DEPTNO";
oracleParameter31.SourceVersion = System.Data.DataRowVersion.Original;
this.updateOracleCommand1.Parameters.Add(oracleParameter9);
this.updateOracleCommand1.Parameters.Add(oracleParameter10);
this.updateOracleCommand1.Parameters.Add(oracleParameter11);
this.updateOracleCommand1.Parameters.Add(oracleParameter12);
this.updateOracleCommand1.Parameters.Add(oracleParameter13);
this.updateOracleCommand1.Parameters.Add(oracleParameter14);
this.updateOracleCommand1.Parameters.Add(oracleParameter15);
this.updateOracleCommand1.Parameters.Add(oracleParameter16);
this.updateOracleCommand1.Parameters.Add(oracleParameter17);
this.updateOracleCommand1.Parameters.Add(oracleParameter18);
this.updateOracleCommand1.Parameters.Add(oracleParameter19);
this.updateOracleCommand1.Parameters.Add(oracleParameter20);
this.updateOracleCommand1.Parameters.Add(oracleParameter21);
this.updateOracleCommand1.Parameters.Add(oracleParameter22);
this.updateOracleCommand1.Parameters.Add(oracleParameter23);
this.updateOracleCommand1.Parameters.Add(oracleParameter24);
this.updateOracleCommand1.Parameters.Add(oracleParameter25);
this.updateOracleCommand1.Parameters.Add(oracleParameter26);
this.updateOracleCommand1.Parameters.Add(oracleParameter27);
this.updateOracleCommand1.Parameters.Add(oracleParameter28);
this.updateOracleCommand1.Parameters.Add(oracleParameter29);
this.updateOracleCommand1.Parameters.Add(oracleParameter30);
this.updateOracleCommand1.Parameters.Add(oracleParameter31);
//
// deleteOracleCommand1
//
this.deleteOracleCommand1.CommandText = @"DELETE FROM ""EMP"" WHERE ""EMPNO""=:original_EMPNO_param0 AND ((:original_ENAME_param1 IS NULL AND ""ENAME"" IS NULL) OR ""ENAME""=:original_ENAME_param2) AND ((:original_JOB_param3 IS NULL AND ""JOB"" IS NULL) OR ""JOB""=:original_JOB_param4) AND ((:original_MGR_param5 IS NULL AND ""MGR"" IS NULL) OR ""MGR""=:original_MGR_param6) AND ((:original_HIREDATE_param7 IS NULL AND ""HIREDATE"" IS NULL) OR ""HIREDATE""=:original_HIREDATE_param8) AND ((:original_SAL_param9 IS NULL AND ""SAL"" IS NULL) OR ""SAL""=:original_SAL_param10) AND ((:original_COMM_param11 IS NULL AND ""COMM"" IS NULL) OR ""COMM""=:original_COMM_param12) AND ((:original_DEPTNO_param13 IS NULL AND ""DEPTNO"" IS NULL) OR ""DEPTNO""=:original_DEPTNO_param14)";
this.deleteOracleCommand1.Connection = this.oracleConnection1;
oracleParameter32.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter32.ParameterName = ":original_EMPNO_param0";
oracleParameter32.SourceColumn = "EMPNO";
oracleParameter32.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter33.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter33.ParameterName = ":original_ENAME_param1";
oracleParameter33.SourceColumn = "ENAME";
oracleParameter33.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter34.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter34.ParameterName = ":original_ENAME_param2";
oracleParameter34.SourceColumn = "ENAME";
oracleParameter34.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter35.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter35.ParameterName = ":original_JOB_param3";
oracleParameter35.SourceColumn = "JOB";
oracleParameter35.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter36.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter36.ParameterName = ":original_JOB_param4";
oracleParameter36.SourceColumn = "JOB";
oracleParameter36.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter37.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter37.ParameterName = ":original_MGR_param5";
oracleParameter37.SourceColumn = "MGR";
oracleParameter37.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter38.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter38.ParameterName = ":original_MGR_param6";
oracleParameter38.SourceColumn = "MGR";
oracleParameter38.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter39.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Date;
oracleParameter39.ParameterName = ":original_HIREDATE_param7";
oracleParameter39.SourceColumn = "HIREDATE";
oracleParameter39.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter40.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Date;
oracleParameter40.ParameterName = ":original_HIREDATE_param8";
oracleParameter40.SourceColumn = "HIREDATE";
oracleParameter40.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter41.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter41.ParameterName = ":original_SAL_param9";
oracleParameter41.SourceColumn = "SAL";
oracleParameter41.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter42.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter42.ParameterName = ":original_SAL_param10";
oracleParameter42.SourceColumn = "SAL";
oracleParameter42.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter43.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter43.ParameterName = ":original_COMM_param11";
oracleParameter43.SourceColumn = "COMM";
oracleParameter43.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter44.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter44.ParameterName = ":original_COMM_param12";
oracleParameter44.SourceColumn = "COMM";
oracleParameter44.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter45.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter45.ParameterName = ":original_DEPTNO_param13";
oracleParameter45.SourceColumn = "DEPTNO";
oracleParameter45.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter46.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter46.ParameterName = ":original_DEPTNO_param14";
oracleParameter46.SourceColumn = "DEPTNO";
oracleParameter46.SourceVersion = System.Data.DataRowVersion.Original;
this.deleteOracleCommand1.Parameters.Add(oracleParameter32);
this.deleteOracleCommand1.Parameters.Add(oracleParameter33);
this.deleteOracleCommand1.Parameters.Add(oracleParameter34);
this.deleteOracleCommand1.Parameters.Add(oracleParameter35);
this.deleteOracleCommand1.Parameters.Add(oracleParameter36);
this.deleteOracleCommand1.Parameters.Add(oracleParameter37);
this.deleteOracleCommand1.Parameters.Add(oracleParameter38);
this.deleteOracleCommand1.Parameters.Add(oracleParameter39);
this.deleteOracleCommand1.Parameters.Add(oracleParameter40);
this.deleteOracleCommand1.Parameters.Add(oracleParameter41);
this.deleteOracleCommand1.Parameters.Add(oracleParameter42);
this.deleteOracleCommand1.Parameters.Add(oracleParameter43);
this.deleteOracleCommand1.Parameters.Add(oracleParameter44);
this.deleteOracleCommand1.Parameters.Add(oracleParameter45);
this.deleteOracleCommand1.Parameters.Add(oracleParameter46);
//
// emp11
//
this.emp11.DataSetName = "Emp1";
this.emp11.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(40, 16);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(536, 296);
this.dataGrid1.TabIndex = 0;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(656, 373);
this.Controls.Add(this.dataGrid1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.emp11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void Form1_Load(object sender, System.EventArgs e)
{
this.oracleDataAdapter1.Fill(this.emp11);
this.dataGrid1.DataSource=this.emp11.Tables["emp"];
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -