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.
|
|---|
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();
}
} |
|
|---|
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 |
