Insert all record from DataGridView to Sql Table C#

Assuming your DataGridView is not bound to the DB (or it would already contain rows in the database which you don't want to insert again) you would be best off using a loop:

using (SqlConnection con = new SqlConnection(connectionString))
    {
    using (SqlCommand cmd = new SqlCommand("INSERT INTO MyTable(Column1, Column2) VALUES (@C1, @C2)", con))
        {
        cmd.Parameters.Add(new SqlParameter("@C1", SqlDbType.VarChar));
        cmd.Parameters.Add(new SqlParameter("@C2", SqlDbType.VarChar));
        con.Open();
        foreach (DataGridViewRow row in myDataGridView.Rows)
            {
            if (!row.IsNewRow)
                {
                cmd.Parameters["@C1"].Value = row.Cells[0].Value;
                cmd.Parameters["@C2"].Value = row.Cells[1].Value;
                cmd.ExecuteNonQuery();
                }
            }
        }
    }

Hi,

Create an xml for the grid data and send the entire xml to the store procedure.

Inside the SP you can parse it and can insert records using one insert statement.

In this case you will call SP one time. You don't need to call SP multiple time.

Thanks :)

Your code works a 100% great, i modificate the code for use with stored procedure but it's the same look!

void insertardgv2()
    {
 
        SqlConnection con = 
        new SqlConnection("Server=mypc Database=AdventureWorks2012;Trusted_Connection=True;");

        SqlCommand cmd = new SqlCommand("insertardatos", con);
        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add(new SqlParameter("@C1", SqlDbType.NVarChar));
        cmd.Parameters.Add(new SqlParameter("@C2", SqlDbType.NVarChar));

        con.Open();

        foreach (DataGridViewRow row in dataGridView2.Rows)
            {
            if (!row.IsNewRow)
                {
                cmd.Parameters["@C1"].Value = row.Cells[0].Value;
                cmd.Parameters["@C2"].Value = row.Cells[1].Value;
                cmd.ExecuteNonQuery();
                }
            }
    }

and here are my stored procedure in sql

create procedure insertardatos
(
   @C1 nvarchar (40),
   @C2 nvarchar (40)
)

as

INSERT INTO Contacts(CompanyName, Phone) VALUES (@C1, @C2);

go

SqlConnection con = new SqlConnection(@"server=ADMIN-PC\NEERAJ;database=master;integrated security=true;");
SqlDataAdapter da=new SqlDataAdapter("select * from empdata",con);
DataSet ds=new DataSet();
da.Fill(ds);
grddata.DataSource=ds;
grddata.DataBind();

it will work for you