Datasets and C# codes
Dear Team,
How do we use datasets and how do we get the data one by one from the datasets.
Also can you pls share the standard used common C# codes which helpful for excel and Database related.
Thanks
Siva
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
US
Pega Robotics is based on .Net and as you can see from the example I gave you it just follows the .Net object model. You can search the Pega Robotics help (http://help.openspan.com) for information about the software options, but if you are trying to do something similar to what you do in C# you will need to use proxies. When an object has properties that are complex objects, in order to access the Properties, Methods and Events of that property you must extract a proxy. To extract a proxy, right-click on the blue dot and choose Extract Proxy from the context menu. That is what you see above in the example. We could have taken it further to get a Rows proxy for the datatable and then get an individual row, etc.
Content is growing on PDN and here on the Product Support Community. Thanks for asking questions as that will help us to answers the questions that you need answers for.
Pegasystems Inc.
US
Pega Robotics has a lookup table component. It is a wrapper for the System.Data.DataTable. If you pass in a Dataset you can extract a proxy and process the tables one at a time, loading them into a lookup table or just using them directly.
Here is an example.
Accenture
IN
Thanks jeffbadger for your timely response.
Where can i find these kind of answer from PDN library. Since Every time we have to ask and get it.
Is there any place where we can find these details or do we have any common library for these.
Thanks
Siva
Accepted Solution
Pegasystems Inc.
US
Pega Robotics is based on .Net and as you can see from the example I gave you it just follows the .Net object model. You can search the Pega Robotics help (http://help.openspan.com) for information about the software options, but if you are trying to do something similar to what you do in C# you will need to use proxies. When an object has properties that are complex objects, in order to access the Properties, Methods and Events of that property you must extract a proxy. To extract a proxy, right-click on the blue dot and choose Extract Proxy from the context menu. That is what you see above in the example. We could have taken it further to get a Rows proxy for the datatable and then get an individual row, etc.
Content is growing on PDN and here on the Product Support Community. Thanks for asking questions as that will help us to answers the questions that you need answers for.