Connection Property (DB2Command)

In This Topic

Gets or sets the DB2Connection used by this instance of the DB2Command.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Property Connection As DB2Connection

public new DB2Connection Connection {get; set;}

Property Value

The connection to a data source. The default value is a null reference.

Remarks

DB2Connection specified in this property will carry out all operations executed with this DB2Command.

This property supports the InterForm technology.

Example

The following example creates a DB2Command and sets some of its properties.

csharp

public void CreateCommand()
{
  string mySelectQuery = "SELECT * FROM Dept ORDER BY DeptNo";
  DB2Command db2Command = new DB2Command(mySelectQuery);
  db2Command.Connection = new DB2Connection(
    "user id=db2admin;server=db2;database=SAMPLE;");
  db2Command.CommandType = System.Data.CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Dept ORDER BY DeptNo"
  Dim db2Command As New DB2Command(mySelectQuery)
  db2Command.Connection = New DB2Connection( _
    "user id=db2admin;server=db2;database=SAMPLE;")
  db2Command.CommandType = System.Data.CommandType.Text
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

DB2Command Class
DB2Command Members
CommandText Property
System.Data.CommandType

Send Feedback