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

上一篇已经介绍了如何搭建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

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

正常显示结果，木问题～