DataTable删除行却更新不了数据库

DataTable table = ……;  //获取已有的DataTable变量，具体方法的就省略了  



DataRow found = FindRowByID(rowID); //定位其中一行

   

table.Rows.Remove(found);//删除改行



using (SqlConnection connection = new SqlConnection("……"))

 {

          connection.Open();

          SqlDataAdapter dataAdpater = new SqlDataAdapter("select * from [dbo].[Gatway]", connection);

          SqlCommandBuilder sqlBuilder = new SqlCommandBuilder(dataAdpater);

          dataAdpater.UpdateCommand = sqlBuilder.GetUpdateCommand();

          dataAdpater.Update(table);

          

          connection.Close();

}              

table.Rows[rowIndex].Delete();