Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rajasekhar U (RajasekharU0829)
CGI

CGI
IN
RajasekharU0829 Member since 2013 102 posts
CGI
Posted: Jun 20, 2018
Last activity: Jun 22, 2018
Posted: 20 Jun 2018 13:47 EDT
Last activity: 22 Jun 2018 2:05 EDT
Closed
Solved

Open Span Automation: How get data from Dataset to display in DataGridView

Using below soap operation to get Country Code and Name in open span automation. How get data from Dataset to display in DataGridView

http://www.holidaywebservice.com/Holidays/HolidayService.asmx/GetCountriesAvailable

Show More

Using below soap operation to get Country Code and Name in open span automation. How get data from Dataset to display in DataGridView

http://www.holidaywebservice.com/Holidays/HolidayService.asmx/GetCountriesAvailable

<DataSet xmlns="http://www.27seconds.com/Holidays/">
<xs:schema xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" id="NewDataSet">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Countries">
<xs:complexType>
<xs:sequence>
<xs:element name="Code" type="xs:string" minOccurs="0"/>
<xs:element name="Name" type="xs:string" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<NewDataSet xmlns="">
<Countries diffgr:id="Countries1" msdata:rowOrder="0" diffgr:hasChanges="inserted">
<Code>US</Code>
<Name>United States</Name>
</Countries>
<Countries diffgr:id="Countries2" msdata:rowOrder="1" diffgr:hasChanges="inserted">
<Code>GBEAW</Code>
<Name>UK - England and Wales</Name>
</Countries>
<Countries diffgr:id="Countries3" msdata:rowOrder="2" diffgr:hasChanges="inserted">
<Code>GBSCT</Code>
<Name>UK - Scotland</Name>
</Countries>
<Countries diffgr:id="Countries4" msdata:rowOrder="3" diffgr:hasChanges="inserted">
<Code>GBNIR</Code>
<Name>UK - Northern Ireland</Name>
</Countries>
</NewDataSet>
</diffgr:diffgram>
</DataSet>
Gone through "https://collaborate.pega.com/question/datasets-and-c-codes"post. Not able to implement.
Thanks in Advance.........
***Edited by Moderator Marissa to update platform capability tags***

Show Less
To see attachments, please log in.
Low-Code App Development
Robotic Process Automation

Posted: 6 years ago
Posted: 20 Jun 2018 20:42 EDT
jayachandra kundu (jayachandrak)
Westpac Banking Corporation

Westpac Banking Corporation
AU

You can write C# code and return dataset or directly call this service from automation using service client component.

After returning dataset from either of the above options then you can assign this to datasource property of datagrid.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice