private static void UpdateDataAdapter() { Insert(); #region Config DataAdapater var comm = new DbCommandUtil("SELECT * FROM TEST"); const string insertSql = "INSERT INTO TEST(ID,VALUE) VALUES(@ID, @VALUES)"; comm.ChangeDataAdaterCommand(DataAdapterCommand.Insert, insertSql); comm.CreateParameter("@ID", DbType.Int32, "ID"); comm.CreateParameter("@VALUE", DbType.Decimal, 4, 2, "VALUE"); const string updateSql = "UPDATE TEST SET VALUE = @VALUE) WHERE ID=@ID"; comm.ChangeDataAdaterCommand(DataAdapterCommand.Update, updateSql); comm.CreateParameter("@ID", DbType.Int32, "ID"); comm.CreateParameter("@VALUE", DbType.Decimal, 4, 2, "VALUE"); const string deleteSql = "DELETE TEST WHERE ID=@ID"; comm.ChangeDataAdaterCommand(DataAdapterCommand.Delete, deleteSql); comm.CreateParameter("@ID", DbType.Int32, "ID"); #endregion Config DataAdapater var dt = comm.GetDataTable(); dt.Rows.Add(3, 100.1); dt.Rows[0].Delete(); dt.Rows[1]["VALUE"] = 100.2; comm.Update(dt); dt = comm.GetDataTable(); Assert.Equal(2, dt.Rows.Count); Assert.Equal(2, dt.Rows[0][0]); Assert.Equal(100.2, dt.Rows[0][1]); Assert.Equal(3, dt.Rows[1][0]); Assert.Equal(100.1, dt.Rows[1][1]); }