how to add more than one record adding in to database

Question

i tried below code.but i could add one row record only added in to mysql database. i entered three rows records but only one row records only added.what is the problem of the below code please any one can help me this problem.

 

 

for (int i = 0; i < dataGridView1.Rows.Count; i++)

{

MySqlCommand cmd = new MySqlCommand();

cmd.Connection = con;

cmd.CommandText = "insert into salesproductnew(salesid,productname,qty,price,grosstotal)values(@salesid,@productname,@qty,@price,@grosstotal)";

cmd.Parameters.AddWithValue("@salesid", lbinvoice.Text);

cmd.Parameters.AddWithValue("@productname", dataGridView1.Rows[i].Cells[2].Value);

cmd.Parameters.AddWithValue("@qty", dataGridView1.Rows[i].Cells[3].Value);

cmd.Parameters.AddWithValue("@price", dataGridView1.Rows[i].Cells[4].Value);

cmd.Parameters.AddWithValue("@grosstotal", dataGridView1.Rows[i].Cells[5].Value);

con.Open(); cmd.ExecuteNonQuery();

MessageBox.Show("Record added ............."); con.Close();