Skip to main content
1-Visitor
Jul 16, 2018 1:12 PM UTC
Question

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

5-Regular Member
Jul 16, 2018 2:52 PM UTC

Hi @svisveswaraiya_285988 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) 

Translate