Skip to main content
1-Visitor
July 16, 2018
Question

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

  • July 16, 2018
  • 1 reply
  • 874 views

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
July 16, 2018

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)