Connection Property (DB2Command)

On this page

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; }

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

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