Represents a SQL statement or stored procedure to execute against Salesforce Marketing Cloud.
The following example uses the
ExecuteReader method of
ExactTargetCommand, along with
ExactTargetDataReader and
ExactTargetConnection, to select rows from a table.
|
|---|
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT ID, Name FROM Email";
ExactTargetConnection exactTargetConnection = new ExactTargetConnection(myConnString);
ExactTargetCommand exactTargetCommand = new ExactTargetCommand(mySelectQuery,exactTargetConnection);
exactTargetConnection.Open();
ExactTargetDataReader exactTargetReader = exactTargetCommand.ExecuteReader();
try
{
while (exactTargetReader.Read())
{
Console.WriteLine(exactTargetReader.GetInt32(0).ToString() + ", " + exactTargetReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
exactTargetReader.Close();
// always call Close when done reading.
exactTargetConnection.Close();
}
} |
|
|---|
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT ID, Name FROM Email"
Dim exactTargetConnection As New ExactTargetConnection(myConnString)
Dim exactTargetCommand As New ExactTargetCommand(mySelectQuery, exactTargetConnection)
exactTargetConnection.Open()
Dim exactTargetReader As ExactTargetDataReader = exactTargetCommand.ExecuteReader()
Try
While exactTargetReader.Read()
Console.WriteLine(exactTargetReader.GetInt32(0).ToString() + ", " _
+ exactTargetReader.GetString(1))
End While
Finally
' always call Close when done reading.
exactTargetReader.Close()
' always call Close when done with connection.
exactTargetConnection.Close()
End Try
End Sub |
