Updation query fails in using datagirdview of C# - plz help

See more:

Visual-Studio

C#4.0

Hi

I am using the following code in "Save" Button of my windows application
of c#. I am using dataGridview with defined columns to enter the data.
I am using for loop of datagirdview to insert and update the data into table.
I am able to insert the data using the insert command
but after editing the records in datagridview and after modify the rows,
this following code updates all the records of the table with only last row of the datagridview and there is no error message. plz help to solve this.

thanks and regards

Madhu


con.Open();

foreach (DataGridViewRow row in dataGridView1.Rows)
{
cmd = new SqlCommand("UPDATE ORDER_DETL SET PROD_DESC = @b,quality =@c,sizecd=@d
where order_no = @a", con);
{

try
{
cmd.Parameters.AddWithValue("@a", textBox1.Text);
cmd.Parameters.AddWithValue("@b", row.Cells["prod_desc"].Value);
cmd.Parameters.AddWithValue("@c", row.Cells["quality"].Value);
cmd.Parameters.AddWithValue("@d", row.Cells["sizecd"].Value);
cmd.ExecuteNonQuery();

}

catch (Exception ex)
{

}

}
}

MessageBox.Show("record updated");

What I have tried:

I assumed that it is not navigating between the rows of grid I tried the following.
But it is not working.

int currentRow = dataGridView1.SelectedRows[0].Index;
if (currentRow < dataGridView1.RowCount)
{
dataGridView1.Rows[++currentRow].Selected = true;
}