Send the selected list item to a table

[gourinaik98]

I have created a DataShape having 3 field definitions and binded the GetFieldDefinitions service to the list widget. Now i want to send the selected item in the list to a datable or a database. how do i do that?

[raluca_edu · Accepted solution]

Hi,

Create a service with input infotable (this is coming from SelectedRows of the list). In this service you can add info in a datatable already created, with service AddorUpdateDataTableEntry. Unfortunately, there is no service that creates datatable that I am aware of.

Same can be achieved if you want to insert data in a Database (you need a Database Thing that is connecting to the database), providing SelectedRows as input to a service, iterate through infotable and insert field/value in database.

Make sure ValueField property of List widget has the correct value (it should be the name of the field in your case).

Hope it helps,

Raluca Edu

[gourinaik98]

Hello,

should i create the service inside the datatable? 

[raluca_edu]

Not necessarily, you can create it in any thing, you can find the service in Code Snippets.