How can we insert 10 rows in a grid to sql database?
Using selected row option we can insert one row, but what about insert all the rows in a grid at a time?
Or is it possible to insert datashape into sql?
Please provide some guidance.
Hi @svisveswaraiya- how and from where do you wish to insert these rows in RDBMS system? DataShape is not actually storing the data, so you I suppose you are looking to insert the Infotable?
loop through infotable --> pick each row from infotable -->insert to RDBMS system by calling a SQLCommand service which takes input (in this case inputs will be the cell from your infotable)
Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!