Table of Contents Previous Next


4 Using the .NET Connector : 4.1 Opening a Database Connection : 4.1.4 Example - Opening a Database Connection from a Windows Form Application
 
4.1.4 Example - Opening a Database Connection from a Windows Form Application
The following example demonstrates opening a database connection using a .NET WinForm application. To use the example, save the following code as WinForm-Example.cs in a directory that contains the library files.
using System;
using System.Windows.Forms;
using System.Drawing;
using EnterpriseDB.EDBClient;
 
namespace EDBTestClient
{
class Win_Conn
{
static void Main(string[] args)
{
Form frmMain = new Form();
Button btnConn = new Button();
btnConn.Location = new System.Drawing.Point(104, 64);
btnConn.Name = "btnConn";
btnConn.Text = "Open Connection";
btnConn.Click += new System.EventHandler(btnConn_Click);
 
frmMain.Controls.Add(btnConn);
frmMain.Text = "EnterpriseDB";
Application.Run(frmMain);
}
 
private static void btnConn_Click(object sender, System.EventArgs e)
{
EDBConnection conn = null;
try
{
string connectionString = "Server=10.90.1.29;port=5444;
username=edb;password=edb;database=edb";
conn = new EDBConnection(connectionString);
conn.Open();
MessageBox.Show("Connection Open");
}
catch(EDBException exp)
{
MessageBox.Show(exp.ToString());
}
finally
{
conn.Close();
}
}
}
}
Note that you must change the database connection string to point to the database that you want to connect to before compiling the file with the following command:
csc /r:EDBDataProvider.dll /out:WinForm.exe WinForm-Example.cs
This command should generate a WinForm.exe file within the same folder that the executable was compiled under. Invoking the executable will display:
dialog
4 Using the .NET Connector : 4.1 Opening a Database Connection : 4.1.4 Example - Opening a Database Connection from a Windows Form Application

Table of Contents Previous Next