Click here to Skip to main content
15,881,812 members
Articles / Programming Languages / SQL

Beginner’s Tutorial on Using the Firebird ADO.NET Client 2.5

Rate me:
Please Sign up or sign in to vote.
4.82/5 (30 votes)
25 Mar 2009CPOL7 min read 185.5K   5.2K   44  
In this article, I will show you how to interface your simple C# applications to the FirebirdSQL Server using the Firebird ADO.NET Client 2.5.
/*
 * Created by SharpDevelop.
 * User: B.H.M
 * Date: 2/24/2009
 * Time: 1:43 PM
 * 
 * To change this template use Tools | Options | Coding | Edit Standard Headers.
 */
namespace UsingFirebird
{
	partial class MainForm
	{
		/// <summary>
		/// Designer variable used to keep track of non-visual components.
		/// </summary>
		private System.ComponentModel.IContainer components = null;
		
		/// <summary>
		/// Disposes resources used by the form.
		/// </summary>
		/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
		protected override void Dispose(bool disposing)
		{
			if (disposing) {
				if (components != null) {
					components.Dispose();
				}
			}
			base.Dispose(disposing);
		}
		
		/// <summary>
		/// This method is required for Windows Forms designer support.
		/// Do not change the method contents inside the source code editor. The Forms designer might
		/// not be able to load this method if it was changed manually.
		/// </summary>
		private void InitializeComponent()
		{
			this.Details = new System.Windows.Forms.GroupBox();
			this.SexBox = new System.Windows.Forms.TextBox();
			this.AgeBox = new System.Windows.Forms.TextBox();
			this.NameBox = new System.Windows.Forms.TextBox();
			this.label3 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.SubmitButton = new System.Windows.Forms.Button();
			this.menuStrip1 = new System.Windows.Forms.MenuStrip();
			this.fileToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
			this.DeleteUserMenu = new System.Windows.Forms.ToolStripMenuItem();
			this.ExitMenu = new System.Windows.Forms.ToolStripMenuItem();
			this.viewToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
			this.ViewUsersMenu = new System.Windows.Forms.ToolStripMenuItem();
			this.Details.SuspendLayout();
			this.menuStrip1.SuspendLayout();
			this.SuspendLayout();
			// 
			// Details
			// 
			this.Details.Controls.Add(this.SexBox);
			this.Details.Controls.Add(this.AgeBox);
			this.Details.Controls.Add(this.NameBox);
			this.Details.Controls.Add(this.label3);
			this.Details.Controls.Add(this.label2);
			this.Details.Controls.Add(this.label1);
			this.Details.Location = new System.Drawing.Point(12, 63);
			this.Details.Name = "Details";
			this.Details.Size = new System.Drawing.Size(285, 144);
			this.Details.TabIndex = 3;
			this.Details.TabStop = false;
			this.Details.Text = "Details";
			// 
			// SexBox
			// 
			this.SexBox.Location = new System.Drawing.Point(91, 106);
			this.SexBox.Name = "SexBox";
			this.SexBox.Size = new System.Drawing.Size(151, 20);
			this.SexBox.TabIndex = 8;
			// 
			// AgeBox
			// 
			this.AgeBox.Location = new System.Drawing.Point(91, 70);
			this.AgeBox.Name = "AgeBox";
			this.AgeBox.Size = new System.Drawing.Size(151, 20);
			this.AgeBox.TabIndex = 7;
			// 
			// NameBox
			// 
			this.NameBox.Location = new System.Drawing.Point(91, 38);
			this.NameBox.Name = "NameBox";
			this.NameBox.Size = new System.Drawing.Size(151, 20);
			this.NameBox.TabIndex = 6;
			// 
			// label3
			// 
			this.label3.Font = new System.Drawing.Font("Miramonte", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
			this.label3.Location = new System.Drawing.Point(6, 106);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(48, 23);
			this.label3.TabIndex = 5;
			this.label3.Text = "Sex";
			// 
			// label2
			// 
			this.label2.Font = new System.Drawing.Font("Miramonte", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
			this.label2.Location = new System.Drawing.Point(6, 69);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(48, 23);
			this.label2.TabIndex = 4;
			this.label2.Text = "Age";
			// 
			// label1
			// 
			this.label1.Font = new System.Drawing.Font("Miramonte", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
			this.label1.Location = new System.Drawing.Point(6, 37);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(59, 23);
			this.label1.TabIndex = 3;
			this.label1.Text = "Name";
			// 
			// SubmitButton
			// 
			this.SubmitButton.Location = new System.Drawing.Point(12, 240);
			this.SubmitButton.Name = "SubmitButton";
			this.SubmitButton.Size = new System.Drawing.Size(75, 23);
			this.SubmitButton.TabIndex = 4;
			this.SubmitButton.Text = "Add Details";
			this.SubmitButton.UseVisualStyleBackColor = true;
			this.SubmitButton.Click += new System.EventHandler(this.SubmitButtonClick);
			// 
			// menuStrip1
			// 
			this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
									this.fileToolStripMenuItem,
									this.viewToolStripMenuItem});
			this.menuStrip1.Location = new System.Drawing.Point(0, 0);
			this.menuStrip1.Name = "menuStrip1";
			this.menuStrip1.Size = new System.Drawing.Size(318, 24);
			this.menuStrip1.TabIndex = 6;
			this.menuStrip1.Text = "menuStrip1";
			// 
			// fileToolStripMenuItem
			// 
			this.fileToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
									this.DeleteUserMenu,
									this.ExitMenu});
			this.fileToolStripMenuItem.Name = "fileToolStripMenuItem";
			this.fileToolStripMenuItem.Size = new System.Drawing.Size(35, 20);
			this.fileToolStripMenuItem.Text = "File";
			// 
			// DeleteUserMenu
			// 
			this.DeleteUserMenu.Name = "DeleteUserMenu";
			this.DeleteUserMenu.Size = new System.Drawing.Size(152, 22);
			this.DeleteUserMenu.Text = "Delete User";
			this.DeleteUserMenu.Click += new System.EventHandler(this.DeleteUserMenuClick);
			// 
			// ExitMenu
			// 
			this.ExitMenu.Name = "ExitMenu";
			this.ExitMenu.Size = new System.Drawing.Size(152, 22);
			this.ExitMenu.Text = "Exit";
			this.ExitMenu.Click += new System.EventHandler(this.ExitMenuClick);
			// 
			// viewToolStripMenuItem
			// 
			this.viewToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
									this.ViewUsersMenu});
			this.viewToolStripMenuItem.Name = "viewToolStripMenuItem";
			this.viewToolStripMenuItem.Size = new System.Drawing.Size(41, 20);
			this.viewToolStripMenuItem.Text = "View";
			// 
			// ViewUsersMenu
			// 
			this.ViewUsersMenu.Name = "ViewUsersMenu";
			this.ViewUsersMenu.Size = new System.Drawing.Size(112, 22);
			this.ViewUsersMenu.Text = "Users";
			this.ViewUsersMenu.Click += new System.EventHandler(this.ViewUsersMenuClick);
			// 
			// MainForm
			// 
			this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
			this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
			this.ClientSize = new System.Drawing.Size(318, 275);
			this.Controls.Add(this.SubmitButton);
			this.Controls.Add(this.Details);
			this.Controls.Add(this.menuStrip1);
			this.MainMenuStrip = this.menuStrip1;
			this.Name = "MainForm";
			this.Text = "Using Firebird ADO.NET Client 2.5";
			this.Details.ResumeLayout(false);
			this.Details.PerformLayout();
			this.menuStrip1.ResumeLayout(false);
			this.menuStrip1.PerformLayout();
			this.ResumeLayout(false);
			this.PerformLayout();
		}
		private System.Windows.Forms.ToolStripMenuItem ViewUsersMenu;
		private System.Windows.Forms.ToolStripMenuItem viewToolStripMenuItem;
		private System.Windows.Forms.ToolStripMenuItem ExitMenu;
		private System.Windows.Forms.ToolStripMenuItem DeleteUserMenu;
		private System.Windows.Forms.ToolStripMenuItem fileToolStripMenuItem;
		private System.Windows.Forms.MenuStrip menuStrip1;
		private System.Windows.Forms.Button SubmitButton;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.TextBox NameBox;
		private System.Windows.Forms.TextBox AgeBox;
		private System.Windows.Forms.TextBox SexBox;
		private System.Windows.Forms.GroupBox Details;
		
		
	}
}

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, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Engineer
United Kingdom United Kingdom
I have deserted general software development and chosen to enter microprocessors and push around 1s and 0s

Comments and Discussions