Represents a SQL statement or stored procedure to execute against Adobe Commerce.
The following example uses the
ExecuteReader method of
MagentoCommand, along with
MagentoDataReader and
MagentoConnection, to select rows from a table.
|
|---|
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT customer_id, lastname FROM Customers";
MagentoConnection adobe commerceConnection = new MagentoConnection(myConnString);
MagentoCommand adobe commerceCommand = new MagentoCommand(mySelectQuery,adobe commerceConnection);
adobe commerceConnection.Open();
MagentoDataReader adobe commerceReader = adobe commerceCommand.ExecuteReader();
try
{
while (adobe commerceReader.Read())
{
Console.WriteLine(adobe commerceReader.GetInt32(0).ToString() + ", " + adobe commerceReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
adobe commerceReader.Close();
// always call Close when done reading.
adobe commerceConnection.Close();
}
} |
|
|---|
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT customer_id, lastname FROM Customers"
Dim adobe commerceConnection As New MagentoConnection(myConnString)
Dim adobe commerceCommand As New MagentoCommand(mySelectQuery, adobe commerceConnection)
adobe commerceConnection.Open()
Dim adobe commerceReader As MagentoDataReader = adobe commerceCommand.ExecuteReader()
Try
While adobe commerceReader.Read()
Console.WriteLine(adobe commerceReader.GetInt32(0).ToString() + ", " _
+ adobe commerceReader.GetString(1))
End While
Finally
' always call Close when done reading.
adobe commerceReader.Close()
' always call Close when done with connection.
adobe commerceConnection.Close()
End Try
End Sub |
