Multiple data insertion into database from grid view
<p>I already have some data into the grid view. Now I want to insert multiple rows into gridview then how to do it?</p>

<p>If I go for foreach loop then it will take count of all the rows already there and insert the data multiple times. Instead I want to into new rows only</p>

<p>Below is my Code</p>

<pre><code>    private void userInsert()
    {
        if (MessageBox.Show("Do you want to add the new  data ?", "Confirm ", MessageBoxButtons.YesNo,MessageBoxIcon.Question) == DialogResult.Yes)
        {
            cmd.Connection = con;
            cmd.CommandType = CommandType.Text;
            try
            {

                foreach (GridViewRow dRow in userDataGridView.Rows)
                {
                    cmd.CommandText = string.Format("insert into users(first_name,last_name,default_rate,default_location,spi_user_id,nickname) values('{0}','{1}',{2},{3},{4},'{5}')", userDataGridView.CurrentRow.Cells[0].Value.ToString(), userDataGridView.CurrentRow.Cells[1].Value.ToString(), userDataGridView.CurrentRow.Cells[2].Value.ToString(), locationID2ComboBox.SelectedValue, userDataGridView.CurrentRow.Cells[4].Value.ToString(), userDataGridView.CurrentRow.Cells[5].Value.ToString());
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
                MessageBox.Show("Your data has been added successfully ", "Saved info", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
                userSelect();
            }
        }
    }
</code></pre>
