CreateParameter Method (BigQueryCommand)
Creates a new instance of a
BigQueryParameter object.
This sample shows how to create a parameter using
CreateParameter function.
|
|---|
Public void CreateParam(BigQueryConnection bigQueryConnection)
{
BigQueryCommand bigQueryCommand = new BigQueryCommand("SELECT * FROM Dept WHERE DeptNo=:Deptno",bigQueryConnection);
BigQueryParameter myParam = bigQueryCommand.CreateParameter();
myParam.BigQueryType = Devart.Data.BigQuery.BigQueryType.Int;
myParam.Value = 10;
myParam.ParameterName = "Deptno";
bigQueryCommand.Parameters.Add(myParam);
bigQueryConnection.Open();
BigQueryDataReader bigQueryReader = null;
try
{
bigQueryReader = bigQueryCommand.ExecuteReader();
while (bigQueryReader.Read())
{
Console.WriteLine(bigQueryReader.GetInt32(0) + ", " + bigQueryReader.GetString(1) + ", " + bigQueryReader.GetString(2));
}
}
finally
{
bigQueryReader.Close();
bigQueryConnection.Close();
}
} |
|
|---|
Public Sub CreateParam(ByVal bigQueryConnection As BigQueryConnection)
Dim bigQueryCommand As New BigQueryCommand("SELECT * FROM Dept WHERE DeptNo=:Deptno", bigQueryConnection)
Dim myParam As BigQueryParameter = bigQueryCommand.CreateParameter()
myParam.BigQueryType = Devart.Data.BigQuery.BigQueryType.Int
myParam.Value = 10
myParam.ParameterName = "Deptno"
bigQueryCommand.Parameters.Add(myParam)
bigQueryConnection.Open()
Dim bigQueryReader As BigQueryDataReader = Nothing
Try
bigQueryReader = bigQueryCommand.ExecuteReader()
While bigQueryReader.Read()
Console.WriteLine(bigQueryReader.GetInt32(0).ToString() + ", " _
+ bigQueryReader.GetString(1) + ", " _
+ bigQueryReader.GetString(2))
End While
Finally
bigQueryReader.Close()
bigQueryConnection.Close()
End Try
End Sub |
