ExactTargetParameter Class
Represents a parameter to a
ExactTargetCommand, and optionally, its mapping to
System.Data.DataSet columns.
The following example creates multiple instances of
ExactTargetParameter through the
ExactTargetParameterCollection within the
ExactTargetDataAdapter. These parameters are used to select data from ExactTarget and place the data in the
System.Data.DataSet. This example assumes that a
System.Data.DataSet and a
ExactTargetDataAdapter have already been created with the appropriate schema, commands, and connection.
public void AddExactTargetParameters()
{
// ...
// create myDataSet and myDataAdapter
// ...
myDataAdapter.SelectCommand.Parameters.Add("DName", ExactTargetType.VarChar, 15).Value = "DEVELOPMENT";
myDataAdapter.SelectCommand.Parameters.Add("DeptNo", ExactTargetType.Int).Value = 50;
myDataAdapter.Fill(myDataSet);
}
Public Sub AddExactTargetParameters()
' ...
' create myDataSet and myDataAdapter
' ...
myDataAdapter.SelectCommand.Parameters.Add("DName", ExactTargetType.VarChar, 15).Value = "DEVELOPMENT"
myDataAdapter.SelectCommand.Parameters.Add("DeptNo", ExactTargetType.Int).Value = 50
myDataAdapter.Fill(myDataSet)
End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2