Connection Property (SQLiteCommand)

In This Topic

Syntax
Remarks
Example
Requirements
See Also

Gets or sets the SQLiteConnection used by this instance of the SQLiteCommand.

Syntax

Visual Basic
C#

public new SQLiteConnection Connection {get; set;}

'Declaration
 
Public Shadows Property Connection As SQLiteConnection

Property Value

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

Remarks

SQLiteConnection specified in this property will carry out all operations executed with this SQLiteCommand.

This property supports the InterForm technology.

Example

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

csharp

public void CreateCommand()
{
  string mySelectQuery = "SELECT * FROM Dept ORDER BY DeptNo";
  SQLiteCommand sqCommand = new SQLiteCommand(mySelectQuery);
  sqCommand.Connection = new SQLiteConnection(
    "DataSource=mydatabase.db;");
  sqCommand.CommandType = System.Data.CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Dept ORDER BY DeptNo"
  Dim sqCommand As New SQLiteCommand(mySelectQuery)
  sqCommand.Connection = New SQLiteConnection( _
    "DataSource=mydatabase.db;")
  sqCommand.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

SQLiteCommand Class
SQLiteCommand Members
CommandText Property
CommandType Property

Send Feedback