CreateParameter Method (SQLiteCommand)
Creates a new instance of a
SQLiteParameter object.
This sample shows how to create a parameter using
CreateParameter function.
|
|---|
Public void CreateParam(SQLiteConnection sqLiteConnection)
{
SQLiteCommand sqLiteCommand = new SQLiteCommand("SELECT * FROM Dept WHERE DeptNo=:Deptno",sqLiteConnection);
SQLiteParameter myParam = sqLiteCommand.CreateParameter();
myParam.SQLiteType = Devart.Data.SQLite.SQLiteType.Int32;
myParam.Value = 10;
myParam.ParameterName = "Deptno";
sqLiteCommand.Parameters.Add(myParam);
sqLiteConnection.Open();
SQLiteDataReader sqLiteReader = null;
try
{
sqLiteReader = sqLiteCommand.ExecuteReader();
while (sqLiteReader.Read())
{
Console.WriteLine(sqLiteReader.GetInt32(0) + ", " + sqLiteReader.GetString(1) + ", " + sqLiteReader.GetString(2));
}
}
finally
{
sqLiteReader.Close();
sqLiteConnection.Close();
}
} |
|
|---|
Public Sub CreateParam(ByVal sqLiteConnection As SQLiteConnection)
Dim sqLiteCommand As New SQLiteCommand("SELECT * FROM Dept WHERE DeptNo=:Deptno", sqLiteConnection)
Dim myParam As SQLiteParameter = sqLiteCommand.CreateParameter()
myParam.SQLiteType = Devart.Data.SQLite.SQLiteType.Int32
myParam.Value = 10
myParam.ParameterName = "Deptno"
sqLiteCommand.Parameters.Add(myParam)
sqLiteConnection.Open()
Dim sqLiteReader As SQLiteDataReader = Nothing
Try
sqLiteReader = sqLiteCommand.ExecuteReader()
While sqLiteReader.Read()
Console.WriteLine(sqLiteReader.GetInt32(0).ToString() + ", " _
+ sqLiteReader.GetString(1) + ", " _
+ sqLiteReader.GetString(2))
End While
Finally
sqLiteReader.Close()
sqLiteConnection.Close()
End Try
End Sub |