How do I Update multiple rows of Sql table using ado.net(c#)

See more:

C#

ADO.NET

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