SelectCommand Property (SQLiteDataTable)
Gets or sets a SQLite statement used to select records in the data source.
|
|---|
'Declaration
Public Shadows Property SelectCommand As SQLiteCommand |
Property Value
A
SQLiteCommand that is used during a fill operation to select records from the data source for placement in the
System.Data.DataSet.
This sample shows how to create a
SQLiteDataTable and retrieve data from a table.
|
|---|
public void UseDataTable(SQLiteConnection sqConnection)
{
SQLiteDataTable myDataTable = new SQLiteDataTable();
myDataTable.Connection = sqConnection;
myDataTable.SelectCommand = new SQLiteCommand("SELECT * FROM Dept");
try
{
myDataTable.Active = true;
foreach(DataRow myRow in myDataTable.Rows)
{
foreach(DataColumn myCol in myDataTable.Columns)
{
Console.Write(myRow[myCol]+"\t");
}
Console.WriteLine();
}
}
finally
{
myDataTable.Active = false;
}
} |
|
|---|
Public Sub UseDataTable(ByVal sqConnection As SQLiteConnection)
Dim myDataTable As SQLiteDataTable = New SQLiteDataTable
myDataTable.Connection = sqConnection
myDataTable.SelectCommand = New SQLiteCommand("SELECT * FROM Dept")
Try
myDataTable.Active = True
Dim myRow As DataRow
Dim myCol As DataColumn
For Each myRow In myDataTable.Rows
For Each myCol In myDataTable.Columns
Console.Write(myRow(myCol) & Chr(9))
Next myCol
Console.WriteLine()
Next myRow
Finally
myDataTable.Active = False
End Try
End Sub |
