The following example creates a
BigcommerceCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source.
|
|---|
public void CreateBigcommerceDataReader(string mySelectQuery,string bigcommerceConnectionString)
{
BigcommerceConnection bigcommerceConnection = new BigcommerceConnection(bigcommerceConnectionString);
BigcommerceCommand bigcommerceCommand = new BigcommerceCommand(mySelectQuery, bigcommerceConnection);
bigcommerceCommand.Connection.Open();
BigcommerceDataReader bigcommerceReader = bigcommerceCommand.ExecuteReader();
try
{
while(bigcommerceReader.Read())
{
Console.WriteLine(bigcommerceReader.GetString(0));
}
}
finally
{
bigcommerceReader.Close();
bigcommerceConnection.Close();
}
} |
|
|---|
Public Sub CreateBigcommerceDataReader(mySelectQuery As String, _
bigcommerceConnectionString As String)
Dim bigcommerceConnection As New BigcommerceConnection(bigcommerceConnectionString)
Dim bigcommerceCommand As New BigcommerceCommand(mySelectQuery, bigcommerceConnection)
bigcommerceCommand.Connection.Open()
Dim bigcommerceReader As BigcommerceDataReader = bigcommerceCommand.ExecuteReader()
Try
While bigcommerceReader.Read()
Console.WriteLine(bigcommerceReader.GetString(0))
End While
Finally
bigcommerceReader.Close()
bigcommerceConnection.Close()
End Try
End Sub |
