Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » SQL Server » Downloads
 
Add your own
alternative version

SQLite Compare Utility

, 6 Jul 2011 LGPL3
Utility for comparing two SQLite database files for both structure and data
SQLiteCompare.zip
SQLiteCompare
gplex.exe
gplexx.frame
gppg.exe
license.lic
log4net.dll
Puzzle.SyntaxBox.NET3.5.dll
ShiftReduceParser.dll
SQLiteTurboDiff.suo
System.Data.SQLite.dll
AutomaticUpdates
Properties
Be.Windows.Forms.HexBox
HexBox.bmp
HexBox.snk
Thumbs.db
Design
Common
Properties
CreateTestDatabases
Properties
TestSchemaFiles
DiffControl
Properties
FastGrid
Properties
Settings.settings
Liron.Windows.Forms
multipanel.ico
Thumbs.db
Design
Properties
Setup
appicon.ico
finish_banner.bmp
installer_banner.bmp
setup.nsi
Thumbs.db
uninstallicon.ico
SQLiteParser
sqlite.lex
sqlite.y
Properties
SQLiteTurbo
sqlite.syn
SQLiteTurbo.csproj.user
Properties
Settings.settings
Resources
feedback2.png
feedback_non_selected_idea.png
feedback_non_selected_question.png
feedback_pressed.png
feedback_problem_non_selected.png
feedback_problem_selected.png
feedback_selected_idea.png
feedback_selected_question.png
normal_feedback_button.png
pressed_feedback_button.png
SVG
about.svg
accept.svg
app.svg
appicon.svg
bug.svg
check_updates.svg
close_comparison.svg
company_tagline.svg
compare.svg
copy_from_left_db.svg
copy_from_right_db.svg
edit_selected_difference.svg
feather.svg
feedback.svg
feedback_frame.svg
feedback_non_selected_idea.svg
feedback_non_selected_problem.svg
feedback_question.svg
feedback_selected_problem.svg
feedback_selected_question.svg
finish_page_banner.svg
free.svg
generate_script_left_to_right.svg
generate_script_right_to_left.svg
greenpinesoftware_logo.svg
home_screenshot.svg
installer_banner.svg
key.svg
lamp.svg
lamp_non_selected.svg
lamp_selected.svg
lock.svg
main_screen.svg
next_diff.svg
prev_diff.svg
question.svg
recycle_bin.svg
redo.svg
reject.svg
reorder_columns.svg
save_schema.svg
search.svg
smallbug.svg
sqlite_compare_logo.svg
sqlite_feather.svg
text2451.png
undo.svg
uninstall.svg
v_bullet.svg
UndoRedo
Properties
SQLiteCompareSetup.zip
SQLiteCompareSetup.exe
SQLiteCompare_src.zip
gplex.exe
gplexx.frame
gppg.exe
license.lic
log4net.dll
Puzzle.SyntaxBox.NET3.5.dll
ShiftReduceParser.dll
SQLiteTurboDiff.suo
System.Data.SQLite.dll
HexBox.bmp
HexBox.snk
Thumbs.db
Settings.settings
multipanel.ico
Thumbs.db
appicon.ico
finish_banner.bmp
installer_banner.bmp
setup.nsi
Thumbs.db
uninstallicon.ico
sqlite.lex
sqlite.y
sqlite.syn
SQLiteTurbo.csproj.user
Settings.settings
feedback2.png
feedback_non_selected_idea.png
feedback_non_selected_question.png
feedback_pressed.png
feedback_problem_non_selected.png
feedback_problem_selected.png
feedback_selected_idea.png
feedback_selected_question.png
normal_feedback_button.png
pressed_feedback_button.png
about.svg
accept.svg
app.svg
appicon.svg
bug.svg
check_updates.svg
close_comparison.svg
company_tagline.svg
compare.svg
copy_from_left_db.svg
copy_from_right_db.svg
edit_selected_difference.svg
feather.svg
feedback.svg
feedback_frame.svg
feedback_non_selected_idea.svg
feedback_non_selected_problem.svg
feedback_question.svg
feedback_selected_problem.svg
feedback_selected_question.svg
finish_page_banner.svg
free.svg
generate_script_left_to_right.svg
generate_script_right_to_left.svg
greenpinesoftware_logo.svg
home_screenshot.svg
installer_banner.svg
key.svg
lamp.svg
lamp_non_selected.svg
lamp_selected.svg
lock.svg
main_screen.svg
next_diff.svg
prev_diff.svg
question.svg
recycle_bin.svg
redo.svg
reject.svg
reorder_columns.svg
save_schema.svg
search.svg
smallbug.svg
sqlite_compare_logo.svg
sqlite_feather.svg
text2451.png
undo.svg
uninstall.svg
v_bullet.svg
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;
using System.Windows.Forms;
using System.Drawing;
using System.Drawing.Drawing2D;
using FastGridApp;

namespace SQLiteTurbo
{
    /// <summary>
    /// This control displays a bar with hints where there are
    /// selected rows.
    /// </summary>
    public class SelectionBar : Control
    {
        #region Constructors
        public SelectionBar()
        {
            DoubleBuffered = true;
        }
        #endregion

        #region Public Properties
        [Browsable(false)]
        [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
        public long CursorOffset
        {
            get { return _cursorOffset; }
            set { _cursorOffset = value; Invalidate(); }
        }
        #endregion

        #region Public Methods
        /// <summary>
        /// Sets the data source for painting the selection portion
        /// </summary>
        /// <param name="max">The maximum row id</param>
        /// <param name="selection">The selection ranges to paint</param>
        public void SetData(long max, FastGridSelection selection)
        {
            _max = max;
            _selection = selection;
            Invalidate();
        }
        #endregion

        #region Protected Overrided Methods
        protected override void OnPaint(PaintEventArgs e)
        {
            base.OnPaint(e);

            Graphics g = e.Graphics;
            if (Width - 3 < 0)
                return;
            if (Height - 3 < 0)
                return;

            Rectangle border = new Rectangle(0, 0, Width - 1, Height - 1);
            using (Pen p = new Pen(this.ForeColor))
            {
                g.DrawRectangle(p, border);
            } // using

            Rectangle fill = new Rectangle(1, 1, Width - 3, Height - 3);
            using (SolidBrush b = new SolidBrush(this.BackColor))
            {
                g.FillRectangle(b, fill);
            } // using

            if (_max < 0 || _selection == null)
                return;

            // Draw selection ranges
            using (HatchBrush b = new HatchBrush(HatchStyle.ForwardDiagonal, SystemColors.Highlight, this.BackColor))
            {
                foreach (FastGridApp.SelectionRange range in _selection.SelectionRanges)
                {
                    int y1;
                    int y2;
                    if (range.StartRowId == 0 && range.EndRowId == 0 && _max == 0)
                    {
                        y1 = 1;
                        y2 = Height - 2;
                    }
                    else if (_max > 0)
                    {
                        y1 = TranslateOffsetToYPos(range.StartRowId);
                        y2 = TranslateOffsetToYPos(range.EndRowId);
                    }
                    else
                        continue;
                    g.FillRectangle(b, 1, y1, Width - 2, y2 - y1 + 1);
                } // foreach
            } // using

            // Draw the cursor line
            int ypos;
            if (_max == 0)
                ypos = 1;
            else
                ypos = TranslateOffsetToYPos(_cursorOffset);
            if (ypos < 0)
                return;
            using (Pen p = new Pen(this.ForeColor, 3))
            {
                p.StartCap = LineCap.ArrowAnchor;
                p.EndCap = LineCap.ArrowAnchor;
                g.DrawLine(p, 1, ypos, Width - 1, ypos);
            }
        }
        #endregion

        #region Private Methods
        private int TranslateOffsetToYPos(long offset)
        {
            int ypos = (int)(1.0 * offset / _max * (Height - 3)) + 1;
            return ypos;
        }
        #endregion

        #region Private Variables
        private long _max;
        private long _cursorOffset;
        private FastGridSelection _selection;
        #endregion
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The GNU Lesser General Public License (LGPLv3)

Share

About the Author

liron.levi
Software Developer Arineta Cardio Imaging
Israel Israel
My name is Liron Levi and I'm developing software for fun & profit for 15 years already. I'm now working for Arineta Cardio Imaging as a software developer (the company develops a CT machine).
 
I can be contacted directly at liron.levi@outlook.com or via linkedin at http://www.linkedin.com/pub/liron-levy/1/578/ab5

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.1411022.1 | Last Updated 6 Jul 2011
Article Copyright 2011 by liron.levi
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid