spieleprogrammierer.de - Forum und Wiki zur Spieleprogrammierung und Spieleentwicklung

C#-Quelltext

StringBuilder sb = new StringBuilder();
sb.Append( "BEGIN TRANSACTION;" );
sb.Append( "DELETE FROM Tabelle;" );
foreach( ... )
{
   sb.Append( "INSERT INTO Tabelle ...;" );
}
sb.Append( "COMMIT;" );

using( DbCommand cmd = connection.CreateCommand() )
{
   cmd.CommandText = sb.ToString();
   cmd.ExecuteNonQuery();
}

Quellcode

BEGIN TRANSACTION;
DELETE FROM Speedy_Files;
INSERT INTO Speedy_Files (Command, Name, [Type], Icon, Arguments) VALUES ( 'c:\windows\system32\control.exe', 'Default Programs', 'exe', 'C:\Windows\system32\imageres.dll,-24', '/name Microsoft.DefaultPrograms' );
 INSERT INTO Speedy_Files (Command, Name, [Type], Icon, Arguments) VALUES  ( 'c:\windows\system32\wuapp.exe', 'Windows Update', 'exe', 'C:\Windows\system32\wucltux.dll,0', 'startmenu' ); 
 INSERT INTO Speedy_Files (Command, Name, [Type], Icon, Arguments) VALUES ( 'c:\program files (x86)\utorrent\utorrent.exe', 'µTorrent', 'exe', 'c:\program files (x86)\utorrent\utorrent.exe,0', '' );
 INSERT INTO Speedy_Files (Command, Name, [Type], Icon, Arguments) VALUES  ( 'c:\program files (x86)\freemind\freemind.exe', 'FreeMind', 'exe', 'C:\Program Files (x86)\FreeMind\Freemind.exe,0', '' );
COMMIT;