i have gridview that i display details for PK in another table data after i display many row i insert it in table ,how i update this data when i change something :-
i used 2 update query first update for tha mean table and second update for this datagridview .
private void btn_Edit_Click(object sender, EventArgs e)
{con.Open();
sd = new SqlCommand("update Auto_Parts set Change_date = @Change_date, Current_dist = @Current_dist, Prev_dist = @Prev_dist, Driver_ID = @Driver_ID where Auto_Parts.Car_id = @Car_id and Auto_Parts.Job_Card = @Job_Card ; update Auto_Part_Details set Value_Part = @Value_Part, Auto_Parts_id = @Auto_Parts_id, Repair_id = @Repair_id, New_Old_Part = @New_Old_Part, Provider_id = @Provider_id, Installation_id = @Installation_id, Notes = @Notes where Auto_Part_Details.Job_Card = @Job_Card ", con);
sd.Parameters.AddWithValue("@Car_id", Convert.ToInt32(txt_Car_id.Text));
sd.Parameters.AddWithValue("@Job_Card", txt_Job_card.Text);
sd.Parameters.AddWithValue("@Change_date", dtp_Change_date.Text);
sd.Parameters.AddWithValue("@Current_dist", txt_Current_dist.Text);
sd.Parameters.AddWithValue("@Prev_dist", txt_Prev_dist.Text);
sd.Parameters.AddWithValue("@Driver_ID", Convert.ToInt32(CB_Driver_name.SelectedValue));
sd.Parameters.AddWithValue("@Notes", txt_Notes.Text);
for (int i = 0; i < dgv_Add_job_card.Rows.Count; i++)
{
sd.Parameters.AddWithValue("@Items_No", dgv_Add_job_card.Rows[i].Cells[0].Value);
sd.Parameters.AddWithValue("@Job_Card", dgv_Add_job_card.Rows[i].Cells[1].Value);
sd.Parameters.AddWithValue("@Value_Part", dgv_Add_job_card.Rows[i].Cells[2].Value);
sd.Parameters.AddWithValue("@New_Old_Part", dgv_Add_job_card.Rows[i].Cells[5].Value);
sd.Parameters.AddWithValue("@Notes", dgv_Add_job_card.Rows[i].Cells[8].Value);
sd.Parameters.AddWithValue("@Auto_Parts_id", dgv_Add_job_card.Rows[i].Cells[9].Value);
sd.Parameters.AddWithValue("@Repair_id", dgv_Add_job_card.Rows[i].Cells[10].Value);
sd.Parameters.AddWithValue("@Provider_id", dgv_Add_job_card.Rows[i].Cells[11].Value);
sd.Parameters.AddWithValue("@Installation_id", dgv_Add_job_card.Rows[i].Cells[12].Value);
}
}