cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to insert 10 rows from grid into dql database table?

Highlighted

How to insert 10 rows from grid into dql database table?

Hi,

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.

 

Thanks,

V Shalini,

1 REPLY 1
Highlighted

Re: How to insert 10 rows from grid into dql database table?

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?

 

For e.g.

 

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) 

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________