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

Reference

DB2Command Class
DB2Command Members
CommandText Property
System.Data.CommandType

Send Feedback