Represents a SQL statement or stored procedure to execute against BigCommerce.
The following example uses the
ExecuteReader method of
BigcommerceCommand, along with
BigcommerceDataReader and
BigcommerceConnection, to select rows from a table.
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT id, lastname FROM customers";
BigcommerceConnection bigcommerceConnection = new BigcommerceConnection(myConnString);
BigcommerceCommand bigcommerceCommand = new BigcommerceCommand(mySelectQuery,bigcommerceConnection);
bigcommerceConnection.Open();
BigcommerceDataReader bigcommerceReader = bigcommerceCommand.ExecuteReader();
try
{
while (bigcommerceReader.Read())
{
Console.WriteLine(bigcommerceReader.GetInt32(0).ToString() + ", " + bigcommerceReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
bigcommerceReader.Close();
// always call Close when done reading.
bigcommerceConnection.Close();
}
}
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT id, lastname FROM customers"
Dim bigcommerceConnection As New BigcommerceConnection(myConnString)
Dim bigcommerceCommand As New BigcommerceCommand(mySelectQuery, bigcommerceConnection)
bigcommerceConnection.Open()
Dim bigcommerceReader As BigcommerceDataReader = bigcommerceCommand.ExecuteReader()
Try
While bigcommerceReader.Read()
Console.WriteLine(bigcommerceReader.GetInt32(0).ToString() + ", " _
+ bigcommerceReader.GetString(1))
End While
Finally
' always call Close when done reading.
bigcommerceReader.Close()
' always call Close when done with connection.
bigcommerceConnection.Close()
End Try
End Sub