How to write a code for inserting multiple records at a time from front end to database using list in C#

Question

1.80/5 (3 votes)

See more:

How to Write a code for inserting multiple records at a time after clicking submitt button from front end to database using list in c# a

What I have tried:

How to Write a code for inserting multiple records at a time after clicking submitt button from front end to database using list in c# a

Posted 15-Oct-16 1:21am

Vasu_Baby

Updated 9-Oct-18 9:25am

Add a Solution

Comments

Afzaal Ahmad Zeeshan 15-Oct-16 7:24am

Why don't submit a bulk object, that contains multiple objects in the form of list?

[no name] 15-Oct-16 7:24am

"How to Write a code "... how? Well *I* would use a keyboard, that's how. What have you tried? What was the problem with the code you have tried? Iterate through your list and insert the list data to your database.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2016-10-15T01:44:00

Well, your first attempt to learn a new thing could have been to search that phrase in Google or Bing. Then with information you get from there you could have tried to write the code according to your requirement. Then if you face any problem, come back here and ask the question with clear description of the problem with code block with the issue.

However, I would suggest to have a look at SqlBulkCopy[^] documentation.

Here are few articles to understand how it can be implemented in real life solutions.
Transferring Data Using SqlBulkCopy[^]
SQL Bulk Copy with C#.Net[^]
Bulk upload into sql server using sqlbulkcopy and C# : www.dotnetmentors.com[^]

Although these articles are written years back but should still work.

Please let me know in case of any difficulties in implementing this if it matches your requirement.

:)

Wendelius · Answer 2 · 2016-10-15T01:48:00

Solution 2

To add to solution 1: One way could be to define a type for the data and pass several records in a table to a procedure. For an example, have a look at How to pass multiple records to a Stored Procedure[^]

Posted 15-Oct-16 1:48am

Wendelius

Updated 15-Oct-16 1:49am

v2

Comments

Suvendu Shekhar Giri 15-Oct-16 11:02am

5! :)

Wendelius 16-Oct-16 3:33am

Thank you :)

melbin mp · Answer 3 · 2018-10-09T09:25:00

Solution 3

Just iterate through all rows and Columns Insert one by One or Else use SQLBulkCopy object in ADO.Net

Posted 9-Oct-18 9:25am

melbin mp

Comments

Richard Deeming 11-Oct-18 11:26am

As already suggested, with more details, in solution 1.

How to write a code for inserting multiple records at a time from front end to database using list in C#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us