Example #1
0
 /// <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);
 }
Example #2
0
 /// <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);
 }
Example #3
0
 /// <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);
 }
Example #4
0
 /// <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);
 }
Example #5
0
 /// <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);
 }
Example #6
0
 /// <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);
 }
Example #7
0
 /// <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);
 }