private void SaveUpdateMess() { foreach (DataGridViewRow row in dataGridView1.Rows) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DataConnectionString"].ConnectionString); string SaveUpdateBM = "if exists (Select * from BD where OrderNo = @OrderNo and BodyM = @BodyM) update BD set Mess = @Mess where OrderNo = @OrderNo and BodyM = @BodyM else begin insert into BD (OrderNo, BodyM, Mess) VALUES (@OrderNo, @BodyM, @Mess)"; using(SqlCommand cmd = new SqlCommand(SaveUpdateBM, con)) { con.Open(); cmd.Parameters.AddWithValue("@OrderNo", txtOrder_No.Text); cmd.Parameters.AddWithValue("@BodyM", row.Cells["BodyM"].Value); cmd.Parameters.AddWithValue("@Mess", row.Cells["Mess"].Value); cmd.ExecuteNonQuery(); con.Close(); } } }
begin
end
AddWithValue
cmd.Parameters.AddWithValue("@OrderNo", txtOrder_No.Text);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)