/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.connection = new Devart.Data.PostgreSql.PgSqlConnection(); this.command = new Devart.Data.PostgreSql.PgSqlCommand(); this.sqlDataAdapter = new Devart.Data.PostgreSql.PgSqlDataAdapter(); this.sqlCommandBuilder = new Devart.Data.PostgreSql.PgSqlCommandBuilder(); this.btInsertRecord.Click += new System.EventHandler(this.btInsertRecord_Click); this.btUpdate.Click += new System.EventHandler(this.btUpdate_Click); this.btFill.Click += new System.EventHandler(this.btFill_Click); this.btTest.Click += new System.EventHandler(this.btTest_Click); this.dataGrid.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGrid_CancelCommand); this.dataGrid.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGrid_EditCommand); this.dataGrid.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGrid_UpdateCommand); this.dataGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGrid_DeleteCommand); // // connection // this.connection.ConnectionString = "User Id=postgres;Host=localhost;Database=testdb;Schema=test;"; this.connection.Name = "connection"; this.connection.Owner = this; // // sqlCommand // this.command.CommandText = "Select * from Dept"; this.command.Name = "sqlCommand"; this.command.Connection = this.connection; // this.command.Owner = this; // // sqlDataAdapter // this.sqlDataAdapter.SelectCommand = this.command; // // sqlCommandBuilder // this.sqlCommandBuilder.DataAdapter = this.sqlDataAdapter; this.sqlCommandBuilder.Quoted = true; this.sqlCommandBuilder.UpdatingFields = ""; this.Load += new System.EventHandler(this.Page_Load); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.pnTop = new System.Windows.Forms.Panel(); this.btClear = new System.Windows.Forms.Button(); this.btFill = new System.Windows.Forms.Button(); this.edParamValue = new System.Windows.Forms.TextBox(); this.lbStoredProcName = new System.Windows.Forms.Label(); this.dataGrid = new System.Windows.Forms.DataGrid(); this.pgSqlCommand = new Devart.Data.PostgreSql.PgSqlCommand(); this.pgSqlDataAdapter = new Devart.Data.PostgreSql.PgSqlDataAdapter(); this.pgSqlCommandBuilder = new Devart.Data.PostgreSql.PgSqlCommandBuilder(); this.dataSet = new System.Data.DataSet(); this.pnTop.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).BeginInit(); this.SuspendLayout(); // // pnTop // this.pnTop.Controls.AddRange(new System.Windows.Forms.Control[] { this.btClear, this.btFill, this.edParamValue, this.lbStoredProcName }); this.pnTop.Dock = System.Windows.Forms.DockStyle.Top; this.pnTop.Name = "pnTop"; this.pnTop.Size = new System.Drawing.Size(456, 43); this.pnTop.TabIndex = 2; // // btClear // this.btClear.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btClear.Location = new System.Drawing.Point(76, 0); this.btClear.Name = "btClear"; this.btClear.TabIndex = 1; this.btClear.Text = "Clear"; this.btClear.Click += new System.EventHandler(this.btClear_Click); // // btFill // this.btFill.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btFill.Name = "btFill"; this.btFill.TabIndex = 0; this.btFill.Text = "Fill"; this.btFill.Click += new System.EventHandler(this.btFill_Click); // // edParamValue // this.edParamValue.Location = new System.Drawing.Point(264, 12); this.edParamValue.Name = "edParamValue"; this.edParamValue.Size = new System.Drawing.Size(176, 20); this.edParamValue.TabIndex = 10; this.edParamValue.Text = "(1, \'(1, N a m e , location)\' )"; // // lbStoredProcName // this.lbStoredProcName.Location = new System.Drawing.Point(160, 16); this.lbStoredProcName.Name = "lbStoredProcName"; this.lbStoredProcName.Size = new System.Drawing.Size(88, 16); this.lbStoredProcName.TabIndex = 9; this.lbStoredProcName.Text = "Parameter value"; // // dataGrid // this.dataGrid.AllowNavigation = false; this.dataGrid.BorderStyle = System.Windows.Forms.BorderStyle.None; this.dataGrid.CaptionVisible = false; this.dataGrid.DataMember = ""; this.dataGrid.DataSource = this.dataSet; this.dataGrid.Dock = System.Windows.Forms.DockStyle.Fill; this.dataGrid.GridLineColor = System.Drawing.SystemColors.ActiveBorder; this.dataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid.Location = new System.Drawing.Point(0, 43); this.dataGrid.Name = "dataGrid"; this.dataGrid.Size = new System.Drawing.Size(456, 195); this.dataGrid.TabIndex = 5; // // pgSqlCommand // this.pgSqlCommand.CommandType = System.Data.CommandType.StoredProcedure; this.pgSqlCommand.CommandText = "getdept"; this.pgSqlCommand.Name = "pgSqlCommand"; this.pgSqlCommand.Parameters.Add(new Devart.Data.PostgreSql.PgSqlParameter("p1", "dept_container", System.Data.ParameterDirection.Input, false, "", System.Data.DataRowVersion.Current, "1, \'(1, N a m e , location)\' ")); this.pgSqlCommand.Owner = this; // // pgSqlDataAdapter // this.pgSqlDataAdapter.SelectCommand = this.pgSqlCommand; // // pgSqlCommandBuilder // this.pgSqlCommandBuilder.DataAdapter = this.pgSqlDataAdapter; this.pgSqlCommandBuilder.UpdatingFields = ""; // // dataSet // this.dataSet.DataSetName = "NewDataSet"; this.dataSet.EnforceConstraints = false; // // RowStoredProcDemoControl // this.Controls.AddRange(new System.Windows.Forms.Control[] { this.dataGrid, this.pnTop }); this.Name = "RowStoredProcDemoControl"; this.Size = new System.Drawing.Size(456, 238); this.pnTop.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.pnTop = new System.Windows.Forms.Panel(); this.btUpdate = new System.Windows.Forms.Button(); this.btClear = new System.Windows.Forms.Button(); this.btFill = new System.Windows.Forms.Button(); this.tbSql = new System.Windows.Forms.TextBox(); this.splitter = new System.Windows.Forms.Splitter(); this.dataGrid = new System.Windows.Forms.DataGrid(); this.myDataSet = new System.Data.DataSet(); this.command = new Devart.Data.PostgreSql.PgSqlCommand(); this.dataAdapter = new Devart.Data.PostgreSql.PgSqlDataAdapter(); this.commandBuilder = new Devart.Data.PostgreSql.PgSqlCommandBuilder(); this.pnTop.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.myDataSet)).BeginInit(); this.SuspendLayout(); // // pnTop // this.pnTop.Controls.AddRange(new System.Windows.Forms.Control[] { this.btUpdate, this.btClear, this.btFill }); this.pnTop.Dock = System.Windows.Forms.DockStyle.Top; this.pnTop.Name = "pnTop"; this.pnTop.Size = new System.Drawing.Size(400, 24); this.pnTop.TabIndex = 1; // // btUpdate // this.btUpdate.Enabled = false; this.btUpdate.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btUpdate.Location = new System.Drawing.Point(152, 0); this.btUpdate.Name = "btUpdate"; this.btUpdate.TabIndex = 2; this.btUpdate.Text = "Update"; this.btUpdate.Click += new System.EventHandler(this.btUpdate_Click); // // btClear // this.btClear.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btClear.Location = new System.Drawing.Point(76, 0); this.btClear.Name = "btClear"; this.btClear.TabIndex = 1; this.btClear.Text = "Clear"; this.btClear.Click += new System.EventHandler(this.btClear_Click); // // btFill // this.btFill.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btFill.Name = "btFill"; this.btFill.TabIndex = 0; this.btFill.Text = "Fill"; this.btFill.Click += new System.EventHandler(this.btFill_Click); // // tbSql // this.tbSql.Dock = System.Windows.Forms.DockStyle.Top; this.tbSql.Location = new System.Drawing.Point(0, 24); this.tbSql.Multiline = true; this.tbSql.Name = "tbSql"; this.tbSql.Size = new System.Drawing.Size(400, 64); this.tbSql.TabIndex = 2; this.tbSql.Text = ""; this.tbSql.Leave += new System.EventHandler(this.tbSql_Leave); // // splitter // this.splitter.Dock = System.Windows.Forms.DockStyle.Top; this.splitter.Location = new System.Drawing.Point(0, 88); this.splitter.MinExtra = 50; this.splitter.Name = "splitter"; this.splitter.Size = new System.Drawing.Size(400, 3); this.splitter.TabIndex = 3; this.splitter.TabStop = false; // // dataGrid // this.dataGrid.AllowNavigation = false; this.dataGrid.BorderStyle = System.Windows.Forms.BorderStyle.None; this.dataGrid.CaptionVisible = false; this.dataGrid.DataMember = ""; this.dataGrid.DataSource = this.myDataSet; this.dataGrid.Dock = System.Windows.Forms.DockStyle.Fill; this.dataGrid.GridLineColor = System.Drawing.SystemColors.ActiveBorder; this.dataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid.Location = new System.Drawing.Point(0, 91); this.dataGrid.Name = "dataGrid"; this.dataGrid.Size = new System.Drawing.Size(400, 189); this.dataGrid.TabIndex = 4; this.dataGrid.CurrentCellChanged += new System.EventHandler(this.dataGrid_CurrentCellChanged); // // myDataSet // this.myDataSet.DataSetName = "NewDataSet"; this.myDataSet.Locale = new System.Globalization.CultureInfo("ru-RU"); // // command // this.command.CommandText = "SELECT * FROM Dept"; this.command.Name = "command"; this.command.Owner = this; // // dataAdapter // this.dataAdapter.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey; this.dataAdapter.SelectCommand = this.command; // // commandBuilder // this.commandBuilder.DataAdapter = this.dataAdapter; this.commandBuilder.Quoted = true; this.commandBuilder.UpdatingFields = ""; // // DataSetDemoControl // this.Controls.AddRange(new System.Windows.Forms.Control[] { this.dataGrid, this.splitter, this.tbSql, this.pnTop }); this.Name = "DataSetDemoControl"; this.Size = new System.Drawing.Size(400, 280); this.pnTop.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.myDataSet)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.dataSet = new System.Data.DataSet(); this.command = new Devart.Data.PostgreSql.PgSqlCommand(); this.dataAdapter = new Devart.Data.PostgreSql.PgSqlDataAdapter(); this.commandBuilder = new Devart.Data.PostgreSql.PgSqlCommandBuilder(); this.topPanel = new System.Windows.Forms.Panel(); this.lbDatabase = new System.Windows.Forms.Label(); this.cbDatabase = new System.Windows.Forms.ComboBox(); this.lbTableName = new System.Windows.Forms.Label(); this.cbTableName = new System.Windows.Forms.ComboBox(); this.btUpdate = new System.Windows.Forms.Button(); this.btClear = new System.Windows.Forms.Button(); this.btFill = new System.Windows.Forms.Button(); this.dataGrid = new System.Windows.Forms.DataGrid(); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).BeginInit(); this.topPanel.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit(); this.SuspendLayout(); // // dataSet // this.dataSet.DataSetName = "NewDataSet"; this.dataSet.Locale = new System.Globalization.CultureInfo("en-US"); // // command // this.command.CommandType = System.Data.CommandType.TableDirect; this.command.CommandText = "Dept"; this.command.Name = "command"; this.command.Owner = this; // // dataAdapter // this.dataAdapter.SelectCommand = this.command; // // commandBuilder // this.commandBuilder.DataAdapter = this.dataAdapter; this.commandBuilder.Quoted = true; this.commandBuilder.UpdatingFields = ""; // // topPanel // this.topPanel.Controls.AddRange(new System.Windows.Forms.Control[] { this.lbDatabase, this.cbDatabase, this.lbTableName, this.cbTableName, this.btUpdate, this.btClear, this.btFill }); this.topPanel.Dock = System.Windows.Forms.DockStyle.Top; this.topPanel.Name = "topPanel"; this.topPanel.Size = new System.Drawing.Size(477, 64); this.topPanel.TabIndex = 2; // // lbDatabase // this.lbDatabase.Location = new System.Drawing.Point(8, 36); this.lbDatabase.Name = "lbDatabase"; this.lbDatabase.Size = new System.Drawing.Size(56, 16); this.lbDatabase.TabIndex = 8; this.lbDatabase.Text = "Database"; // // cbDatabase // this.cbDatabase.Location = new System.Drawing.Point(67, 32); this.cbDatabase.Name = "cbDatabase"; this.cbDatabase.Size = new System.Drawing.Size(160, 21); this.cbDatabase.Sorted = true; this.cbDatabase.TabIndex = 7; this.cbDatabase.DropDown += new System.EventHandler(this.cbDatabase_DropDown); this.cbDatabase.TextChanged += new System.EventHandler(this.cbDatabase_TextChanged); this.cbDatabase.Leave += new System.EventHandler(this.cbDatabase_Leave); // // lbTableName // this.lbTableName.Location = new System.Drawing.Point(232, 36); this.lbTableName.Name = "lbTableName"; this.lbTableName.Size = new System.Drawing.Size(64, 16); this.lbTableName.TabIndex = 6; this.lbTableName.Text = "Table name"; // // cbTableName // this.cbTableName.Location = new System.Drawing.Point(296, 32); this.cbTableName.Name = "cbTableName"; this.cbTableName.Size = new System.Drawing.Size(172, 21); this.cbTableName.Sorted = true; this.cbTableName.TabIndex = 5; this.cbTableName.DropDown += new System.EventHandler(this.cbTableName_DropDown); this.cbTableName.Leave += new System.EventHandler(this.cbTableName_Leave); // // btUpdate // this.btUpdate.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btUpdate.Location = new System.Drawing.Point(152, 0); this.btUpdate.Name = "btUpdate"; this.btUpdate.RightToLeft = System.Windows.Forms.RightToLeft.Yes; this.btUpdate.TabIndex = 4; this.btUpdate.Text = "Update"; this.btUpdate.Click += new System.EventHandler(this.btUpdate_Click); // // btClear // this.btClear.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btClear.Location = new System.Drawing.Point(76, 0); this.btClear.Name = "btClear"; this.btClear.TabIndex = 3; this.btClear.Text = "Clear"; this.btClear.Click += new System.EventHandler(this.btClear_Click); // // btFill // this.btFill.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btFill.Name = "btFill"; this.btFill.TabIndex = 2; this.btFill.Text = "Fill"; this.btFill.Click += new System.EventHandler(this.btFill_Click); // // dataGrid // this.dataGrid.AllowNavigation = false; this.dataGrid.BorderStyle = System.Windows.Forms.BorderStyle.None; this.dataGrid.CaptionVisible = false; this.dataGrid.DataMember = ""; this.dataGrid.DataSource = this.dataSet; this.dataGrid.Dock = System.Windows.Forms.DockStyle.Fill; this.dataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid.Location = new System.Drawing.Point(0, 64); this.dataGrid.Name = "dataGrid"; this.dataGrid.Size = new System.Drawing.Size(477, 270); this.dataGrid.TabIndex = 7; // // TableDemoControl // this.Controls.AddRange(new System.Windows.Forms.Control[] { this.dataGrid, this.topPanel }); this.Name = "TableDemoControl"; this.Size = new System.Drawing.Size(477, 334); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).EndInit(); this.topPanel.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.middlePanel = new System.Windows.Forms.Panel(); this.btClearPicture = new System.Windows.Forms.Button(); this.btSave = new System.Windows.Forms.Button(); this.btLoad = new System.Windows.Forms.Button(); this.openFileDialog = new System.Windows.Forms.OpenFileDialog(); this.splitter = new System.Windows.Forms.Splitter(); this.saveFileDialog = new System.Windows.Forms.SaveFileDialog(); this.dataGrid = new System.Windows.Forms.DataGrid(); this.dataSet = new System.Data.DataSet(); this.pictureBox = new System.Windows.Forms.PictureBox(); this.topPanel = new System.Windows.Forms.Panel(); this.btShowImages = new System.Windows.Forms.Button(); this.btUpdate = new System.Windows.Forms.Button(); this.btClear = new System.Windows.Forms.Button(); this.btFill = new System.Windows.Forms.Button(); this.selectCommand = new Devart.Data.PostgreSql.PgSqlCommand(); this.dataAdapter = new Devart.Data.PostgreSql.PgSqlDataAdapter(); this.commandBuilder = new Devart.Data.PostgreSql.PgSqlCommandBuilder(); this.middlePanel.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).BeginInit(); this.topPanel.SuspendLayout(); this.SuspendLayout(); // // middlePanel // this.middlePanel.Controls.AddRange(new System.Windows.Forms.Control[] { this.btClearPicture, this.btSave, this.btLoad }); this.middlePanel.Dock = System.Windows.Forms.DockStyle.Top; this.middlePanel.Location = new System.Drawing.Point(0, 123); this.middlePanel.Name = "middlePanel"; this.middlePanel.Size = new System.Drawing.Size(520, 24); this.middlePanel.TabIndex = 15; // // btClearPicture // this.btClearPicture.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btClearPicture.Location = new System.Drawing.Point(194, 0); this.btClearPicture.Name = "btClearPicture"; this.btClearPicture.Size = new System.Drawing.Size(64, 23); this.btClearPicture.TabIndex = 2; this.btClearPicture.Text = "Clear"; this.btClearPicture.Click += new System.EventHandler(this.btClearPicture_Click); // // btSave // this.btSave.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btSave.Location = new System.Drawing.Point(97, 0); this.btSave.Name = "btSave"; this.btSave.Size = new System.Drawing.Size(96, 23); this.btSave.TabIndex = 1; this.btSave.Text = "Save to file..."; this.btSave.Click += new System.EventHandler(this.btSave_Click); // // btLoad // this.btLoad.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btLoad.Name = "btLoad"; this.btLoad.Size = new System.Drawing.Size(96, 23); this.btLoad.TabIndex = 0; this.btLoad.Text = "Load from file..."; this.btLoad.Click += new System.EventHandler(this.btLoad_Click); // // openFileDialog // this.openFileDialog.DefaultExt = "bmp"; this.openFileDialog.Filter = "Bitmaps (*.bmp)|*.bmp"; // // splitter // this.splitter.Cursor = System.Windows.Forms.Cursors.HSplit; this.splitter.Dock = System.Windows.Forms.DockStyle.Top; this.splitter.Location = new System.Drawing.Point(0, 120); this.splitter.MinExtra = 70; this.splitter.MinSize = 70; this.splitter.Name = "splitter"; this.splitter.Size = new System.Drawing.Size(520, 3); this.splitter.TabIndex = 16; this.splitter.TabStop = false; // // saveFileDialog // this.saveFileDialog.DefaultExt = "bmp"; this.saveFileDialog.Filter = "Bitmaps (*.bmp)|*.bmp"; // // dataGrid // this.dataGrid.AllowNavigation = false; this.dataGrid.AllowSorting = false; this.dataGrid.BorderStyle = System.Windows.Forms.BorderStyle.None; this.dataGrid.CaptionVisible = false; this.dataGrid.DataMember = ""; this.dataGrid.DataSource = this.dataSet; this.dataGrid.Dock = System.Windows.Forms.DockStyle.Top; this.dataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid.Location = new System.Drawing.Point(0, 24); this.dataGrid.Name = "dataGrid"; this.dataGrid.Size = new System.Drawing.Size(520, 96); this.dataGrid.TabIndex = 13; this.dataGrid.DataSourceChanged += new System.EventHandler(this.dataGrid_DataSourceChanged); this.dataGrid.CurrentCellChanged += new System.EventHandler(this.dataGrid_CurrentCellChanged); // // dataSet // this.dataSet.DataSetName = "NewDataSet"; this.dataSet.Locale = new System.Globalization.CultureInfo("en-US"); // // pictureBox // this.pictureBox.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.pictureBox.Dock = System.Windows.Forms.DockStyle.Fill; this.pictureBox.Location = new System.Drawing.Point(0, 147); this.pictureBox.Name = "pictureBox"; this.pictureBox.Size = new System.Drawing.Size(520, 133); this.pictureBox.TabIndex = 14; this.pictureBox.TabStop = false; // // topPanel // this.topPanel.Controls.AddRange(new System.Windows.Forms.Control[] { this.btShowImages, this.btUpdate, this.btClear, this.btFill }); this.topPanel.Dock = System.Windows.Forms.DockStyle.Top; this.topPanel.Name = "topPanel"; this.topPanel.Size = new System.Drawing.Size(520, 24); this.topPanel.TabIndex = 11; // // btShowImages // this.btShowImages.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btShowImages.Location = new System.Drawing.Point(330, 0); this.btShowImages.Name = "btShowImages"; this.btShowImages.Size = new System.Drawing.Size(88, 23); this.btShowImages.TabIndex = 5; this.btShowImages.Text = "Show Images !"; this.btShowImages.Click += new System.EventHandler(this.btShowImages_Click); // // btUpdate // this.btUpdate.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btUpdate.Location = new System.Drawing.Point(152, 0); this.btUpdate.Name = "btUpdate"; this.btUpdate.RightToLeft = System.Windows.Forms.RightToLeft.Yes; this.btUpdate.TabIndex = 4; this.btUpdate.Text = "Update"; this.btUpdate.Click += new System.EventHandler(this.btUpdate_Click); // // btClear // this.btClear.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btClear.Location = new System.Drawing.Point(76, 0); this.btClear.Name = "btClear"; this.btClear.TabIndex = 3; this.btClear.Text = "Clear"; this.btClear.Click += new System.EventHandler(this.btClear_Click); // // btFill // this.btFill.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btFill.Name = "btFill"; this.btFill.TabIndex = 2; this.btFill.Text = "Fill"; this.btFill.Click += new System.EventHandler(this.btFill_Click); // // selectCommand // this.selectCommand.CommandText = "SELECT * FROM pgsqlnet_pictures"; this.selectCommand.Name = "selectCommand"; this.selectCommand.Owner = this; // // dataAdapter // this.dataAdapter.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey; this.dataAdapter.SelectCommand = this.selectCommand; // // commandBuilder // this.commandBuilder.DataAdapter = this.dataAdapter; this.commandBuilder.Quoted = true; this.commandBuilder.UpdatingFields = ""; // // PicturesDemoControl // this.Controls.AddRange(new System.Windows.Forms.Control[] { this.pictureBox, this.middlePanel, this.splitter, this.dataGrid, this.topPanel }); this.Name = "PicturesDemoControl"; this.Size = new System.Drawing.Size(520, 280); this.middlePanel.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).EndInit(); this.topPanel.ResumeLayout(false); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.topPanel = new System.Windows.Forms.Panel(); this.btRollback = new System.Windows.Forms.Button(); this.btCommit = new System.Windows.Forms.Button(); this.btBegin = new System.Windows.Forms.Button(); this.btUpdate = new System.Windows.Forms.Button(); this.btClear = new System.Windows.Forms.Button(); this.btFill = new System.Windows.Forms.Button(); this.dataSet = new System.Data.DataSet(); this.selectCommand = new Devart.Data.PostgreSql.PgSqlCommand(); this.dataAdapter = new Devart.Data.PostgreSql.PgSqlDataAdapter(); this.commandBuilder = new Devart.Data.PostgreSql.PgSqlCommandBuilder(); this.dataGrid = new System.Windows.Forms.DataGrid(); this.topPanel.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit(); this.SuspendLayout(); // // topPanel // this.topPanel.Controls.AddRange(new System.Windows.Forms.Control[] { this.btRollback, this.btCommit, this.btBegin, this.btUpdate, this.btClear, this.btFill }); this.topPanel.Dock = System.Windows.Forms.DockStyle.Top; this.topPanel.Name = "topPanel"; this.topPanel.Size = new System.Drawing.Size(477, 24); this.topPanel.TabIndex = 2; // // btRollback // this.btRollback.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btRollback.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204))); this.btRollback.ForeColor = System.Drawing.Color.Navy; this.btRollback.Location = new System.Drawing.Point(392, 0); this.btRollback.Name = "btRollback"; this.btRollback.TabIndex = 7; this.btRollback.Text = "Rollback"; this.btRollback.Click += new System.EventHandler(this.btRollback_Click); // // btCommit // this.btCommit.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btCommit.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204))); this.btCommit.ForeColor = System.Drawing.Color.Navy; this.btCommit.Location = new System.Drawing.Point(316, 0); this.btCommit.Name = "btCommit"; this.btCommit.TabIndex = 6; this.btCommit.Text = "Commit"; this.btCommit.Click += new System.EventHandler(this.btCommit_Click); // // btBegin // this.btBegin.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btBegin.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204))); this.btBegin.ForeColor = System.Drawing.Color.Navy; this.btBegin.Location = new System.Drawing.Point(240, 0); this.btBegin.Name = "btBegin"; this.btBegin.TabIndex = 5; this.btBegin.Text = "Begin"; this.btBegin.Click += new System.EventHandler(this.btBegin_Click); // // btUpdate // this.btUpdate.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btUpdate.Location = new System.Drawing.Point(76, 0); this.btUpdate.Name = "btUpdate"; this.btUpdate.RightToLeft = System.Windows.Forms.RightToLeft.Yes; this.btUpdate.TabIndex = 4; this.btUpdate.Text = "Update"; this.btUpdate.Click += new System.EventHandler(this.btUpdate_Click); // // btClear // this.btClear.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btClear.Location = new System.Drawing.Point(152, 0); this.btClear.Name = "btClear"; this.btClear.TabIndex = 3; this.btClear.Text = "Clear"; this.btClear.Click += new System.EventHandler(this.btClear_Click); // // btFill // this.btFill.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btFill.Name = "btFill"; this.btFill.TabIndex = 2; this.btFill.Text = "Fill"; this.btFill.Click += new System.EventHandler(this.btFill_Click); // // dataSet // this.dataSet.DataSetName = "NewDataSet"; this.dataSet.Locale = new System.Globalization.CultureInfo("en-US"); // // selectCommand // this.selectCommand.CommandText = "Select * from dept"; this.selectCommand.Name = "selectCommand"; this.selectCommand.Owner = this; // // dataAdapter // this.dataAdapter.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey; this.dataAdapter.SelectCommand = this.selectCommand; // // commandBuilder // this.commandBuilder.DataAdapter = this.dataAdapter; this.commandBuilder.Quoted = true; this.commandBuilder.UpdatingFields = ""; // // dataGrid // this.dataGrid.BorderStyle = System.Windows.Forms.BorderStyle.None; this.dataGrid.CaptionVisible = false; this.dataGrid.DataMember = ""; this.dataGrid.DataSource = this.dataSet; this.dataGrid.Dock = System.Windows.Forms.DockStyle.Fill; this.dataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid.Location = new System.Drawing.Point(0, 24); this.dataGrid.Name = "dataGrid"; this.dataGrid.Size = new System.Drawing.Size(477, 310); this.dataGrid.TabIndex = 3; // // TransactionsDemoControl // this.Controls.AddRange(new System.Windows.Forms.Control[] { this.dataGrid, this.topPanel }); this.Name = "TransactionsDemoControl"; this.Size = new System.Drawing.Size(477, 334); this.topPanel.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.masterCommand = new Devart.Data.PostgreSql.PgSqlCommand(); this.detailCommand = new Devart.Data.PostgreSql.PgSqlCommand(); this.masterDataAdapter = new Devart.Data.PostgreSql.PgSqlDataAdapter(); this.detailDataAdapter = new Devart.Data.PostgreSql.PgSqlDataAdapter(); this.masterCommandBuilder = new Devart.Data.PostgreSql.PgSqlCommandBuilder(); this.detailCommandBuilder = new Devart.Data.PostgreSql.PgSqlCommandBuilder(); this.dataSet = new System.Data.DataSet(); this.splitter = new System.Windows.Forms.Splitter(); this.detailGrid = new System.Windows.Forms.DataGrid(); this.masterGrid = new System.Windows.Forms.DataGrid(); this.topPanel = new System.Windows.Forms.Panel(); this.btUpdate = new System.Windows.Forms.Button(); this.btClear = new System.Windows.Forms.Button(); this.btFill = new System.Windows.Forms.Button(); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.detailGrid)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.masterGrid)).BeginInit(); this.topPanel.SuspendLayout(); this.SuspendLayout(); // // masterCommand // this.masterCommand.CommandText = "SELECT * FROM Dept"; this.masterCommand.Name = "masterCommand"; this.masterCommand.Owner = this; // // detailCommand // this.detailCommand.CommandText = "SELECT EMPNO,ENAME,JOB,MGR,HIREDATE,DEPTNO FROM Emp"; this.detailCommand.Name = "detailCommand"; this.detailCommand.Owner = this; // // masterDataAdapter // this.masterDataAdapter.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey; this.masterDataAdapter.SelectCommand = this.masterCommand; // // detailDataAdapter // this.detailDataAdapter.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey; this.detailDataAdapter.SelectCommand = this.detailCommand; // // masterCommandBuilder // this.masterCommandBuilder.DataAdapter = this.masterDataAdapter; this.masterCommandBuilder.Quoted = true; this.masterCommandBuilder.UpdatingFields = ""; // // detailCommandBuilder // this.detailCommandBuilder.DataAdapter = this.detailDataAdapter; this.detailCommandBuilder.Quoted = true; this.detailCommandBuilder.ConflictOption = System.Data.ConflictOption.OverwriteChanges; this.detailCommandBuilder.UpdatingFields = ""; // // dataSet // this.dataSet.DataSetName = "NewDataSet"; this.dataSet.Locale = new System.Globalization.CultureInfo("en"); // // splitter // this.splitter.Cursor = System.Windows.Forms.Cursors.HSplit; this.splitter.Dock = System.Windows.Forms.DockStyle.Bottom; this.splitter.Location = new System.Drawing.Point(0, 149); this.splitter.MinExtra = 50; this.splitter.MinSize = 50; this.splitter.Name = "splitter"; this.splitter.Size = new System.Drawing.Size(400, 3); this.splitter.TabIndex = 13; this.splitter.TabStop = false; // // detailGrid // this.detailGrid.AllowNavigation = false; this.detailGrid.BorderStyle = System.Windows.Forms.BorderStyle.None; this.detailGrid.CaptionVisible = false; this.detailGrid.DataMember = ""; this.detailGrid.DataSource = this.dataSet; this.detailGrid.Dock = System.Windows.Forms.DockStyle.Bottom; this.detailGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.detailGrid.Location = new System.Drawing.Point(0, 152); this.detailGrid.Name = "detailGrid"; this.detailGrid.Size = new System.Drawing.Size(400, 128); this.detailGrid.TabIndex = 12; // // masterGrid // this.masterGrid.AllowNavigation = false; this.masterGrid.BorderStyle = System.Windows.Forms.BorderStyle.None; this.masterGrid.CaptionVisible = false; this.masterGrid.DataMember = ""; this.masterGrid.DataSource = this.dataSet; this.masterGrid.Dock = System.Windows.Forms.DockStyle.Fill; this.masterGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.masterGrid.Location = new System.Drawing.Point(0, 24); this.masterGrid.Name = "masterGrid"; this.masterGrid.Size = new System.Drawing.Size(400, 125); this.masterGrid.TabIndex = 11; // // topPanel // this.topPanel.Controls.AddRange(new System.Windows.Forms.Control[] { this.btUpdate, this.btClear, this.btFill }); this.topPanel.Dock = System.Windows.Forms.DockStyle.Top; this.topPanel.Name = "topPanel"; this.topPanel.Size = new System.Drawing.Size(400, 24); this.topPanel.TabIndex = 9; // // btUpdate // this.btUpdate.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btUpdate.Location = new System.Drawing.Point(152, 0); this.btUpdate.Name = "btUpdate"; this.btUpdate.RightToLeft = System.Windows.Forms.RightToLeft.Yes; this.btUpdate.TabIndex = 4; this.btUpdate.Text = "Update"; this.btUpdate.Click += new System.EventHandler(this.btUpdate_Click); // // btClear // this.btClear.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btClear.Location = new System.Drawing.Point(76, 0); this.btClear.Name = "btClear"; this.btClear.TabIndex = 3; this.btClear.Text = "Clear"; this.btClear.Click += new System.EventHandler(this.btClear_Click); // // btFill // this.btFill.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btFill.Name = "btFill"; this.btFill.TabIndex = 2; this.btFill.Text = "Fill"; this.btFill.Click += new System.EventHandler(this.btFill_Click); // // MasterDetailDemoControl // this.Controls.AddRange(new System.Windows.Forms.Control[] { this.masterGrid, this.splitter, this.detailGrid, this.topPanel }); this.Name = "MasterDetailDemoControl"; this.Size = new System.Drawing.Size(400, 280); ((System.ComponentModel.ISupportInitialize)(this.dataSet)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.detailGrid)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.masterGrid)).EndInit(); this.topPanel.ResumeLayout(false); this.ResumeLayout(false); }