C#

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!

using System;
using System.Drawing;
using System.Windows.Forms;
 
class Parent : Form
{
  private TextBox txt;
  private Button btn;
 
  static void Main()
  {
    Application.Run(new Parent());
  }
 
  public Parent()
  {
    this.Text = "Example: Parent Form";
 
    this.txt = new TextBox();
    this.txt.Location = new Point(8, 8);
 
    this.btn = new Button();
    this.btn.Location = new Point(8, this.txt.Bottom + 8);
    this.btn.Text = "Show Child";
    this.btn.Click += new EventHandler(this.btn_Click);
 
    this.Controls.Add(this.txt);
    this.Controls.Add(this.btn);
  }
 
  private void btn_Click(object sender, EventArgs e)
  {
    using (Child form = new Child()) // Make sure 'form' gets disposed
      form.ShowDialog(this);
  }
 
  public string ImportantText
  {
    get { return this.txt.Text; } // Do not expose 'txt' directly.
  }
}
 
class Child : Form
{
  private Label lbl;
 
  public Child()
  {
    this.Text = "Example: Child Form";
 
    this.lbl = new Label();
    this.lbl.Location = new Point(8, 8);
 
    this.Controls.Add(this.lbl);
  }
 
  // Owner is not available during construction.
  protected override void OnLoad(EventArgs e)
  {
    this.lbl.Text = ((Parent)this.Owner).ImportantText;
  }
}

When the CommandType property is set to StoredProcedure, you should set the CommandText property to the full Oracle call syntax. The command then executes this stored procedure when you call one of the Execute methods (for example, ExecuteReader or ExecuteNonQuery).

The Connection, CommandType and CommandText properties cannot be set if the current connection is performing an execute or fetch operation.

The .NET Framework Data Provider for Oracle does not support the question mark (?) placeholder for passing parameters to an SQL statement called by an OracleCommand of CommandType.Text. In this case, named parameters must be used. For example:

SELECT * FROM Customers WHERE CustomerID = :pCustomerID

When using named parameters in an SQL statement or stored procedure, you must precede the parameter name with a colon ( . However, when referring to a named parameter elsewhere in your code (for example, when calling Add), do not precede the named parameter with a colon ( . The .NET Framework Data Provider for Oracle supplies the colon automatically.

OracleConnection conn = new OracleConnection("...");
OracleCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "myproc(:param1, :param2)";
cmd.Parameters.Add("param1", OracleType.Int32).Value = 1;
cmd.Parameters.Add("param2", OracleType.Char, 40).Value = "CodeProject");
using (conn)
{
  conn.Open();
  cmd.ExecuteNonQuery();
}