/// <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;
}
