How I can insert this in my database?

Question

1.00/5 (3 votes)

See more:

How do i insert this on my database.i need exact codes

What I have tried:

C#

private void btnPay_Click(object sender, EventArgs e)
        {
            foreach (DataGridViewRow row in dgvOrder.Rows)
                row.Cells["Amount"].Value = Convert.ToDouble(row.Cells["Qty"].Value) * Convert.ToDouble(row.Cells["Price"].Value);



        }

Posted 1-Oct-21 19:52pm

Ernest Jan Sandoval

Updated 2-Oct-21 4:25am

PIEBALDconsult

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)

RickZeeland · Answer 1 · 2021-10-01T20:19:00

Solution 1

Assuming you are using SQL Server, the recommended way is to use databinding.
Bind data to DataGridView Control - Windows Forms .NET Framework | Microsoft Docs[^]

SQL Server is not the easiest database to work with, if your needs are simple I would recommend LiteDB, see: best-databases-for-a-small-net-application[^]

Posted 1-Oct-21 20:19pm

RickZeeland

Updated 1-Oct-21 20:25pm

v2

Comments

Ernest Jan Sandoval 2-Oct-21 2:32am

Is there anayway i can contact you guys privately?i really need it now

RickZeeland 2-Oct-21 2:35am

Sorry, I'm too busy with work right now, maybe someone else can help you.
Besides I stopped using SQL Server years ago, did not like it at all :)

OriginalGriff · Answer 2 · 2021-10-01T20:26:00

To add to what Rick has said, you shouldn't use the displayed values anyway - they may not be accurate as they may have been rounded by the ToSstring operation. It's a much better idea to do this kind of calculation on the underlying DataTable (or collection) that holds the data that the DGV is displaying from. You can then databind that to the DB and things start to happen automatically.

But ... in this case, it's probably better not to do it at all, but to use a Computed Column in the DB instead: Specify Computed Columns in a Table - SQL Server | Microsoft Docs[^] That way, you don't take any extra space in yoru DB, and it is worked out for you when you fetch the data.