'Declaration Public Overrides Property CommandType As CommandType
public override CommandType CommandType {get; set;}
'Declaration Public Overrides Property CommandType As CommandType
public override CommandType CommandType {get; set;}
CommandType can be one of the following values: Text, TableDirect.
When the value is CommandType.Text, the property CommandText should contain text of a query that must be run on the server.
When the value is set to TableDirect, CommandText must be name of a table you want to get all data from. All rows and columns are retrieved.
public void CreateCommand() { SQLiteCommand sqCommand = new SQLiteCommand(); sqCommand.CommandText = "SELECT * FROM Dept ORDER BY DeptNo"; sqCommand.CommandType = CommandType.Text; }
Public Sub CreateCommand() Dim sqCommand As New SQLiteCommand() sqCommand.CommandText = "SELECT * FROM Dept ORDER BY DeptNo" sqCommand.CommandType = CommandType.Text End Sub