using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; public class Form1 : System.Windows.Forms.Form { private System.Windows.Forms.RichTextBox rtfSql; private System.Windows.Forms.MainMenu mainMenu1; private System.Windows.Forms.MenuItem menuItem1; private System.Windows.Forms.MenuItem menuItemFormat; private System.Windows.Forms.MenuItem menuItem4; private System.Windows.Forms.MenuItem menuItemExit; private string[] mSqlKeyWords = new string[] {"select","from","where","in","between", "is","null","not","order by","asc","desc","insert","into","values","update", "set","delete","truncate","table","join","on","create","drop"}; public Form1() { InitializeComponent(); } private void InitializeComponent() { this.rtfSql = new System.Windows.Forms.RichTextBox(); this.mainMenu1 = new System.Windows.Forms.MainMenu(); this.menuItem1 = new System.Windows.Forms.MenuItem(); this.menuItemFormat = new System.Windows.Forms.MenuItem(); this.menuItem4 = new System.Windows.Forms.MenuItem(); this.menuItemExit = new System.Windows.Forms.MenuItem(); this.SuspendLayout(); // // rtfSql // this.rtfSql.Dock = System.Windows.Forms.DockStyle.Top; this.rtfSql.Font = new System.Drawing.Font("Courier New", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.rtfSql.Location = new System.Drawing.Point(0, 0); this.rtfSql.Name = "rtfSql"; this.rtfSql.Size = new System.Drawing.Size(290, 290); this.rtfSql.TabIndex = 0; this.rtfSql.Text = ""; // // mainMenu1 // this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { this.menuItem1}); // // menuItem1 // this.menuItem1.Index = 0; this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { this.menuItemFormat, this.menuItem4, this.menuItemExit}); this.menuItem1.Text = "&Actions"; // // menuItemFormat // this.menuItemFormat.Index = 0; this.menuItemFormat.Shortcut = System.Windows.Forms.Shortcut.F12; this.menuItemFormat.Text = "&Format statements"; this.menuItemFormat.Click += new System.EventHandler(this.menuItemFormat_Click); // // menuItem4 // this.menuItem4.Index = 1; this.menuItem4.Text = "-"; // // menuItemExit // this.menuItemExit.Index = 2; this.menuItemExit.Text = "E&xit"; this.menuItemExit.Click += new System.EventHandler(this.menuItemExit_Click); // // frmSql // this.AutoScaleBaseSize = new System.Drawing.Size(8, 15); this.ClientSize = new System.Drawing.Size(300, 300); this.Controls.Add(this.rtfSql); this.Font = new System.Drawing.Font("Courier New", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.Menu = this.mainMenu1; this.Name = "frmSql"; this.Text = "SQL Tool"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.ResumeLayout(false); } static void Main() { Application.Run(new Form1()); } private void menuItemFormat_Click(object sender, System.EventArgs e) { for (int i = 0; i < 23; i++) { int index = 0; while ( (index = rtfSql.Find(mSqlKeyWords[i],index,RichTextBoxFinds.WholeWord)) >= 0) { index++; rtfSql.SelectionColor = Color.Blue; rtfSql.SelectedText = mSqlKeyWords[i].ToUpper(); } } } private void menuItemExit_Click(object sender, System.EventArgs e) { Application.Exit(); } }