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);
}
}
}
