ExecuteReader() Method

In This Topic

Sends the CommandText to the Connection and builds a MagentoDataReader.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shadows Function ExecuteReader() As MagentoDataReader

public new MagentoDataReader ExecuteReader()

Return Value

A MagentoDataReader object.

Example

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.

csharp

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();
  try
  {
    while(adobe commerceReader.Read())
    {
      Console.WriteLine(adobe commerceReader.GetString(0));
    }
  }
  finally
  {
    adobe commerceReader.Close();
    adobe commerceConnection.Close();
  }
}

Visual Basic

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()
  Try
    While adobe commerceReader.Read()
      Console.WriteLine(adobe commerceReader.GetString(0))
    End While
  Finally
    adobe commerceReader.Close()
    adobe commerceConnection.Close()
  End Try
End Sub

Reference

MagentoCommand Class
MagentoCommand Members
Overload List
MagentoDataReader Class
MagentoConnection Class

Send Feedback