Click here to Skip to main content
15,894,825 members
Articles / Programming Languages / SQL

A Helpful Database Library

Rate me:
Please Sign up or sign in to vote.
2.75/5 (4 votes)
6 Dec 20065 min read 50.1K   704   26  
This article illustrates a helpful database library.
namespace WinDB_for_CodeProject
{
    partial class Form1
    {
        /// <summary>
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Windows Form Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.dgvDataGrid = new System.Windows.Forms.DataGridView();
            this.cboComm = new System.Windows.Forms.ComboBox();
            this.label1 = new System.Windows.Forms.Label();
            this.btnRunSQL = new System.Windows.Forms.Button();
            this.btnExit = new System.Windows.Forms.Button();
            this.btnSelData = new System.Windows.Forms.Button();
            this.label2 = new System.Windows.Forms.Label();
            this.cboTables = new System.Windows.Forms.ComboBox();
            ((System.ComponentModel.ISupportInitialize)(this.dgvDataGrid)).BeginInit();
            this.SuspendLayout();
            // 
            // dgvDataGrid
            // 
            this.dgvDataGrid.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dgvDataGrid.Location = new System.Drawing.Point(12, 12);
            this.dgvDataGrid.Name = "dgvDataGrid";
            this.dgvDataGrid.Size = new System.Drawing.Size(546, 314);
            this.dgvDataGrid.TabIndex = 1;
            // 
            // cboComm
            // 
            this.cboComm.FormattingEnabled = true;
            this.cboComm.Items.AddRange(new object[] {
            "GET TABLES",
            "SELECT *"});
            this.cboComm.Location = new System.Drawing.Point(12, 345);
            this.cboComm.Name = "cboComm";
            this.cboComm.Size = new System.Drawing.Size(121, 21);
            this.cboComm.TabIndex = 2;
            // 
            // label1
            // 
            this.label1.AutoSize = true;
            this.label1.Location = new System.Drawing.Point(12, 329);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(83, 13);
            this.label1.TabIndex = 3;
            this.label1.Text = "SQL Commands";
            // 
            // btnRunSQL
            // 
            this.btnRunSQL.Location = new System.Drawing.Point(483, 343);
            this.btnRunSQL.Name = "btnRunSQL";
            this.btnRunSQL.Size = new System.Drawing.Size(75, 23);
            this.btnRunSQL.TabIndex = 4;
            this.btnRunSQL.Text = "Run SQL";
            this.btnRunSQL.UseVisualStyleBackColor = true;
            this.btnRunSQL.Click += new System.EventHandler(this.btnRunSQL_Click);
            // 
            // btnExit
            // 
            this.btnExit.Location = new System.Drawing.Point(483, 377);
            this.btnExit.Name = "btnExit";
            this.btnExit.Size = new System.Drawing.Size(75, 23);
            this.btnExit.TabIndex = 5;
            this.btnExit.Text = "Exit";
            this.btnExit.UseVisualStyleBackColor = true;
            this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
            // 
            // btnSelData
            // 
            this.btnSelData.Location = new System.Drawing.Point(372, 377);
            this.btnSelData.Name = "btnSelData";
            this.btnSelData.Size = new System.Drawing.Size(105, 23);
            this.btnSelData.TabIndex = 6;
            this.btnSelData.Text = "Select Datasource";
            this.btnSelData.UseVisualStyleBackColor = true;
            this.btnSelData.Click += new System.EventHandler(this.btnSelData_Click);
            // 
            // label2
            // 
            this.label2.AutoSize = true;
            this.label2.Location = new System.Drawing.Point(156, 329);
            this.label2.Name = "label2";
            this.label2.Size = new System.Drawing.Size(99, 13);
            this.label2.TabIndex = 7;
            this.label2.Text = "DataSource Tables";
            // 
            // cboTables
            // 
            this.cboTables.FormattingEnabled = true;
            this.cboTables.Location = new System.Drawing.Point(160, 345);
            this.cboTables.Name = "cboTables";
            this.cboTables.Size = new System.Drawing.Size(121, 21);
            this.cboTables.TabIndex = 8;
            // 
            // Form1
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(570, 412);
            this.Controls.Add(this.cboTables);
            this.Controls.Add(this.label2);
            this.Controls.Add(this.btnSelData);
            this.Controls.Add(this.btnExit);
            this.Controls.Add(this.btnRunSQL);
            this.Controls.Add(this.label1);
            this.Controls.Add(this.cboComm);
            this.Controls.Add(this.dgvDataGrid);
            this.Name = "Form1";
            this.Text = "Code Project Database Library";
            ((System.ComponentModel.ISupportInitialize)(this.dgvDataGrid)).EndInit();
            this.ResumeLayout(false);
            this.PerformLayout();

        }

        #endregion

        private System.Windows.Forms.DataGridView dgvDataGrid;
        private System.Windows.Forms.ComboBox cboComm;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.Button btnRunSQL;
        private System.Windows.Forms.Button btnExit;
        private System.Windows.Forms.Button btnSelData;
        private System.Windows.Forms.Label label2;
        private System.Windows.Forms.ComboBox cboTables;
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Web Developer
United States United States
I am a software, database, and gis developer. I love the challenge of learning new ways to code.

Comments and Discussions