C#

public class TestPlugin : Plugin
{
    public override void Register(PluginManager manager)
    {
        manager.OnPacket<Packets.SomePacket> += new PacketEventHandler(manager_OnPacketSomePacket);
    }

    public void manager_OnPacketSomePacket(PluginManager manager, PacketEventArgs e)
    {

    }
}

SqlConnection conn = new SqlConnection();
        SqlDataAdapter sqlAdaptorSource;
        SqlDataAdapter sqlAdaptorTarget;
        SqlCommandBuilder sqlCommandSource;
        SqlCommandBuilder sqlCommandTarget;
        DataTable dtSource = new DataTable();
        DataTable dtTarget = new DataTable();
        DataTable dtBackup = new DataTable();

public void changeTables()
        {
            conn.ConnectionString = @"Data Source=" + System.Environment.MachineName + @"\SQLEXPRESS;Initial Catalog=Kafe;Integrated Security=SSPI;";
            conn.Open();

            sqlAdaptorSource = new SqlDataAdapter("Select * From Table1", conn);
            sqlAdaptorTarget = new SqlDataAdapter("Select * From Table2", conn);

            sqlCommandSource = new SqlCommandBuilder(sqlAdaptorSource);
            sqlCommandTarget = new SqlCommandBuilder(sqlAdaptorTarget);

            sqlAdaptorSource.Fill(dtSource);
            sqlAdaptorTarget.Fill(dtTarget);

            //Backup the target table first
            dtBackup = dtTarget;

            // Move the Source to Target
            dtTarget = dtSource;
            sqlAdaptorTarget.Update(dtTarget);

            //Then move the Target to Source
            dtSource = dtTarget;
            sqlAdaptorSource.Update(dtSource);

            //Dispose all
            dtSource.Clear();
            dtTarget.Clear();
            dtBackup.Clear();
            dtSource.Dispose();
            dtTarget.Dispose();
            dtBackup.Dispose();
            conn.Close();
            conn.Dispose();
        }