Connection Property (SQLiteCommand)

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Property Connection As SQLiteConnection

public new SQLiteConnection Connection {get; set;}

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

Reference

SQLiteCommand Class
SQLiteCommand Members
CommandText Property
CommandType Property

Send Feedback