CREATE PROCEDURE EDIT_GOODS(
    EDITTYPE SMALLINT,
    GOODS_HIST_ID INTEGER,
    CATERER_NAME VARCHAR( 50 ),
    NAME VARCHAR( 40 ),
    COST DOUBLE PRECISION)
RETURNS (
    GOODS_HIST_PK INTEGER)
AS   
DECLARE VARIABLE GOODS_PK INTEGER;
begin
  if(EDITTYPE= 0 ) then /* 0-insert */
  begin
   GOODS_PK=GEN_ID(GEN_GOODS_ID, 1 );
   GOODS_HIST_PK=GEN_ID(GEN_GOODS_HIST_ID, 1 );
   insert into GOODS (GOODS_PK,GOODS_HIST_ID) values(:GOODS_PK,:GOODS_HIST_PK);
   insert into GOODS_HIST (GOODS_HIST_PK,GOODS_ID,CATERER_NAME,NAME,COST)
      values(:GOODS_HIST_PK,:GOODS_PK,:CATERER_NAME,:NAME,:COST);
  end
  else if(EDITTYPE= 1 ) then /* 1-edit */
  begin
    update GOODS_HIST set CATERER_NAME=:caterer_name,NAME=:name,COST=:cost
            where(GOODS_HIST_PK=:goods_hist_id);
    GOODS_HIST_PK=goods_hist_id;
  end  
  else if(EDITTYPE= 2 ) then /* 2-delet */
  begin                          
   select GOODS_ID from GOODS_HIST where(GOODS_HIST_PK=:goods_hist_id) into :goods_pk;
   delete from GOODS where(GOODS_PK=:goods_pk);
   goods_pk= 0 ;
   for select GOODS_ID from TRAFFIC where(GOODS_ID=:goods_hist_id) into :goods_pk do
   begin goods_pk= 1 ; break; end
   if (goods_pk= 0 ) then
    delete from GOODS_HIST where(GOODS_HIST_PK=:goods_hist_id);
  end
  suspend;
end

SprDA = new FirebirdSql.Data.FirebirdClient.FbDataAdapter();
...
SprDA.InsertCommand.CommandType = CommandType.Text;
SprDA.InsertCommand.CommandText = "EXECUTE PROCEDURE EDIT_GOODS(0,0,@CATERER_NAME,@NAME,@COST)";
SprDA.InsertCommand.Parameters.Clear();
FbParameter p = SprDA.UpdateCommand.Parameters.Add(new FbParameter("@GOODS_HIST_PK", FbDbType.Integer,  0 , "GOODS_HIST_PK"));
p.Direction = ParameterDirection.Output;
SprDA.InsertCommand.Parameters.Add(new FbParameter("@CATERER_NAME", FbDbType.VarChar,  50 , "CATERER_NAME"));
SprDA.InsertCommand.Parameters.Add(new FbParameter("@NAME", FbDbType.VarChar,  40 , "NAME"));
SprDA.InsertCommand.Parameters.Add(new FbParameter("@COST", FbDbType.Double,  0 , "COST"));

An attempt to execute an INSERT, UPDATE, or DELETE statement resulted in zero records affected.

protected override int Update(DataRow[] dataRows, DataTableMapping tableMapping)

int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected ==  0 )
{
  throw new DBConcurrencyException("An attempt to execute an INSERT, UPDATE, or DELETE statement resulted in zero records affected.");
}
updated++;
// и далее присвоение значений выходных параметров столбцам

dataSet1.Tables[ 0 ].RowDeleted += new DataRowChangeEventHandler(Row_Changed);
dataSet1.Tables[ 0 ].RowChanged += new DataRowChangeEventHandler(Row_Changed);
...........
        public void Row_Changed(Object sender, DataRowChangeEventArgs e)
        { 
            if(e.Action == DataRowAction.Add || e.Action == DataRowAction.Change ||
               e.Action == DataRowAction.Delete)
            try
            {
                if (!(e.Action == DataRowAction.Change && e.Row.RowState == DataRowState.Added))
                {
                    SprDA.Update(e.Row.Table);
                    e.Row.Table.AcceptChanges();
                }
            }
            catch (System.Data.DBConcurrencyException)
            {
            }
        }