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

[svisveswaraiya]

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,

[supandey]

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)