How to save multiple records from the DataGridview into DB in C#

Question

0.00/5 (No votes)

See more:

I have a datagridview view that looks like this:

ProductId | Name | Price | Quantity

The datagridview starts with all cells empty.

The user will enter data in each of the columns. The number of products the user enters changes(is unknown). The user could enter only one product or five products.

So, once the user has entered all the products he has to enter, i want that when he clicks a button, all products will be saved to the database.

The table in the SQL database looks like the datagrid:

ProductId | Name | Price | Quantity

As the number of products that the user will enter is unknown, how can I save the data to the database?

[Edit]Shouting removed[/Edit]

Posted 12-Feb-13 7:07am

Zain -Ul- Arifeen

Updated 12-Feb-13 7:08am

Thomas Daniels

v2

Add a Solution

2 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)

fjdiewornncalwe · Answer 1 · 2013-02-12T07:27:00

Just treat each product as an individual item and just loop through each product that needs to be inserted and do it.
Dealing with multiple rows is pretty much exactly the same as dealing with individual rows of data. The only difference is that multiple rows are dealt with in a loop of some kind.

Shobhana.n · Answer 2 · 2013-02-12T08:19:00

Solution 2

On inserting new row in datagridview save that row's value in datatable and then save that datatable to viewstate["dt"].On each insert new row( i.e. insert command), Bind datagridview with datatable which saved in viewstate["dt"] .your all data come in the viewstate["dt"].You can make loop on this viewState["dt"] to add save data in database.

Posted 12-Feb-13 8:19am

Shobhana.n

Comments

Zain -Ul- Arifeen 13-Feb-13 11:07am

dear sir,
if u will guid me on this question with code or demo.
that is better for me.
thanx