快捷導(dǎo)航

C#連接db2數(shù)據(jù)庫(kù)的實(shí)現(xiàn)方法

更新時(shí)間：2013年05月31日 15:31:32 作者：

本篇文章是對(duì)C#連接db2數(shù)據(jù)庫(kù)的方法進(jìn)行了詳細(xì)的分析介紹，需要的朋友參考下

通過OLE DB for DB2驅(qū)動(dòng)

string strSql = @"select phone_no from no_store where id<5";
            string strConn = "Provider=IBMDADB2;Data Source=數(shù)據(jù)庫(kù)名;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

復(fù)制代碼代碼如下:

string strSql = @"select phone_no from no_store where id<5";
            string strConn = "Database=數(shù)據(jù)庫(kù)名;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();

小結(jié)
（1）兩種方式的數(shù)據(jù)庫(kù)操作對(duì)象可以參考c#連接sqlserver的數(shù)據(jù)庫(kù)對(duì)象。
（2）如果db2數(shù)據(jù)庫(kù)在遠(yuǎn)程服務(wù)器，連接字符串中的數(shù)據(jù)庫(kù)名、用戶名、密碼為db2編目到本地的數(shù)據(jù)庫(kù)名、用戶名、密碼。
（3）使用IBM.Data.DB2，必須引用該程序集。

您可能感興趣的文章: