C#连接db2数据库的实现方法

通过ole db for db2驱动

string strsql = @"select phone_no from no_store where id<5";
            string strconn = "provider=ibmdadb2;data source=数据库名;uid=用户名;pwd=密码;";
            using (oledbconnection conn = new oledbconnection(strconn))
            {
                oledbcommand cmd = new oledbcommand(strsql, conn);
                try
                {
                    conn.open();
                    oledbdataadapter adp = new oledbdataadapter(cmd);
                    dataset ds = new dataset();
                    adp.fill(ds);
                    datatable dt = ds.tables[0];
                    if (dt != null)
                    {
                        for (int i = 0; i < dt.rows.count; i++)
                        {
                            console.writeline("电话" + i + ":" + dt.rows[i][0].tostring());
                        }
                    }
                }
                catch (exception ex)
                {
                    console.writeline(ex.message);
                }
            }
            console.read();

通过ibm提供的ibm.data.db2.dll

string strsql = @"select phone_no from no_store where id<5";
            string strconn = "database=数据库名;uid=用户名;pwd=密码;";
            using (db2connection conn = new db2connection(strconn))
            {
                db2command cmd = new db2command(strsql, conn);
                try
                {
                    conn.open();
                    db2dataadapter adp = new db2dataadapter(cmd);
                    dataset ds = new dataset();
                    adp.fill(ds);
                    datatable dt = ds.tables[0];
                    if (dt != null)
                    {
                        for (int i = 0; i < dt.rows.count; i++)
                        {
                            console.writeline("电话" + i + ":" + dt.rows[i][0].tostring());
                        }
                    }
                }
                catch (exception ex)
                {
                    console.writeline(ex.message);
                }
            }
            console.read();

小结
（1）两种方式的数据库操作对象可以参考c#连接sqlserver的数据库对象。
（2）如果db2数据库在远程服务器，连接字符串中的数据库名、用户名、密码为db2编目到本地的数据库名、用户名、密码。
（3）使用ibm.data.db2，必须引用该程序集。