如何使用ado.net更新多行Sql表（c＃）

问题描述

有一个DatagridView。该场景是当我更改某些行的值并单击SaveButton时，数据库中的表将被更新。为此，我创建了一个对象列表并将所有DGV行放入此list（DGV的每一行都映射到一个对象）。然后在foreach循环中我读取这个列表并更新数据库中相关的表行。我知道这种方式性能较差，因为它多次连接到db。有没有办法轻松更新或插入多行？

there is a DatagridView.the scenario is when I change the value of some rows and click on SaveButton, the table in database will be updated.For doing this,I made a list of objects and put all rows of DGV into this list(every row of DGV is mapped to One object). then in a foreach loop I read this list and update the related row of table in database.I know this way has less performance because it connect to db multiple times.Is there any way to Update or insert multiple rows easily?

List<Person> lst = PutRowsOfDGVIntoList();
if (lst != null && lst.Count != 0)
{

    foreach (var person in lst)
    {
      if (!pda.ifExistPerson())//if current row don't exist in Db insert new person else update
      {
         if (!pda.InsertPerson(person))//insert
          throw new Exception();

      }
      else
      {
         if (!pda.UpdatePerson(person))//update
                    throw new Exception();
      }
   }
}

推荐答案

这篇关于如何使用ado.net更新多行Sql表（c＃）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！