Saving a Datagridview into SQL Table

See more:

C#

SQL

Hi,

Can someone please help me to save
all the datagridview rows into a SQL table.

I tried saving it using a for loop, but it only
saves the first rows. If I insert more than one
row it simply doesn't save it.

This is what I have tried:

private void SavedataGridTable()
        {
            ConnLibrary conn = new ConnLibrary();

            using (SqlCommand sqlcomm = new SqlCommand())
            {
                for (int i = 0; i < dgrLoadGrid.Rows.Count - 1; i++)
                {

                    strNameS = dgrLoadGrid[0, i].Value.ToString();
                    intPrice = Convert.ToInt32(dgrLoadGrid[1, i].Value);
                    intQuantity = Convert.ToInt32(dgrLoadGrid[2, i].Value);
                    dteNow = dateTimePicker1.Value;



                    sqlcomm.Connection = conn.Connection;
                    sqlcomm.CommandType = CommandType.StoredProcedure;
                    sqlcomm.CommandText = "usp_SaveSale";

                    sqlcomm.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value = strNameS;
                    sqlcomm.Parameters.Add("@Price", SqlDbType.Int).Value = intPrice;
                    sqlcomm.Parameters.Add("@Quantity", SqlDbType.Int).Value = intQuantity;
                    sqlcomm.Parameters.Add("@Date", SqlDbType.Date).Value = dteNow;
                    sqlcomm.ExecuteNonQuery();
                    MessageBox.Show("Sale Done");
                }
            }
        }