上一篇已经介绍了如何搭建windows环境下C#连接GBase 8s数据库的环境，这篇就介绍一下，怎么使用吧

先来个简单的Demo

GbsConnectionStringBuilder 
build = 
new 
GbsConnectionStringBuilder();

build.
Host = 
"192.168.1.1";

build.
Service = 
"8080";

build.
Server = 
"server";

build.
Database=
"dbname";

build.
UID=
"root";

build.
Pwd=
"a";


GbsConnection 
conn = 
new 
GbsConnection(
build.
ConnectionString);

conn.
Open();


using(
GbsCommand 
cmd = 
conn.
CreateCommand())
{

cmd.
CommandText = 
"select * from user";
GbsDataReader 
dr =

cmd.
ExecureReader();

while(
dr.
Read())
{

Console.
WriteLine(
dr[
"id"]);
}
}

host:数据库ip

service：端口

server：实例名称

database：数据库名称

uid：用户名

pwd：密码

还可以设置字符集

ClientLocale

DbLocale

字符集一定要和数据库的设置成一致哒。

正常显示结果，木问题～

ITPub博客

C#连接GBase 8s数据库在windows环境下使用步骤（二）

最新文章