testform.cs

sqlce查询分析器

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace CEQuery
{
    public partial class TestForm : Form
    {
        private string[] keyWords = { "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "SELECT", "FROM", "WHERE", "GROUP", "ORDER", "BY", "INTO", "HAVING", "VALUES", "SET", "INNER", "LEFT", "RIGHT", "OUTER", "CROSS", "JOIN", "ON", "UNION", "IN", "AS", "AND", "OR", "DISTINCT" };

        public TestForm()
        {
            InitializeComponent();
        }

        private void TestForm_Load(object sender, EventArgs e)
        {
            
            foreach (string keyWord in keyWords)
            {
                syntaxRichTextBox1.Settings.Keywords.Add(keyWord);
            }
            syntaxRichTextBox1.Settings.KeywordColor = Color.Blue;
            syntaxRichTextBox1.CompileKeywords();
        }

        private void syntaxRichTextBox1_KeyUp(object sender, KeyEventArgs e)
        {
            //if (e.Control && e.KeyCode == Keys.V)
            //{
            //    syntaxRichTextBox1.Select(0, 0);
            //}
        }

        private void syntaxRichTextBox1_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (syntaxRichTextBox1.Tag != null && syntaxRichTextBox1.Tag.ToString() == "ReDo" && syntaxRichTextBox1.CanRedo)
            {
                syntaxRichTextBox1.Redo();
                syntaxRichTextBox1.Tag = null;
            }
        }

        private void syntaxRichTextBox1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.Control && e.KeyCode == Keys.V)
            {
                syntaxRichTextBox1.Tag = "start";
            }
            if (e.Control && e.KeyCode == Keys.Z)
            {
                syntaxRichTextBox1.Tag = "UnDo";
            }
            if (e.Control && e.KeyCode == Keys.Y)
            {
                syntaxRichTextBox1.Tag = "ReDo";
                //if (syntaxRichTextBox1.CanRedo)
                //{
                //    syntaxRichTextBox1.Redo();
                //}
            }
        }
    }
}