/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.myConnection = new Devart.Data.PostgreSql.PgSqlConnection(); this.SuspendLayout(); // // lbDirect // this.lbDirect.Size = new System.Drawing.Size(322, 43); this.lbDirect.Text = "dotConnect for PostgreSQL"; this.lbDirect.Visible = true; // // myConnection // this.myConnection.ConnectionString = "User Id=postgres;Host=localhost;Database=testdb;Schema=test;"; this.myConnection.Name = "myConnection"; this.myConnection.Owner = this; // // MainForm // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(1016, 737); this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Name = "MainForm"; this.Text = "dotConnect for PostgreSQL Samples"; this.ResumeLayout(false); }
public TableDemoControl(Devart.Data.PostgreSql.PgSqlConnection connection) : this() { sqlConnection = connection; command.Connection = sqlConnection; cbDatabase.Text = command.Connection.Database; cbTableName.Text = string.Format("{0}.{1}", sqlConnection.Schema, command.CommandText); }
public MetaDataDemoControl(Devart.Data.PostgreSql.PgSqlConnection connection) : this() { this.connection = connection; if (connection.State == System.Data.ConnectionState.Open) { BuildTree(); } }
public StoredProcDemoControl(Devart.Data.PostgreSql.PgSqlConnection connection) : this() { Devart.Data.PostgreSql.PgSqlConnection locConnection = connection; procedureCommand.Connection = locConnection; selectCommand.Connection = locConnection; edStoredProcName.Text = procedureCommand.CommandText; tbDeptno.Text = procedureCommand.Parameters["@pdeptno"].Value.ToString(); tbDname.Text = procedureCommand.Parameters["@pdname"].Value.ToString(); tbLoc.Text = procedureCommand.Parameters["@ploc"].Value.ToString(); }
/// <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); }
public RowStoredProcDemoControl(Devart.Data.PostgreSql.PgSqlConnection connection) : this() { this.pgSqlCommand.Connection = connection; }
public DataSetDemoControl(Devart.Data.PostgreSql.PgSqlConnection connection) : this() { this.command.Connection = connection; this.tbSql.Text = this.command.CommandText; }
public PicturesDemoControl(Devart.Data.PostgreSql.PgSqlConnection connection) : this() { selectCommand.Connection = connection; }
public CrystalDemoControl(Devart.Data.PostgreSql.PgSqlConnection connection) : this() { this.selectCommand.Connection = connection; }
/// <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.btRefresh = new System.Windows.Forms.Button(); this.panelForGrids = new System.Windows.Forms.Panel(); this.tvSchemaView = new System.Windows.Forms.TreeView(); this.spltHorizontal = new System.Windows.Forms.Splitter(); this.pnRestrict = new System.Windows.Forms.Panel(); this.propertyGrid = new System.Windows.Forms.PropertyGrid(); this.lbRest = new System.Windows.Forms.Label(); this.lbColl = new System.Windows.Forms.Label(); this.splitter = new System.Windows.Forms.Splitter(); this.dgShowMeta = new System.Windows.Forms.DataGrid(); this.connection = new Devart.Data.PostgreSql.PgSqlConnection(); this.topPanel.SuspendLayout(); this.panelForGrids.SuspendLayout(); this.pnRestrict.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dgShowMeta)).BeginInit(); this.SuspendLayout(); // // topPanel // this.topPanel.Controls.AddRange(new System.Windows.Forms.Control[] { this.btRefresh }); this.topPanel.Dock = System.Windows.Forms.DockStyle.Top; this.topPanel.Name = "topPanel"; this.topPanel.Size = new System.Drawing.Size(400, 24); this.topPanel.TabIndex = 10; // // btRefresh // this.btRefresh.FlatStyle = System.Windows.Forms.FlatStyle.System; this.btRefresh.Name = "btRefresh"; this.btRefresh.TabIndex = 2; this.btRefresh.Text = "Refresh"; this.btRefresh.Click += new System.EventHandler(this.btRefresh_Click); // // panelForGrids // this.panelForGrids.Controls.AddRange(new System.Windows.Forms.Control[] { this.tvSchemaView, this.spltHorizontal, this.pnRestrict, this.lbColl }); this.panelForGrids.Dock = System.Windows.Forms.DockStyle.Left; this.panelForGrids.Location = new System.Drawing.Point(0, 24); this.panelForGrids.Name = "panelForGrids"; this.panelForGrids.Size = new System.Drawing.Size(160, 276); this.panelForGrids.TabIndex = 3; // // tvSchemaView // this.tvSchemaView.Dock = System.Windows.Forms.DockStyle.Fill; this.tvSchemaView.HideSelection = false; this.tvSchemaView.ImageIndex = -1; this.tvSchemaView.Location = new System.Drawing.Point(0, 15); this.tvSchemaView.Name = "tvSchemaView"; this.tvSchemaView.SelectedImageIndex = -1; this.tvSchemaView.Size = new System.Drawing.Size(160, 170); this.tvSchemaView.TabIndex = 2; this.tvSchemaView.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.tvSchemaView_AfterSelect); // // spltHorizontal // this.spltHorizontal.Dock = System.Windows.Forms.DockStyle.Bottom; this.spltHorizontal.Location = new System.Drawing.Point(0, 185); this.spltHorizontal.MinExtra = 60; this.spltHorizontal.MinSize = 50; this.spltHorizontal.Name = "spltHorizontal"; this.spltHorizontal.Size = new System.Drawing.Size(160, 3); this.spltHorizontal.TabIndex = 1; this.spltHorizontal.TabStop = false; this.spltHorizontal.Visible = false; // // pnRestrict // this.pnRestrict.Controls.AddRange(new System.Windows.Forms.Control[] { this.propertyGrid, this.lbRest }); this.pnRestrict.Dock = System.Windows.Forms.DockStyle.Bottom; this.pnRestrict.Location = new System.Drawing.Point(0, 188); this.pnRestrict.Name = "pnRestrict"; this.pnRestrict.Size = new System.Drawing.Size(160, 88); this.pnRestrict.TabIndex = 4; this.pnRestrict.Visible = false; // // propertyGrid // this.propertyGrid.CommandsVisibleIfAvailable = true; this.propertyGrid.Dock = System.Windows.Forms.DockStyle.Fill; this.propertyGrid.HelpVisible = false; this.propertyGrid.LargeButtons = false; this.propertyGrid.LineColor = System.Drawing.SystemColors.ScrollBar; this.propertyGrid.Location = new System.Drawing.Point(0, 15); this.propertyGrid.Name = "propertyGrid"; this.propertyGrid.PropertySort = System.Windows.Forms.PropertySort.NoSort; this.propertyGrid.Size = new System.Drawing.Size(160, 73); this.propertyGrid.TabIndex = 6; this.propertyGrid.Text = "PropertyGrid"; this.propertyGrid.ToolbarVisible = false; this.propertyGrid.ViewBackColor = System.Drawing.SystemColors.Window; this.propertyGrid.ViewForeColor = System.Drawing.SystemColors.WindowText; // // lbRest // this.lbRest.BackColor = System.Drawing.SystemColors.ActiveCaption; this.lbRest.Dock = System.Windows.Forms.DockStyle.Top; this.lbRest.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; this.lbRest.Name = "lbRest"; this.lbRest.Size = new System.Drawing.Size(160, 15); this.lbRest.TabIndex = 4; this.lbRest.Text = "Restrictions"; // // lbColl // this.lbColl.BackColor = System.Drawing.SystemColors.ActiveCaption; this.lbColl.Dock = System.Windows.Forms.DockStyle.Top; this.lbColl.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; this.lbColl.Name = "lbColl"; this.lbColl.Size = new System.Drawing.Size(160, 15); this.lbColl.TabIndex = 3; this.lbColl.Text = "Collections"; // // splitter // this.splitter.Location = new System.Drawing.Point(160, 24); this.splitter.MinExtra = 100; this.splitter.MinSize = 100; this.splitter.Name = "splitter"; this.splitter.Size = new System.Drawing.Size(3, 276); this.splitter.TabIndex = 11; this.splitter.TabStop = false; // // dgShowMeta // this.dgShowMeta.AllowNavigation = false; this.dgShowMeta.BorderStyle = System.Windows.Forms.BorderStyle.None; this.dgShowMeta.CaptionVisible = false; this.dgShowMeta.DataMember = ""; this.dgShowMeta.Dock = System.Windows.Forms.DockStyle.Fill; this.dgShowMeta.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dgShowMeta.Location = new System.Drawing.Point(163, 24); this.dgShowMeta.Name = "dgShowMeta"; this.dgShowMeta.ReadOnly = true; this.dgShowMeta.Size = new System.Drawing.Size(237, 276); this.dgShowMeta.TabIndex = 12; // // connection // this.connection.Name = "connection"; this.connection.Owner = this; // // MetaDataDemoControl // this.Controls.AddRange(new System.Windows.Forms.Control[] { this.dgShowMeta, this.splitter, this.panelForGrids, this.topPanel }); this.Name = "MetaDataDemoControl"; this.Size = new System.Drawing.Size(400, 300); this.topPanel.ResumeLayout(false); this.panelForGrids.ResumeLayout(false); this.pnRestrict.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dgShowMeta)).EndInit(); this.ResumeLayout(false); }
public MasterDetailDemoControl(Devart.Data.PostgreSql.PgSqlConnection connection) : this() { this.masterCommand.Connection = connection; this.detailCommand.Connection = connection; }