Click here to Skip to main content
15,883,749 members
Articles / Programming Languages / C#

The Grid Processor: Word Processing Abilities for the .NET DataGridView Component

Rate me:
Please Sign up or sign in to vote.
4.87/5 (15 votes)
7 May 200711 min read 65.6K   1.6K   51  
A plugin which offers search and replace, casing and other capabilities for the Microsoft .NET DataGridView component
#region GNU notice
// GridProcessor - Search and replace abilities for the .NET DataGridView
// Copyright (C) 2007, by Evan Stein
//
// This library is free software; you can redistribute it and/or
// modify it under the terms of the GNU Lesser General Public
// License as published by the Free Software Foundation; either
// version 2.1 of the License, or (at your option) any later version.
// 
// This library is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
// Lesser General Public License for more details.

// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
//
#endregion GNU notice
namespace GridProcessor
{
    partial class FormEditMacro
    {
        /// <summary>
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Windows Form Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.components = new System.ComponentModel.Container();
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormEditMacro));
            this.dataGridView_existing = new System.Windows.Forms.DataGridView();
            this.replacementIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.colGridProcessTypeID = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.nameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.colTypeAbbreviation = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.descriptionDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.searchExprDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.replaceExprDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.useRegexDataGridViewCheckBoxColumn = new System.Windows.Forms.DataGridViewCheckBoxColumn();
            this.bindingSource_replacement = new System.Windows.Forms.BindingSource(this.components);
            this.dataSet_replacement1 = new GridProcessor.DataSetGridProcess();
            this.dataGridView_chosen = new System.Windows.Forms.DataGridView();
            this.replacementIDDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.replacementTypeIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.nameDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.descriptionDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.useRegexDataGridViewCheckBoxColumn1 = new System.Windows.Forms.DataGridViewCheckBoxColumn();
            this.toUpperDataGridViewCheckBoxColumn = new System.Windows.Forms.DataGridViewCheckBoxColumn();
            this.bindingSource_chosenReplacement = new System.Windows.Forms.BindingSource(this.components);
            this.dataSet_chosenReplacement = new GridProcessor.DataSetGridProcess();
            this.button_add = new System.Windows.Forms.Button();
            this.button_remove = new System.Windows.Forms.Button();
            this.label1 = new System.Windows.Forms.Label();
            this.label2 = new System.Windows.Forms.Label();
            this.button_up = new System.Windows.Forms.Button();
            this.button_down = new System.Windows.Forms.Button();
            this.label4 = new System.Windows.Forms.Label();
            this.textBox_description = new System.Windows.Forms.TextBox();
            this.groupBox2 = new System.Windows.Forms.GroupBox();
            this.textBox_name = new System.Windows.Forms.TextBox();
            this.label3 = new System.Windows.Forms.Label();
            this.dataSet_macro1 = new GridProcessor.DataSet_macro();
            this.groupBox1 = new System.Windows.Forms.GroupBox();
            this.button_ok = new System.Windows.Forms.Button();
            this.button_cancel = new System.Windows.Forms.Button();
            this.dataSet_macroReplacement1 = new GridProcessor.DataSet_macroGridProcess();
            this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
            this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
            this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
            this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
            this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
            this.oleDbDataAdapter_macro = new System.Data.OleDb.OleDbDataAdapter();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView_existing)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.bindingSource_replacement)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet_replacement1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView_chosen)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.bindingSource_chosenReplacement)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet_chosenReplacement)).BeginInit();
            this.groupBox2.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet_macro1)).BeginInit();
            this.groupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet_macroReplacement1)).BeginInit();
            this.SuspendLayout();
            // 
            // dataGridView_existing
            // 
            this.dataGridView_existing.AllowUserToAddRows = false;
            this.dataGridView_existing.AllowUserToDeleteRows = false;
            this.dataGridView_existing.AllowUserToResizeRows = false;
            this.dataGridView_existing.AutoGenerateColumns = false;
            this.dataGridView_existing.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView_existing.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
            this.replacementIDDataGridViewTextBoxColumn,
            this.colGridProcessTypeID,
            this.nameDataGridViewTextBoxColumn,
            this.colTypeAbbreviation,
            this.descriptionDataGridViewTextBoxColumn,
            this.searchExprDataGridViewTextBoxColumn,
            this.replaceExprDataGridViewTextBoxColumn,
            this.useRegexDataGridViewCheckBoxColumn});
            this.dataGridView_existing.DataSource = this.bindingSource_replacement;
            this.dataGridView_existing.Location = new System.Drawing.Point(6, 42);
            this.dataGridView_existing.MultiSelect = false;
            this.dataGridView_existing.Name = "dataGridView_existing";
            this.dataGridView_existing.ReadOnly = true;
            this.dataGridView_existing.RowHeadersVisible = false;
            this.dataGridView_existing.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
            this.dataGridView_existing.Size = new System.Drawing.Size(355, 219);
            this.dataGridView_existing.TabIndex = 0;
            this.dataGridView_existing.CellFormatting += new System.Windows.Forms.DataGridViewCellFormattingEventHandler(this.dataGridView_existing_CellFormatting);
            this.dataGridView_existing.DoubleClick += new System.EventHandler(this.dataGridView_existing_DoubleClick);
            // 
            // replacementIDDataGridViewTextBoxColumn
            // 
            this.replacementIDDataGridViewTextBoxColumn.DataPropertyName = "GridProcessID";
            this.replacementIDDataGridViewTextBoxColumn.HeaderText = "GridProcessID";
            this.replacementIDDataGridViewTextBoxColumn.Name = "replacementIDDataGridViewTextBoxColumn";
            this.replacementIDDataGridViewTextBoxColumn.ReadOnly = true;
            this.replacementIDDataGridViewTextBoxColumn.Visible = false;
            // 
            // colGridProcessTypeID
            // 
            this.colGridProcessTypeID.DataPropertyName = "GridProcessTypeID";
            this.colGridProcessTypeID.HeaderText = "GridProcessTypeID";
            this.colGridProcessTypeID.Name = "colGridProcessTypeID";
            this.colGridProcessTypeID.ReadOnly = true;
            this.colGridProcessTypeID.Visible = false;
            // 
            // nameDataGridViewTextBoxColumn
            // 
            this.nameDataGridViewTextBoxColumn.DataPropertyName = "Name";
            this.nameDataGridViewTextBoxColumn.HeaderText = "Name";
            this.nameDataGridViewTextBoxColumn.Name = "nameDataGridViewTextBoxColumn";
            this.nameDataGridViewTextBoxColumn.ReadOnly = true;
            this.nameDataGridViewTextBoxColumn.Width = 125;
            // 
            // colTypeAbbreviation
            // 
            this.colTypeAbbreviation.HeaderText = "Type";
            this.colTypeAbbreviation.Name = "colTypeAbbreviation";
            this.colTypeAbbreviation.ReadOnly = true;
            this.colTypeAbbreviation.Width = 40;
            // 
            // descriptionDataGridViewTextBoxColumn
            // 
            this.descriptionDataGridViewTextBoxColumn.DataPropertyName = "Description";
            this.descriptionDataGridViewTextBoxColumn.HeaderText = "Description";
            this.descriptionDataGridViewTextBoxColumn.Name = "descriptionDataGridViewTextBoxColumn";
            this.descriptionDataGridViewTextBoxColumn.ReadOnly = true;
            this.descriptionDataGridViewTextBoxColumn.Width = 180;
            // 
            // searchExprDataGridViewTextBoxColumn
            // 
            this.searchExprDataGridViewTextBoxColumn.DataPropertyName = "SearchExpression";
            this.searchExprDataGridViewTextBoxColumn.HeaderText = "SearchExpr";
            this.searchExprDataGridViewTextBoxColumn.Name = "searchExprDataGridViewTextBoxColumn";
            this.searchExprDataGridViewTextBoxColumn.ReadOnly = true;
            this.searchExprDataGridViewTextBoxColumn.Visible = false;
            // 
            // replaceExprDataGridViewTextBoxColumn
            // 
            this.replaceExprDataGridViewTextBoxColumn.DataPropertyName = "ReplaceExpression";
            this.replaceExprDataGridViewTextBoxColumn.HeaderText = "ReplaceExpr";
            this.replaceExprDataGridViewTextBoxColumn.Name = "replaceExprDataGridViewTextBoxColumn";
            this.replaceExprDataGridViewTextBoxColumn.ReadOnly = true;
            this.replaceExprDataGridViewTextBoxColumn.Visible = false;
            // 
            // useRegexDataGridViewCheckBoxColumn
            // 
            this.useRegexDataGridViewCheckBoxColumn.DataPropertyName = "UseRegex";
            this.useRegexDataGridViewCheckBoxColumn.HeaderText = "UseRegex";
            this.useRegexDataGridViewCheckBoxColumn.Name = "useRegexDataGridViewCheckBoxColumn";
            this.useRegexDataGridViewCheckBoxColumn.ReadOnly = true;
            this.useRegexDataGridViewCheckBoxColumn.Visible = false;
            // 
            // bindingSource_replacement
            // 
            this.bindingSource_replacement.DataMember = "GridProcess";
            this.bindingSource_replacement.DataSource = this.dataSet_replacement1;
            // 
            // dataSet_replacement1
            // 
            this.dataSet_replacement1.DataSetName = "DataSet_replacement";
            this.dataSet_replacement1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
            // 
            // dataGridView_chosen
            // 
            this.dataGridView_chosen.AllowUserToAddRows = false;
            this.dataGridView_chosen.AllowUserToDeleteRows = false;
            this.dataGridView_chosen.AllowUserToResizeRows = false;
            this.dataGridView_chosen.AutoGenerateColumns = false;
            this.dataGridView_chosen.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView_chosen.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
            this.replacementIDDataGridViewTextBoxColumn1,
            this.replacementTypeIDDataGridViewTextBoxColumn,
            this.nameDataGridViewTextBoxColumn1,
            this.descriptionDataGridViewTextBoxColumn1,
            this.useRegexDataGridViewCheckBoxColumn1,
            this.toUpperDataGridViewCheckBoxColumn});
            this.dataGridView_chosen.DataSource = this.bindingSource_chosenReplacement;
            this.dataGridView_chosen.Location = new System.Drawing.Point(409, 42);
            this.dataGridView_chosen.MultiSelect = false;
            this.dataGridView_chosen.Name = "dataGridView_chosen";
            this.dataGridView_chosen.ReadOnly = true;
            this.dataGridView_chosen.RowHeadersVisible = false;
            this.dataGridView_chosen.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
            this.dataGridView_chosen.Size = new System.Drawing.Size(132, 219);
            this.dataGridView_chosen.TabIndex = 0;
            // 
            // replacementIDDataGridViewTextBoxColumn1
            // 
            this.replacementIDDataGridViewTextBoxColumn1.DataPropertyName = "GridProcessID";
            this.replacementIDDataGridViewTextBoxColumn1.HeaderText = "GridProcessID";
            this.replacementIDDataGridViewTextBoxColumn1.Name = "replacementIDDataGridViewTextBoxColumn1";
            this.replacementIDDataGridViewTextBoxColumn1.ReadOnly = true;
            this.replacementIDDataGridViewTextBoxColumn1.Visible = false;
            // 
            // replacementTypeIDDataGridViewTextBoxColumn
            // 
            this.replacementTypeIDDataGridViewTextBoxColumn.DataPropertyName = "GridProcessTypeID";
            this.replacementTypeIDDataGridViewTextBoxColumn.HeaderText = "GridProcessTypeID";
            this.replacementTypeIDDataGridViewTextBoxColumn.Name = "replacementTypeIDDataGridViewTextBoxColumn";
            this.replacementTypeIDDataGridViewTextBoxColumn.ReadOnly = true;
            this.replacementTypeIDDataGridViewTextBoxColumn.Visible = false;
            // 
            // nameDataGridViewTextBoxColumn1
            // 
            this.nameDataGridViewTextBoxColumn1.DataPropertyName = "Name";
            this.nameDataGridViewTextBoxColumn1.HeaderText = "Name";
            this.nameDataGridViewTextBoxColumn1.Name = "nameDataGridViewTextBoxColumn1";
            this.nameDataGridViewTextBoxColumn1.ReadOnly = true;
            this.nameDataGridViewTextBoxColumn1.Width = 120;
            // 
            // descriptionDataGridViewTextBoxColumn1
            // 
            this.descriptionDataGridViewTextBoxColumn1.DataPropertyName = "Description";
            this.descriptionDataGridViewTextBoxColumn1.HeaderText = "Description";
            this.descriptionDataGridViewTextBoxColumn1.Name = "descriptionDataGridViewTextBoxColumn1";
            this.descriptionDataGridViewTextBoxColumn1.ReadOnly = true;
            this.descriptionDataGridViewTextBoxColumn1.Visible = false;
            // 
            // useRegexDataGridViewCheckBoxColumn1
            // 
            this.useRegexDataGridViewCheckBoxColumn1.DataPropertyName = "UseRegex";
            this.useRegexDataGridViewCheckBoxColumn1.HeaderText = "UseRegex";
            this.useRegexDataGridViewCheckBoxColumn1.Name = "useRegexDataGridViewCheckBoxColumn1";
            this.useRegexDataGridViewCheckBoxColumn1.ReadOnly = true;
            this.useRegexDataGridViewCheckBoxColumn1.Visible = false;
            // 
            // toUpperDataGridViewCheckBoxColumn
            // 
            this.toUpperDataGridViewCheckBoxColumn.DataPropertyName = "ToUpper";
            this.toUpperDataGridViewCheckBoxColumn.HeaderText = "ToUpper";
            this.toUpperDataGridViewCheckBoxColumn.Name = "toUpperDataGridViewCheckBoxColumn";
            this.toUpperDataGridViewCheckBoxColumn.ReadOnly = true;
            this.toUpperDataGridViewCheckBoxColumn.Visible = false;
            // 
            // bindingSource_chosenReplacement
            // 
            this.bindingSource_chosenReplacement.DataMember = "GridProcess";
            this.bindingSource_chosenReplacement.DataSource = this.dataSet_chosenReplacement;
            // 
            // dataSet_chosenReplacement
            // 
            this.dataSet_chosenReplacement.DataSetName = "DataSetReplacement";
            this.dataSet_chosenReplacement.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
            // 
            // button_add
            // 
            this.button_add.Location = new System.Drawing.Point(369, 106);
            this.button_add.Name = "button_add";
            this.button_add.Size = new System.Drawing.Size(32, 23);
            this.button_add.TabIndex = 30;
            this.button_add.Text = ">";
            this.button_add.UseVisualStyleBackColor = true;
            this.button_add.Click += new System.EventHandler(this.button_add_Click);
            // 
            // button_remove
            // 
            this.button_remove.Location = new System.Drawing.Point(369, 135);
            this.button_remove.Name = "button_remove";
            this.button_remove.Size = new System.Drawing.Size(31, 23);
            this.button_remove.TabIndex = 40;
            this.button_remove.Text = "<";
            this.button_remove.UseVisualStyleBackColor = true;
            this.button_remove.Click += new System.EventHandler(this.button_remove_Click);
            // 
            // label1
            // 
            this.label1.AutoSize = true;
            this.label1.Location = new System.Drawing.Point(7, 24);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(104, 13);
            this.label1.TabIndex = 4;
            this.label1.Text = "Available Operations";
            // 
            // label2
            // 
            this.label2.AutoSize = true;
            this.label2.Location = new System.Drawing.Point(411, 24);
            this.label2.Name = "label2";
            this.label2.Size = new System.Drawing.Size(71, 13);
            this.label2.TabIndex = 5;
            this.label2.Text = "Chosen Items";
            // 
            // button_up
            // 
            this.button_up.Image = ((System.Drawing.Image)(resources.GetObject("button_up.Image")));
            this.button_up.Location = new System.Drawing.Point(551, 106);
            this.button_up.Name = "button_up";
            this.button_up.Size = new System.Drawing.Size(24, 23);
            this.button_up.TabIndex = 50;
            this.button_up.UseVisualStyleBackColor = true;
            this.button_up.Click += new System.EventHandler(this.button_up_Click);
            // 
            // button_down
            // 
            this.button_down.Image = ((System.Drawing.Image)(resources.GetObject("button_down.Image")));
            this.button_down.Location = new System.Drawing.Point(551, 135);
            this.button_down.Name = "button_down";
            this.button_down.Size = new System.Drawing.Size(24, 23);
            this.button_down.TabIndex = 60;
            this.button_down.UseVisualStyleBackColor = true;
            this.button_down.Click += new System.EventHandler(this.button_down_Click);
            // 
            // label4
            // 
            this.label4.ImageAlign = System.Drawing.ContentAlignment.MiddleRight;
            this.label4.Location = new System.Drawing.Point(254, 21);
            this.label4.Name = "label4";
            this.label4.Size = new System.Drawing.Size(72, 23);
            this.label4.TabIndex = 12;
            this.label4.Text = "Description";
            this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
            // 
            // textBox_description
            // 
            this.textBox_description.Location = new System.Drawing.Point(332, 19);
            this.textBox_description.MaxLength = 150;
            this.textBox_description.Multiline = true;
            this.textBox_description.Name = "textBox_description";
            this.textBox_description.Size = new System.Drawing.Size(221, 40);
            this.textBox_description.TabIndex = 20;
            this.textBox_description.TextChanged += new System.EventHandler(this.textBox_description_TextChanged);
            // 
            // groupBox2
            // 
            this.groupBox2.Controls.Add(this.textBox_name);
            this.groupBox2.Controls.Add(this.label4);
            this.groupBox2.Controls.Add(this.label3);
            this.groupBox2.Controls.Add(this.textBox_description);
            this.groupBox2.Location = new System.Drawing.Point(12, 12);
            this.groupBox2.Name = "groupBox2";
            this.groupBox2.Size = new System.Drawing.Size(585, 72);
            this.groupBox2.TabIndex = 17;
            this.groupBox2.TabStop = false;
            this.groupBox2.Text = "Basics";
            // 
            // textBox_name
            // 
            this.textBox_name.Location = new System.Drawing.Point(55, 23);
            this.textBox_name.Name = "textBox_name";
            this.textBox_name.Size = new System.Drawing.Size(193, 20);
            this.textBox_name.TabIndex = 10;
            // 
            // label3
            // 
            this.label3.ImageAlign = System.Drawing.ContentAlignment.MiddleRight;
            this.label3.Location = new System.Drawing.Point(5, 21);
            this.label3.Name = "label3";
            this.label3.Size = new System.Drawing.Size(44, 23);
            this.label3.TabIndex = 11;
            this.label3.Text = "Name";
            this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
            // 
            // dataSet_macro1
            // 
            this.dataSet_macro1.DataSetName = "DataSet_macro";
            this.dataSet_macro1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
            // 
            // groupBox1
            // 
            this.groupBox1.Controls.Add(this.button_down);
            this.groupBox1.Controls.Add(this.button_up);
            this.groupBox1.Controls.Add(this.label2);
            this.groupBox1.Controls.Add(this.label1);
            this.groupBox1.Controls.Add(this.button_remove);
            this.groupBox1.Controls.Add(this.button_add);
            this.groupBox1.Controls.Add(this.dataGridView_chosen);
            this.groupBox1.Controls.Add(this.dataGridView_existing);
            this.groupBox1.Location = new System.Drawing.Point(12, 90);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Size = new System.Drawing.Size(585, 281);
            this.groupBox1.TabIndex = 18;
            this.groupBox1.TabStop = false;
            this.groupBox1.Text = "Content";
            // 
            // button_ok
            // 
            this.button_ok.Enabled = false;
            this.button_ok.Location = new System.Drawing.Point(211, 386);
            this.button_ok.Name = "button_ok";
            this.button_ok.Size = new System.Drawing.Size(75, 23);
            this.button_ok.TabIndex = 70;
            this.button_ok.Text = "OK";
            this.button_ok.UseVisualStyleBackColor = true;
            this.button_ok.Click += new System.EventHandler(this.button_ok_Click);
            // 
            // button_cancel
            // 
            this.button_cancel.Location = new System.Drawing.Point(344, 386);
            this.button_cancel.Name = "button_cancel";
            this.button_cancel.Size = new System.Drawing.Size(75, 23);
            this.button_cancel.TabIndex = 80;
            this.button_cancel.Text = "Cancel";
            this.button_cancel.UseVisualStyleBackColor = true;
            this.button_cancel.Click += new System.EventHandler(this.button_cancel_Click);
            // 
            // dataSet_macroReplacement1
            // 
            this.dataSet_macroReplacement1.DataSetName = "DataSet_macroReplacement";
            this.dataSet_macroReplacement1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
            // 
            // oleDbSelectCommand1
            // 
            this.oleDbSelectCommand1.CommandText = "SELECT     Macro.*\r\nFROM         Macro";
            this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
            // 
            // oleDbConnection1
            // 
            this.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\VisualStudio8\\MP3Tagger\\GridProce" +
                "ssor.mdb";
            // 
            // oleDbInsertCommand1
            // 
            this.oleDbInsertCommand1.CommandText = "INSERT INTO `Macro` (`Name`, `Description`) VALUES (?, ?)";
            this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
            this.oleDbInsertCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
            new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 0, "Name"),
            new System.Data.OleDb.OleDbParameter("Description", System.Data.OleDb.OleDbType.VarWChar, 0, "Description")});
            // 
            // oleDbUpdateCommand1
            // 
            this.oleDbUpdateCommand1.CommandText = "UPDATE `Macro` SET `Name` = ?, `Description` = ? WHERE ((`MacroID` = ?) AND ((? =" +
                " 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `Description` IS NULL) O" +
                "R (`Description` = ?)))";
            this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
            this.oleDbUpdateCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
            new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 0, "Name"),
            new System.Data.OleDb.OleDbParameter("Description", System.Data.OleDb.OleDbType.VarWChar, 0, "Description"),
            new System.Data.OleDb.OleDbParameter("Original_MacroID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MacroID", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("IsNull_Name", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Name", System.Data.DataRowVersion.Original, true, null),
            new System.Data.OleDb.OleDbParameter("Original_Name", System.Data.OleDb.OleDbType.VarWChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Name", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("IsNull_Description", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Description", System.Data.DataRowVersion.Original, true, null),
            new System.Data.OleDb.OleDbParameter("Original_Description", System.Data.OleDb.OleDbType.VarWChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Description", System.Data.DataRowVersion.Original, null)});
            // 
            // oleDbDeleteCommand1
            // 
            this.oleDbDeleteCommand1.CommandText = "DELETE FROM `Macro` WHERE ((`MacroID` = ?) AND ((? = 1 AND `Name` IS NULL) OR (`N" +
                "ame` = ?)) AND ((? = 1 AND `Description` IS NULL) OR (`Description` = ?)))";
            this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
            this.oleDbDeleteCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
            new System.Data.OleDb.OleDbParameter("Original_MacroID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MacroID", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("IsNull_Name", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Name", System.Data.DataRowVersion.Original, true, null),
            new System.Data.OleDb.OleDbParameter("Original_Name", System.Data.OleDb.OleDbType.VarWChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Name", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("IsNull_Description", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Description", System.Data.DataRowVersion.Original, true, null),
            new System.Data.OleDb.OleDbParameter("Original_Description", System.Data.OleDb.OleDbType.VarWChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Description", System.Data.DataRowVersion.Original, null)});
            // 
            // oleDbDataAdapter_macro
            // 
            this.oleDbDataAdapter_macro.DeleteCommand = this.oleDbDeleteCommand1;
            this.oleDbDataAdapter_macro.InsertCommand = this.oleDbInsertCommand1;
            this.oleDbDataAdapter_macro.SelectCommand = this.oleDbSelectCommand1;
            this.oleDbDataAdapter_macro.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Macro", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("MacroID", "MacroID"),
                        new System.Data.Common.DataColumnMapping("Name", "Name"),
                        new System.Data.Common.DataColumnMapping("Description", "Description")})});
            this.oleDbDataAdapter_macro.UpdateCommand = this.oleDbUpdateCommand1;
            // 
            // FormEditMacro
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(624, 420);
            this.Controls.Add(this.groupBox1);
            this.Controls.Add(this.button_cancel);
            this.Controls.Add(this.button_ok);
            this.Controls.Add(this.groupBox2);
            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
            this.Name = "FormEditMacro";
            this.SizeGripStyle = System.Windows.Forms.SizeGripStyle.Hide;
            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
            this.Text = "Edit Macro";
            this.TopMost = true;
            this.Load += new System.EventHandler(this.FormEditMacro_Load);
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView_existing)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.bindingSource_replacement)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet_replacement1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView_chosen)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.bindingSource_chosenReplacement)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet_chosenReplacement)).EndInit();
            this.groupBox2.ResumeLayout(false);
            this.groupBox2.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet_macro1)).EndInit();
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet_macroReplacement1)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.DataGridView dataGridView_existing;
        private System.Windows.Forms.DataGridView dataGridView_chosen;
        private System.Windows.Forms.Button button_add;
        private System.Windows.Forms.Button button_remove;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.Label label2;
        private System.Windows.Forms.Button button_up;
        private System.Windows.Forms.Button button_down;
        private System.Windows.Forms.Label label4;
        private System.Windows.Forms.TextBox textBox_description;
        private System.Windows.Forms.GroupBox groupBox2;
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.GroupBox groupBox1;
        private System.Windows.Forms.Button button_ok;
        private System.Windows.Forms.Button button_cancel;
        private DataSetGridProcess dataSet_replacement1;
        private DataSet_macroGridProcess dataSet_macroReplacement1;
        private DataSet_macro dataSet_macro1;
        private System.Windows.Forms.BindingSource bindingSource_replacement;
        private DataSetGridProcess dataSet_chosenReplacement;
        private System.Windows.Forms.BindingSource bindingSource_chosenReplacement;
        private System.Windows.Forms.DataGridViewTextBoxColumn replacementIDDataGridViewTextBoxColumn1;
        private System.Windows.Forms.DataGridViewTextBoxColumn replacementTypeIDDataGridViewTextBoxColumn;
        private System.Windows.Forms.DataGridViewTextBoxColumn nameDataGridViewTextBoxColumn1;
        private System.Windows.Forms.DataGridViewTextBoxColumn descriptionDataGridViewTextBoxColumn1;
        private System.Windows.Forms.DataGridViewCheckBoxColumn useRegexDataGridViewCheckBoxColumn1;
        private System.Windows.Forms.DataGridViewCheckBoxColumn toUpperDataGridViewCheckBoxColumn;
        private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
        private System.Data.OleDb.OleDbConnection oleDbConnection1;
        private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
        private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
        private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
        private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter_macro;
        private System.Windows.Forms.DataGridViewTextBoxColumn replacementIDDataGridViewTextBoxColumn;
        private System.Windows.Forms.DataGridViewTextBoxColumn colGridProcessTypeID;
        private System.Windows.Forms.DataGridViewTextBoxColumn nameDataGridViewTextBoxColumn;
        private System.Windows.Forms.DataGridViewTextBoxColumn colTypeAbbreviation;
        private System.Windows.Forms.DataGridViewTextBoxColumn descriptionDataGridViewTextBoxColumn;
        private System.Windows.Forms.DataGridViewTextBoxColumn searchExprDataGridViewTextBoxColumn;
        private System.Windows.Forms.DataGridViewTextBoxColumn replaceExprDataGridViewTextBoxColumn;
        private System.Windows.Forms.DataGridViewCheckBoxColumn useRegexDataGridViewCheckBoxColumn;
        private System.Windows.Forms.TextBox textBox_name;
    }
}

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 has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
United Kingdom United Kingdom
I'm a London-based software developer. Originally from New York, I came here in 1997 to run European application development for Standard & Poors. I now work independently ... and I'm still here!

Having seen how US software behaves outside the US, I'm keenly interested in problems of global and multilingual software design. I also used to write intelligence-gathering software, and still can't resist a well-turned algorithm! Before my IT career I was in music, and I'm now combining both interests in a highly-exciting 'Project-X'. I could tell you what it is, but ....

When not thinking about all of the above, I'm fascinated by all aspects of different cultures. (You can't take New York out of the New Yorker.) Interests include jazz, classical and world music, languages, history and ethnic food. I'm also an amateur travel writer and photographer, and run a site at www.travelogues.net, which you're welcome to stop by and visit!

Comments and Discussions