Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version

Data Application Block for Firebird SQL

, 29 Mar 2006 CPOL
Data Application Block for Firebird SQL intended to speed the development of applications.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

using MyApplication.Data;
using FirebirdSql.Data.FirebirdClient;

namespace FbDataApplicationBlock
    public partial class frmSampleWithParameters : Form
        public frmSampleWithParameters()

        private void frmSampleWithParameters_Load(object sender, EventArgs e)
            dataGridView1.DataSource = GetProjectsForEmployeeID(8);
            //dataGridView1.DataBindings = myDataset;
            dataGridView1.AutoGenerateColumns = true;
            this.dataGridView1.DataMember = "tblProjects";

        private DataSet GetProjectsForEmployeeID(int pEmployeeId)
            string myConnectionString = "User=SYSDBA;Password=masterkey;Database=EMPLOYEE.FDB;ServerType = 1;";
            DBObject myDBObject = new DBObject(myConnectionString);

            FbParameter[] myFbParameters = new FbParameter[] { new FbParameter("@EMP_NO", FbDbType.Integer) };
            myFbParameters[0].Value = pEmployeeId;

            DataSet dsProjects = new DataSet();
                dsProjects = myDBObject.RunProcedure(
                     "GET_EMP_PROJ", myFbParameters, "tblProjects");
                return dsProjects;
                //Place error handling code here.
           return dsProjects;        


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.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Web Developer
United States United States
Alex is the founder, President, Architect, of a one man development and consulting company (Avida, Corp of Miami, FL), and he is also a shameless self promoter. A deserter of the accounting profession, Alex is been developing/supporting windows and web applications for Fortune 500 and small companies as well since 2000.
His programming experience includes VB6, VB.NET, C#, ASP, ASP.NET, MSSQL 7/2000/2005, Firebird SQL 1.7. Alex has acquired expertise in Visual Studio, Reporting Services, SQL Server, and other stuff that I can’t remember right now.
In his spare time, he enjoys bicycling with his trusted Litespeed titanium racing bike which is his favorite material possession.
He goes anywhere and takes any challenge that the Technology field troughs at him, and sometimes he even wins. He can be more often found at code camps, user groups, the local Microsoft office’s cafeteria, or sleep in his couch.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150302.1 | Last Updated 29 Mar 2006
Article Copyright 2006 by Xela220
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid