コード例 #1
0
ファイル: BuildDeletePanel.cs プロジェクト: ikvm/webmatrix
 private void InitializeComponent()
 {
     this._whereClauseBuilder = new WhereClauseBuilder();
     this._tableListBox = new ListBox();
     this._tablePanel = new Panel();
     this._tableLabel = new Label();
     this._whereLabel = new Label();
     this._sqlTextBox = new MxTextBox();
     this._previewLabel = new Label();
     this._tablePanel.SuspendLayout();
     base.SuspendLayout();
     this._whereClauseBuilder.Database = null;
     this._whereClauseBuilder.Location = new Point(8, 0x70);
     this._whereClauseBuilder.Name = "_whereClauseBuilder";
     this._whereClauseBuilder.ServiceProvider = null;
     this._whereClauseBuilder.Size = new Size(0x1e8, 100);
     this._whereClauseBuilder.TabIndex = 4;
     this._tableListBox.BorderStyle = BorderStyle.None;
     this._tableListBox.Dock = DockStyle.Fill;
     this._tableListBox.IntegralHeight = false;
     this._tableListBox.Location = new Point(1, 1);
     this._tableListBox.Name = "_tableListBox";
     this._tableListBox.Size = new Size(470, 0x56);
     this._tableListBox.TabIndex = 1;
     this._tableListBox.SelectedIndexChanged += new EventHandler(this.OnTableListBoxSelectedIndexChanged);
     this._tablePanel.BackColor = SystemColors.ControlDark;
     this._tablePanel.Controls.AddRange(new Control[] { this._tableListBox });
     this._tablePanel.DockPadding.All = 1;
     this._tablePanel.Location = new Point(0x10, 0x10);
     this._tablePanel.Name = "_tablePanel";
     this._tablePanel.Size = new Size(0x1d8, 0x54);
     this._tablePanel.TabIndex = 2;
     this._tableLabel.Location = new Point(0x10, 0);
     this._tableLabel.Name = "_tableLabel";
     this._tableLabel.Size = new Size(0x2c, 0x10);
     this._tableLabel.TabIndex = 1;
     this._tableLabel.Text = "&Table:";
     this._whereLabel.Location = new Point(0x10, 0x68);
     this._whereLabel.Name = "_whereLabel";
     this._whereLabel.Size = new Size(0x38, 0x10);
     this._whereLabel.TabIndex = 3;
     this._whereLabel.Text = "W&HERE:";
     this._sqlTextBox.Location = new Point(0x10, 0xe4);
     this._sqlTextBox.Multiline = true;
     this._sqlTextBox.Name = "_sqlTextBox";
     this._sqlTextBox.ReadOnly = true;
     this._sqlTextBox.ScrollBars = ScrollBars.Vertical;
     this._sqlTextBox.Size = new Size(0x1d4, 0x2c);
     this._sqlTextBox.TabIndex = 6;
     this._sqlTextBox.Text = "";
     this._previewLabel.Location = new Point(0x10, 0xd4);
     this._previewLabel.Name = "_previewLabel";
     this._previewLabel.Size = new Size(0x38, 0x10);
     this._previewLabel.TabIndex = 5;
     this._previewLabel.Text = "&Preview:";
     base.Controls.AddRange(new Control[] { this._previewLabel, this._sqlTextBox, this._whereLabel, this._tableLabel, this._tablePanel, this._whereClauseBuilder });
     base.Caption = "BUILD a DELECT Query";
     base.Description = "Construct a DELETE statement by selecting a table and specifiying a WHERE clause.";
     base.Name = "BuildDeletePanel";
     base.Size = new Size(0x1f8, 0x124);
     this._tablePanel.ResumeLayout(false);
     base.ResumeLayout(false);
 }
コード例 #2
0
ファイル: BuildSelectPanel.cs プロジェクト: ikvm/webmatrix
 private void InitializeComponent()
 {
     this._tableListBox = new ListBox();
     this._tablePanel = new Panel();
     this._columnsPanel = new Panel();
     this._columnsListView = new ListView();
     this._sqlTextBox = new MxTextBox();
     this._selectAllButton = new Button();
     this._selectNoneButton = new Button();
     this._tablesLabel = new Label();
     this._columnsLabel = new Label();
     this._previewLabel = new Label();
     this._whereClauseBuilder = new WhereClauseBuilder();
     this._whereLabel = new Label();
     this._tablePanel.SuspendLayout();
     this._columnsPanel.SuspendLayout();
     base.SuspendLayout();
     this._tableListBox.BorderStyle = BorderStyle.None;
     this._tableListBox.Dock = DockStyle.Fill;
     this._tableListBox.IntegralHeight = false;
     this._tableListBox.Location = new Point(1, 1);
     this._tableListBox.Name = "_tableListBox";
     this._tableListBox.TabIndex = 0;
     this._tableListBox.SelectedIndexChanged += new EventHandler(this._tableListBox_SelectedIndexChanged);
     this._tablePanel.BackColor = SystemColors.ControlDark;
     this._tablePanel.Controls.AddRange(new Control[] { this._tableListBox });
     this._tablePanel.DockPadding.All = 1;
     this._tablePanel.Location = new Point(12, 0x10);
     this._tablePanel.Name = "_tablePanel";
     this._tablePanel.Size = new Size(120, 0x54);
     this._tablePanel.TabIndex = 2;
     this._columnsPanel.BackColor = SystemColors.ControlDark;
     this._columnsPanel.Controls.AddRange(new Control[] { this._columnsListView });
     this._columnsPanel.DockPadding.All = 1;
     this._columnsPanel.Location = new Point(140, 0x10);
     this._columnsPanel.Name = "_columnsPanel";
     this._columnsPanel.Size = new Size(0x100, 0x54);
     this._columnsPanel.TabIndex = 4;
     this._columnsListView.BorderStyle = BorderStyle.None;
     this._columnsListView.CheckBoxes = true;
     this._columnsListView.Dock = DockStyle.Fill;
     this._columnsListView.FullRowSelect = true;
     this._columnsListView.Location = new Point(1, 1);
     this._columnsListView.MultiSelect = false;
     this._columnsListView.Name = "_columnsListView";
     this._columnsListView.TabIndex = 0;
     this._columnsListView.View = View.List;
     this._columnsListView.ItemCheck += new ItemCheckEventHandler(this.OnColumnsListViewItemCheck);
     this._sqlTextBox.AlwaysShowFocusCues = true;
     this._sqlTextBox.FlatAppearance = true;
     this._sqlTextBox.Location = new Point(12, 0xe4);
     this._sqlTextBox.Multiline = true;
     this._sqlTextBox.Name = "_sqlTextBox";
     this._sqlTextBox.ReadOnly = true;
     this._sqlTextBox.Size = new Size(0x1d8, 0x2c);
     this._sqlTextBox.ScrollBars = ScrollBars.Vertical;
     this._sqlTextBox.TabIndex = 10;
     this._sqlTextBox.Text = "";
     this._selectAllButton.FlatStyle = FlatStyle.System;
     this._selectAllButton.Location = new Point(0x198, 0x10);
     this._selectAllButton.Name = "_selectAllButton";
     this._selectAllButton.TabIndex = 5;
     this._selectAllButton.Text = "Select &All";
     this._selectAllButton.Click += new EventHandler(this._selectAllButton_Click);
     this._selectNoneButton.FlatStyle = FlatStyle.System;
     this._selectNoneButton.Location = new Point(0x198, 0x2c);
     this._selectNoneButton.Name = "_selectNoneButton";
     this._selectNoneButton.TabIndex = 6;
     this._selectNoneButton.Text = "Select Non&e";
     this._selectNoneButton.Click += new EventHandler(this._selectNoneButton_Click);
     this._tablesLabel.Location = new Point(12, 0);
     this._tablesLabel.Name = "_tablesLabel";
     this._tablesLabel.Size = new Size(0x38, 0x10);
     this._tablesLabel.TabIndex = 1;
     this._tablesLabel.Text = "&Tables:";
     this._columnsLabel.Location = new Point(140, 0);
     this._columnsLabel.Name = "_columnsLabel";
     this._columnsLabel.Size = new Size(0x38, 0x10);
     this._columnsLabel.TabIndex = 3;
     this._columnsLabel.Text = "C&olumns:";
     this._previewLabel.Location = new Point(12, 0xd4);
     this._previewLabel.Name = "_previewLabel";
     this._previewLabel.Size = new Size(0x58, 0x10);
     this._previewLabel.TabIndex = 9;
     this._previewLabel.Text = "&Preview:";
     this._whereClauseBuilder.Location = new Point(4, 0x70);
     this._whereClauseBuilder.Name = "_whereClauseBuilder";
     this._whereClauseBuilder.Size = new Size(0x1e8, 100);
     this._whereClauseBuilder.TabIndex = 8;
     this._whereLabel.Location = new Point(12, 0x68);
     this._whereLabel.Name = "_whereLabel";
     this._whereLabel.Size = new Size(90, 0x10);
     this._whereLabel.TabIndex = 7;
     this._whereLabel.Text = "&WHERE clause:";
     base.Controls.AddRange(new Control[] { this._whereLabel, this._whereClauseBuilder, this._previewLabel, this._columnsLabel, this._tablesLabel, this._selectNoneButton, this._selectAllButton, this._sqlTextBox, this._columnsPanel, this._tablePanel });
     base.Caption = "Construct a SELECT query";
     base.Description = "Check the columns you want returned and build the WHERE clause.";
     base.Name = "BuildSelectPanel";
     base.Size = new Size(500, 0x124);
     this._tablePanel.ResumeLayout(false);
     this._columnsPanel.ResumeLayout(false);
     base.ResumeLayout(false);
 }
コード例 #3
0
ファイル: BuildUpdatePanel.cs プロジェクト: ikvm/webmatrix
 private void InitializeComponent()
 {
     this._columnLabel = new Label();
     this._columnsPanel = new Panel();
     this._columnsListView = new ListView();
     this._tablePanel = new Panel();
     this._tableListBox = new ListBox();
     this._tableLabel = new Label();
     this._whereClauseBuilder = new WhereClauseBuilder();
     this._previewLabel = new Label();
     this._sqlTextBox = new MxTextBox();
     this._whereLabel = new Label();
     this._columnsPanel.SuspendLayout();
     this._tablePanel.SuspendLayout();
     base.SuspendLayout();
     this._columnLabel.Location = new Point(0x7c, 0);
     this._columnLabel.Name = "_columnLabel";
     this._columnLabel.Size = new Size(60, 0x10);
     this._columnLabel.TabIndex = 3;
     this._columnLabel.Text = "C&olumn:";
     this._columnsPanel.BackColor = SystemColors.ControlDark;
     this._columnsPanel.Controls.AddRange(new Control[] { this._columnsListView });
     this._columnsPanel.DockPadding.All = 1;
     this._columnsPanel.Location = new Point(0x7c, 0x10);
     this._columnsPanel.Name = "_columnsPanel";
     this._columnsPanel.Size = new Size(0x160, 0x54);
     this._columnsPanel.TabIndex = 4;
     this._columnsListView.BorderStyle = BorderStyle.None;
     this._columnsListView.CheckBoxes = true;
     this._columnsListView.Dock = DockStyle.Fill;
     this._columnsListView.HeaderStyle = ColumnHeaderStyle.Nonclickable;
     this._columnsListView.HideSelection = false;
     this._columnsListView.Location = new Point(1, 1);
     this._columnsListView.MultiSelect = false;
     this._columnsListView.Name = "_columnsListView";
     this._columnsListView.TabIndex = 0;
     this._columnsListView.View = View.List;
     this._columnsListView.SelectedIndexChanged += new EventHandler(this.OnColumnsListViewSelectedIndexChanged);
     this._columnsListView.ItemCheck += new ItemCheckEventHandler(this.OnColumnsListViewItemCheck);
     this._tablePanel.BackColor = SystemColors.ControlDark;
     this._tablePanel.Controls.AddRange(new Control[] { this._tableListBox });
     this._tablePanel.DockPadding.All = 1;
     this._tablePanel.Location = new Point(8, 0x10);
     this._tablePanel.Name = "_tablePanel";
     this._tablePanel.Size = new Size(0x70, 0x54);
     this._tablePanel.TabIndex = 2;
     this._tableListBox.BorderStyle = BorderStyle.None;
     this._tableListBox.Dock = DockStyle.Fill;
     this._tableListBox.IntegralHeight = false;
     this._tableListBox.Location = new Point(1, 1);
     this._tableListBox.Name = "_tableListBox";
     this._tableListBox.TabIndex = 0;
     this._tableListBox.SelectedIndexChanged += new EventHandler(this.OnTableListBoxSelectedIndexChanged);
     this._tableLabel.Location = new Point(8, 0);
     this._tableLabel.Name = "_tableLabel";
     this._tableLabel.Size = new Size(0x30, 0x10);
     this._tableLabel.TabIndex = 1;
     this._tableLabel.Text = "&Table:";
     this._whereClauseBuilder.Database = null;
     this._whereClauseBuilder.Location = new Point(0, 0x70);
     this._whereClauseBuilder.Name = "_whereClauseBuilder";
     this._whereClauseBuilder.ServiceProvider = null;
     this._whereClauseBuilder.Size = new Size(0x1e8, 100);
     this._whereClauseBuilder.TabIndex = 6;
     this._whereClauseBuilder.ClauseRemoved += new EventHandler(this.OnWhereClauseBuilderChanged);
     this._whereClauseBuilder.ClauseAdded += new EventHandler(this.OnWhereClauseBuilderChanged);
     this._previewLabel.Location = new Point(12, 0xd4);
     this._previewLabel.Name = "_previewLabel";
     this._previewLabel.Size = new Size(0x38, 0x10);
     this._previewLabel.TabIndex = 7;
     this._previewLabel.Text = "&Preview:";
     this._sqlTextBox.Location = new Point(12, 0xe4);
     this._sqlTextBox.Multiline = true;
     this._sqlTextBox.Name = "_sqlTextBox";
     this._sqlTextBox.ReadOnly = true;
     this._sqlTextBox.ScrollBars = ScrollBars.Vertical;
     this._sqlTextBox.Size = new Size(0x1d4, 0x2c);
     this._sqlTextBox.TabIndex = 8;
     this._sqlTextBox.Text = "";
     this._whereLabel.Location = new Point(8, 0x68);
     this._whereLabel.Name = "_whereLabel";
     this._whereLabel.Size = new Size(0x38, 0x10);
     this._whereLabel.TabIndex = 5;
     this._whereLabel.Text = "&WHERE:";
     base.Controls.AddRange(new Control[] { this._whereLabel, this._previewLabel, this._sqlTextBox, this._whereClauseBuilder, this._columnLabel, this._columnsPanel, this._tablePanel, this._tableLabel });
     base.Caption = "Construct an UPDATE query";
     base.Description = "Select the columns you want to update and construct a WHERE clause.";
     base.Name = "BuildUpdatePanel";
     base.Size = new Size(0x1ec, 0x124);
     this._columnsPanel.ResumeLayout(false);
     this._tablePanel.ResumeLayout(false);
     base.ResumeLayout(false);
 }