Save multiple value from datagridview to database

Question

3.00/5 (2 votes)

See more:

I have some rows in datagridview.

I want to save them together in database...

Please help me to do that
Thanks in Advance

Posted 28-Mar-14 18:20pm

nest101234

Add a Solution

Comments

[no name] 29-Mar-14 0:31am

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.

3 solutions

Solution 1

Here is sample code try this:

protected void savedatafromgv()
       {

           foreach (DataGridRows g1 in dg_AgentSFR.Rows)
            {

                SqlConnection con = new SqlConnection(strConnString);
                SqlCommand cmd = con.CreateCommand();
                cmd = new SqlCommand("INSERT INTO TB_TransAgenSeaFreightRate(POL,POD,FORWARDER,FORWARDER REFERENCE,SHIPPING LINE,CONTAINER TYPE,CONTAINER SIZE,VALIDITY FROM,VALIDITY TO,BASIC RATE,PAF,CAF,PSS,TOTAL AMOUNT,REE DAYS,CREDIT DAYS,NIT DEPOSIT,COMPANYID,ISACTIVE) values ('" + g1.Cells[0].Text + "','" + g1.Cells[1].Text + "','" + g1.Cells[2].Text + "','" + g1.Cells[3].Text + "','" + g1.Cells[4].Text + "','" + g1.Cells[5].Text + "','" + g1.Cells[6].Text + "','" + g1.Cells[7].Text + "','" + g1.Cells[8].Text + "','" + g1.Cells[9].Text + "','" + g1.Cells[10].Text + "','" + g1.Cells[11].Text + "','" + g1.Cells[12].Text + "','" + g1.Cells[13].Text + "','" + g1.Cells[14].Text + "','" + g1.Cells[15].Text + "','" + g1.Cells[16].Text + "',1,'" + TXTCompanyID.Text + "')", con);
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }

            Response.Write("Records inserted successfully");

       }

to avoid sql injection use "cmd.parameter.add .................."

Posted 28-Mar-14 18:23pm

Appdev(Icode)

v2

Solution 3

Refer

how to save datagridview multiple row in sql database[^]

Posted 28-Mar-14 18:30pm

Snehasish_Nandy

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)

Peter Leow · Accepted Answer · 2014-03-28T18:38:00

Solution 4

Refer: insert-all-data-of-a-datagridview-to-database-at-once[^]
However, you should change the sql code in the loop to Using Parameterized queries to prevent SQL Injection Attacks in SQL Server[^]

Posted 28-Mar-14 18:38pm

Peter Leow

Updated 28-Mar-14 18:42pm

v2