CreateCommand Method (DB2Connection)

In This Topic

Creates and returns a DB2Command object associated with the DB2Connection.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Function CreateCommand() As DB2Command

public new DB2Command CreateCommand()

Return Value

A DB2Command object.

Remarks

You can use this method as an alternative to common DB2Command constructors.

Example

In this sample DB2Command object is created. It is automatically associated with DB2Connection that created it.

csharp

public void CreateDB2Command(string myConnString)
{
  DB2Connection db2Connection = new DB2Connection(myConnString);
  DB2Command db2Command = db2Connection.CreateCommand();
  db2Command.CommandText = "INSERT INTO DEPT VALUES (50,'Development','Philadelphia')";
  db2Connection.Open();
  try
  {
    db2Command.ExecuteNonQuery();
  }
  finally
  {
    db2Connection.Close();
  }
}

Visual Basic

Public Sub CreateDB2Command(ByVal myConnString As String)
  Dim db2Connection As New DB2Connection(myConnString)
  Dim db2Command As DB2Command = db2Connection.CreateCommand()
  db2Command.CommandText = "INSERT INTO DEPT VALUES (50,'Development','Philadelphia')"
  db2Connection.Open()
  Try
    db2Command.ExecuteNonQuery()
  Finally
    db2Connection.Close()
  End Try
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DB2Connection Class
DB2Connection Members
DB2Command Class

Send Feedback