Execute loop in stored procedure to insert the data in SQL query

Question

How to execute a loop in a stored procedure to insert the data in a SQL query?

For demo, I have a gridview in that there is 10 rows of data now that 10 rows of data I want to insert into a table through a stored procedure.

So, as per the logic to insert that 10 rows of data I want to use the loop. Now, the problem that only that how can I use loop of that gridview in the stored procedure.

The screenshot show there are columns:

srno, accountname, cramount, dramount, tdsamt, sgstamt, cgstamt, igstamt

Now, how I will insert this multiple data(as per in image shown) in tmptable through a stored procedure?

Please help me to solve this issues.

Thank you.

Can you post up some sample data, before, and what you want inserted? You may not need to use a loop. — Keith
– Keith, Commented Aug 9, 2017 at 12:03
@Leonidas199x I updated the image. Please review it. And I think so for insert the gridview data loop only can use. Is there any other idea then please share it. — karan
– karan, Commented Aug 9, 2017 at 12:11
What language is your gridview in? You should tag that language as that is where you will need to write your loop. — Tab Alleman
– Tab Alleman, Commented Aug 9, 2017 at 12:54
Possible duplicate of How to loop through each and every row, column and cells in a GridView and get its value — Tab Alleman
– Tab Alleman, Commented Aug 9, 2017 at 12:57

shambhu yadav · Accepted Answer · 2017-08-09 12:47:38Z

2

As per your need, you can go with bulk insert using XML instead of loop. XML bulk insertion is faster then loop.

All you need to pass your data in XML format to stored procedure. And, Insert that data from XML format, to your table.

You can follow given link, Or you can do google. You will easily get the Solution on google.

1.How to Pass data into XML format; http://www.c-sharpcorner.com/UploadFile/b926a6/insert-multiple-bulk-data-row-in-database-using-xml-in-asp-n/

How to insert data into table from XML format http://www.c-sharpcorner.com/blogs/bulk-insert-into-sql-database-using-xml-file1

answered Aug 9, 2017 at 12:47

shambhu yadav

2512 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Execute loop in stored procedure to insert the data in SQL query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related