The GBase database (GBase数据库) is widely utilized across various enterprise applications. For developers, knowing how to connect to GBase database using ADO.NET is crucial.
This article will walk you through setting up an ADO.NET connection to a GBase database and performing basic database operations.
ADO.NET Connection Setup (Using .NET Framework)
Before getting started, ensure your environment is properly set up. This example uses Visual Studio 2015 Community Edition and requires CSDK 2.2.2 configuration. Ensure that your development environment has Visual Studio installed and is compatible with .NET Framework 4.5.2.
1. Open Visual Studio and Create a New Project
Go to File (F) -> New (N) -> Project (P).
2. Specify Programming Language and .NET Framework Version
Select Visual C# and .NET Framework 4.5.2 to create a Windows Forms Application. Name the project "TestDotNet" and choose the desired location for the project.
3. Add Controls to Form1
In the Form1 window, add and format the following controls:
-
Label: Name it
label1 -
DataGridView: Name it
dataGridView1 -
Button: Name it
btnSelect
4. Add Reference to GBS.Data.GBasedbt.dll
In Solution Explorer, right-click on References and add a reference. Browse and select the GBS.Data.GBasedbt.dll file. For this example, the path is: D:\GBASE\GBase Client-SDK\bin\netf40\GBS.Data.GBasedbt.dll.
5. Add C# Code
Copy the following sample code into Form1.cs (adjust control names as needed):
using System;
using System.Data;
using System.Windows.Forms;
using GBS.Data.GBasedbt;
namespace TestDotNet
{
public partial class Form1 : Form
{
IfxConnection ifxconn;
DataSet ds;
public Form1()
{
InitializeComponent();
IfxConnectionStringBuilder build = new IfxConnectionStringBuilder();
// Complete connection details here instead of using setnet sqlhosts config
build.Host = "bd.gbasedbt.com"; // Hostname or IP address
build.Protocol = "onsoctcp"; // Protocol used by the database
build.Service = "9088"; // Port number
build.Server = "gbase01"; // Database server name
build.Database = "utf8"; // Database name (DBNAME)
build.UID = "gbasedbt"; // User
build.Pwd = "GBase123"; // Password
build.DbLocale = "zh_CN.utf8"; // Database character set
build.ClientLocale = "zh_CN.utf8"; // Client character set
build.PersistSecurityInfo = true; // Persist security info
ifxconn = new IfxConnection(build.ConnectionString);
ifxconn.Open();
using (IfxCommand ifxcmd = ifxconn.CreateCommand())
{
ifxcmd.CommandText = "drop table if exists company";
ifxcmd.ExecuteNonQuery();
ifxcmd.CommandText = "create table company(coid serial, coname varchar(255), coaddr varchar(255))";
ifxcmd.ExecuteNonQuery();
ifxcmd.CommandText = "insert into company values (0, 'GBASE', 'Tianjin High-Tech')";
ifxcmd.ExecuteNonQuery();
ifxcmd.CommandText = "insert into company values (0, 'GBASE Beijing Branch', 'Beijing Chaoyang')";
ifxcmd.ExecuteNonQuery();
ifxcmd.CommandText = "update company set coaddr = 'Tianjin Tianbai Park' where coid = 1";
ifxcmd.ExecuteNonQuery();
ifxcmd.CommandText = "select dbinfo('version','full') from dual";
IfxDataReader dr = ifxcmd.ExecuteReader();
if (dr.Read())
{
this.label1.Text = "Database version: " + dr[0];
}
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
IfxDataAdapter ifxadpt = new IfxDataAdapter("select * from company", ifxconn);
ds = new DataSet();
ifxadpt.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
MessageBox.Show("Database operation successful using DotNet! \n");
}
}
}
6. Debug and Test Database Connection
Ensure that all software is 64-bit compatible, and set Debug mode to x64. If you are using a 32-bit CSDK, select x86.
After the Form1 window appears, click the query button to display records from the company table along with a success message.
By following the detailed steps above, you should now be able to connect to a GBase 8s database using ADO.NET and perform basic database operations. Thank you for reading!
If you have any questions or suggestions about GBase databse (GBase数据库), feel free to leave a comment. We look forward to discussing technology with you and progressing together.
Top comments (0)