Loading

Bulk Insertion of Dynamic textbox values into database

Jayanth Reddy

I have created a button and when we click on it for n times,n number of textboxes will be added.I have created the database and gave logic to add single row of textboxes into db.Can someone help me in inserting all that n rows into the database using foreach loop in c sharp(I am using Windows Application Form with Linq to SQl server and C sharp).

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Patel7y ago
Accepted answer
You need to pass datatable to store procedure and store procedure will insert all record.

please follow this url : https://www.aspsnippets.com/Articles/Send-Pass-DataTable-as-parameter-to-Stored-Procedure-in-C-and-VBNet.aspx
0
Jayanth Reddy7y ago
Thanks for the reply but he explained in "data grid view" and on my form dynamic values should be directly inserted into database if we click a button(multiple values)
0