C#

Banjo Ayorinde wrote:

I need it because I want to be able to effect changes automatically in those tables based on change on one table.

finally
{
  if (sr != null)
    sr.Close();
  return retval;
}

// make sure this is pre-initialised<br />
StreamReader sr = null;<br />
<br />
try<br />
{<br />
  sr = new StreamReader(new FileStream(filename, FileMode.Open, FileAccess.Write));<br />
}<br />
catch(Exception ex)<br />
{<br />
  // do something with the exception<br />
}<br />
finally<br />
{<br />
  if(sr != null)<br />
    sr.Close();<br />
}

this._adapter.InsertCommand.CommandText = @"INSERT INTO [P_OrdiniRighe] ([IdOrdine], [CodiceArticoloInterno], [CodiceArticoloEsterno], [CodiceFinitura], [CodiceVariante], [Quantita], [DataConsegna], [QuantitaConsegnata], [UM], [Prezzo], [Note], [QuantitaImpegnata]) VALUES (@IdOrdine, @CodiceArticoloInterno, @CodiceArticoloEsterno, @CodiceFinitura, @CodiceVariante, @Quantita, @DataConsegna, @QuantitaConsegnata, @UM, @Prezzo, @Note, @QuantitaImpegnata);<br />
SELECT IdRigaOrdine, IdOrdine, CodiceArticoloInterno, CodiceArticoloEsterno, CodiceFinitura, CodiceVariante, Quantita, DataConsegna, QuantitaConsegnata, UM, Prezzo, Note, QuantitaImpegnata FROM P_OrdiniRighe WHERE (IdRigaOrdine = SCOPE_IDENTITY())";

this._adapter.UpdateCommand.CommandText = @"UPDATE [P_OrdiniRighe] SET [IdOrdine] = @IdOrdine, [CodiceArticoloInterno] = @CodiceArticoloInterno, [CodiceArticoloEsterno] = @CodiceArticoloEsterno, [CodiceFinitura] = @CodiceFinitura, [CodiceVariante] = @CodiceVariante, [Quantita] = @Quantita, [DataConsegna] = @DataConsegna, [QuantitaConsegnata] = @QuantitaConsegnata, [UM] = @UM, [Prezzo] = @Prezzo, [Note] = @Note, [QuantitaImpegnata] = @QuantitaImpegnata WHERE (([IdRigaOrdine] = @Original_IdRigaOrdine) AND ([IdOrdine] = @Original_IdOrdine) AND ([CodiceArticoloInterno] = @Original_CodiceArticoloInterno) AND ([CodiceArticoloEsterno] = @Original_CodiceArticoloEsterno) AND ([CodiceFinitura] = @Original_CodiceFinitura) AND ([CodiceVariante] = @Original_CodiceVariante) AND ([Quantita] = @Original_Quantita) AND ([DataConsegna] = @Original_DataConsegna) AND ([QuantitaConsegnata] = @Original_QuantitaConsegnata) AND ([UM] = @Original_UM) AND ([Prezzo] = @Original_Prezzo) AND ([Note] = @Original_Note) AND ([QuantitaImpegnata] = @Original_QuantitaImpegnata));<br />
SELECT IdRigaOrdine, IdOrdine, CodiceArticoloInterno, CodiceArticoloEsterno, CodiceFinitura, CodiceVariante, Quantita, DataConsegna, QuantitaConsegnata, UM, Prezzo, Note, QuantitaImpegnata FROM P_OrdiniRighe WHERE (IdRigaOrdine = @IdRigaOrdine)";

public static void UpdateParentChildObject(<br />
            DataTable oParentTable, DbDataAdapter oParentTableAdapter,<br />
            DataTable oChildTable, DbDataAdapter oChildTableAdapter)<br />
        {<br />
            // tabelle temporanee per le righe modificate delle tabelle child<br />
            DataTable tblChildDeleted = null;<br />
            DataTable tblChildAdded = null;<br />
            DataTable tblChildModified = null;<br />
            <br />
            try<br />
            {<br />
                // salvataggio in sequenza:<br />
                // 1) child eliminate<br />
                // 2) master<br />
                // 3) child aggiunte<br />
                // 4) child modificate<br />
                // ricavo le righe child eliminate<br />
                tblChildDeleted = oChildTable.GetChanges(DataRowState.Deleted);<br />
                if (tblChildDeleted != null)<br />
                    oChildTableAdapter.Update(tblChildDeleted);<br />
<br />
                oParentTableAdapter.Update(oParentTable);<br />
                oParentTable.AcceptChanges();<br />
<br />
                // ricavo le righe child aggiunte<br />
                tblChildAdded = oChildTable.GetChanges(DataRowState.Added);<br />
                if (tblChildAdded != null)<br />
                    oChildTableAdapter.Update(tblChildAdded);<br />
<br />
                // ricavo le righe child modificate<br />
                tblChildModified = oChildTable.GetChanges(DataRowState.Modified);<br />
                if (tblChildModified != null)<br />
                    oChildTableAdapter.Update(tblChildModified);<br />
<br />
                // modifche accettate<br />
                oChildTable.AcceptChanges();<br />
<br />
            }<br />
            finally<br />
            {<br />
                if (tblChildDeleted != null)<br />
                    tblChildDeleted.Dispose();<br />
<br />
                if (tblChildAdded != null)<br />
                    tblChildAdded.Dispose();<br />
<br />
                if (tblChildModified != null)<br />
                    tblChildModified.Dispose();<br />
            }<br />
        }

public string MyReplace(string original, string valueToReplace,  string replace)
{
  if (original.IsNullOrEmpty || replace.IsNullOrEmpty ||valueToReplace.IsNullOrEmpty)
    throw new Exception("One of the arguments is empty or null");
  return orignal.Replace(valueToReplace, replace);
}

<br />
string str = "aaabbb";<br />
string toReplace = "aaa";<br />
string replacement = "zzz";<br />
<br />
str = str.Replace(toReplace, replacement);