Add tables to DataSet

Marc Rempel

26 April 2012 00:40

Is there a simple way to add output FeatureSets from a QueryTask to a DataSet for use in the Report Template? 

I have used the FeatureSetToDataTable activity to get a System.Data.DataTable output and I created a variable of type System.Data.DataSet.  I want to add the output of the FeatureSetToDataTable activity to the DataSet, but I have not gotten the syntax right yet for the assign activity, assuming that is the right approach.  

It would seem that this should be doable outside of having to create a custom activity.

Marc

0

• 

  Ryan Cooney

  26 April 2012 01:38

  Hi Marc,

  This is possible but the nature of the Tables collection of the DataSet makes it a bit awkward.

  Let's assume you have a DataSet in a variable called "ds" and a DataTable in a variable called "dt".

  1. Add an Invoke Method activity to your workflow.
  2. Set the TargetObject to "ds.Tables". 
  3. Set the MethodName to "Add".
  4. Click the "..." button next to the Parameters collection in the Properties pane.
  5. Click Create Argument. 
  6. Set the Direction to "In".
  7. Set the Type to "DataTable".
  8. Set the value to "dt".

  This will invoke the Add method on the DataSet's Tables collection and pass in your DataTable as a the method parameter.

  --Ryan

   

  0
• 

  Marc Rempel

  26 April 2012 05:49

  Thanks, Ryan!

  Marc

  0

Du måste logga in om du vill lämna en kommentar.