private void button2_Click(object sender, EventArgs e) { var list = dataGridView1.DataSource as BindingList <BoardModel>; using (var db = new SqlDapperHelper()) { db.BeginTransaction(); try { foreach (var item in list) { switch (item.ChangedFlag) { case ChangedFlagEnum.Inserted: item.Insert(db); break; case ChangedFlagEnum.Updated: item.Update(db); break; } } db.Commit(); } catch (Exception ex) { db.Rollback(); MessageBox.Show(ex.Message); } } }