Skip to main content

Using Firebird with ASP.net


In my previous post, I was able to connect a firebird 2.0 database to asp.net using controls. The next goal was to connect to a firebird database using the firebird.net engine and using the repeater control. I however, was able to use the firebird.net engine to connect to the firebird database but not to the repeater control. I used the html table tag. I've created a simple asp.net demo displaying the contents of a firebird database on page load. Here are the steps:

1. Things Needed:
  • Firebird 2.0 Server
  • Firebird 2.0 Client
  • Visual Web Developer
2. In Visual Web Developer, create a new ASP.net Website (using C# as the programming language). The project will have a default page named Default.aspx. Make sure that the code is separate from the page (ex. Default.aspx.cs is separate from Default.aspx)
3. On the Website menu, click on Add Reference.

4. Select the Firebird - ADO.net 2.0 Data Provider and click Ok.
5. Add using FirebirdSql.Data.FirebirdClient; to the "using" section;
6. On the Solution Explorer, double click on Default.aspx.cs.















The following code should appear.


















7. Paste the following in the Page_Load event:

FbConnection fbCn = new FbConnection("Database=;Server=localhost;User=SYSDBA;Password=masterkey;");
FbDataAdapter fbDa = new FbDataAdapter();
FbCommand fbCmd = new FbCommand();
DataTable dt = new DataTable();

fbCn.Open();
fbCmd = new FbCommand("select * from \"TableName\"", fbCn);
fbDa = new FbDataAdapter(fbCmd);
fbDa.Fill(dt);
this.GridView1.DataSource = dt;
this.Repeater1.DataSource = dt;
Response.Write("< r =" 1;" cellspacing =" 1;" cellpadding="1">");
for (int j = 0; j <>" + dt.Columns[j].ToString() + "< / t d >");
for (int i = 0; i <>");
for (int j = 0; j <>" + dt.Rows[i][j].ToString() + "< / t d >");
Response.Write("< / t r >");
}
Response.Write("< / t a b l e >");

8. The output of my database contains the following:
Labels:

Comments

Anonymous said…
hello, i have a question about connecting to a firebird database with my WinCE device. the databse is located on my server (desktop pc)

string
connectionString =
"Database=C:\\smartpos\\data\\smartpos_horeca_net.fdb;" +
"User=SYSDBA;" + "Password=masterkey;" +
"Dialect=3;Server=192.168.1.100";

IDbConnection dbcon = new FbConnection(connectionString);
dbcon.Open();
IDbCommand dbcmd = dbcon.CreateCommand();


The code shown above works on WM5 device. On WinCE it fails. it does not connectto the db.
on wm5 it uses FirebirdSql.Data.FirebirdClient reference.
Can you please help me further?

Thanks,
August 3, 2009 at 8:32 PM
Eran Smith said…
This comment has been removed by the author.
October 17, 2011 at 2:34 PM
Post a Comment

Popular posts from this blog

How to register a business name

Attending business summits and conferences is a big help to those who belong to the quite "techy" (technological or technical) industry. Being a graduate of one, I had less knowledge in the field of entrepreneurship. Enrolling myself in business administration gave me quite the knowledge to be a part of the business world and thus improve my entrepreneurial skills. I now would like to share this information that I got familiar with (and I managed to get a copy of the entire process from the 6th Mindanao ICT Congress): How to Register a Business Name (in the Philippines) ----------------------------------------------------------------------------------------------- SINGLE PROPRIETORSHIP Applicant must secure 2 copies of registration form and pay Php 300.00 (rate may change) for single proprietorship registration processing fee. The registration shall be valid for five (5) years. A surcharge of Php 100.00 is imposed if renewal is filed beyond the three (3) month grace period, c...
6 comments
Read more

Adding a Footer to the DataGridView component

I have been searching for sites and forums that would give me a any hint on having a footer on the .net DataGridView control. It was frustrating. I found some, but not what I was looking for. I use windows forms. It would have been easier if I was into web. I decided to create one for myself. It's not complete, but it works with me. It needs improvement and I hope that some programmers who might pass through this blog will help me with it :D. Limitations: Cannot set Footer values during design time. Can sometimes hide a row when scrolled to the last item in the grid. What I did was just create a user control that inherits the DataGridView control and add a StatusStrip to act as the footer. public partial class MyDataGridView : DataGridView { public StatusStrip Footer { get { return (StatusStrip)this.Controls["Footer"]; } } private bool _footerVisible; [Browsable(false)] /// /// Sets or Gets the va...
1 comment
Read more

Using Crystal Reports 10 with C#.net and Firebird

C# express doesn't include a report designer or viewer. Reports however, is very much needed when creating a business software. Since C# express doesn't include a report designer, we need to find other means. One is to use a free report such as MyNeoReport. This however may not work under many circumstances. The other alternative would be to use a proven report engine and designer-Crystal Report. Crystal Report has been used by many developers (in our city). However, using a free programming language and IDE, and a free database is very limiting. Not much information can be gathered on the net either (with regards to reporting as of this writing). Here's a way to use Crystal Reports using Firebird database and C# Express as software development IDE: Pre-requisites: C# Express 2005 EMS SQL Manager 2005 for InterBase & Firebird Lite Crystal Reports 10 Create the following database: Name: TestDB1 Tables: TESTTABLE1 Columns:  ID - PK, INTEGER,AUTOINCREMENT DES...
6 comments
Read more