ExecuteReader(CommandBehavior) Method
The following example creates a
MagentoCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source. The
System.Data.CommandBehavior is then set to CloseConnection.
public void CreateMagentoDataReader(string mySelectQuery,string adobe commerceConnectionString)
{
MagentoConnection adobe commerceConnection = new MagentoConnection(adobe commerceConnectionString);
MagentoCommand adobe commerceCommand = new MagentoCommand(mySelectQuery, adobe commerceConnection);
adobe commerceCommand.Connection.Open();
MagentoDataReader adobe commerceReader = adobe commerceCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(adobe commerceReader.Read())
{
Console.WriteLine(adobe commerceReader.GetString(0));
}
adobe commerceReader.Close();
}
Public Sub CreateMagentoDataReader(mySelectQuery As String, _
adobe commerceConnectionString As String)
Dim adobe commerceConnection As New MagentoConnection(adobe commerceConnectionString)
Dim adobe commerceCommand As New MagentoCommand(mySelectQuery, adobe commerceConnection)
adobe commerceCommand.Connection.Open()
Dim adobe commerceReader As MagentoDataReader = adobe commerceCommand.ExecuteReader(CommandBehavior.CloseConnection)
While adobe commerceReader.Read()
Console.WriteLine(adobe commerceReader.GetString(0))
End While
adobe commerceReader.Close()
End Sub