C sharp 如何連接DB2數(shù)據(jù)庫(kù)？.doc

C#如何連接DB2數(shù)據(jù)庫(kù)？ 項(xiàng)目中遇到的。net（C#） 連接DB2問(wèn)題，解決了，和大家分享一下。 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.Odbc; using System.Data.SqlClient; using System.Data; namespace DB2Import class Program static void Main(string args) OdbcConnection DB2Connection = new OdbcConnection(Dsn=DataSourceName;uid=UserName;pwd=mismidas);/創(chuàng)建DB2的數(shù)據(jù)源連接 /這里是用數(shù)據(jù)源連接的 /DataSourceName 數(shù)據(jù)源名稱(chēng) /UserName 用戶(hù)名 /pwd 用戶(hù)口令 /OdbcCommand SqlConnection conSql = new SqlConnection(Data Source=oadatabaseuserdb2005;Initial Catalog=GongChengGuanLi;Persist Security Info=True;User ID=sqlUserName;Password=SqlPassword);/Sql2005的數(shù)據(jù)庫(kù)連接 DB2Connection.Open();/打開(kāi)DB2的數(shù)據(jù)源連接 SqlDataAdapter ZDAdapter = new SqlDataAdapter(new SqlCommand(Select * from SCD_GXDY_XGJL, conSql); SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(ZDAdapter); DataSet ZDDataSet = new DataSet(); ZDAdapter.Fill(ZDDataSet, SCD_GXDY_XGJL); for (int i = 0; i ZDDataSet.TablesSCD_GXDY_XGJL.Rows.Count; i+) Console.WriteLine(importing +i+ .); DataRow row = ZDDataSet.TablesSCD_GXDY_XGJL.Rowsi; int KHDM = 0; try KHDM = int.Parse( + rowKHDM); catch (Exception paresException) KHDM = 0; /KHDM if ( + rowKHDM != & KHDM!=0) OdbcCommand cmdSelect = new OdbcCommand(Select CCUST,CNME,CTYPE,CLOC,CMDPFX from V6tstF.RCM where CCUST= +KHDM+ , DB2Connection); OdbcDataReader odbcReader= cmdSelect.ExecuteReader(); if (odbcReader.Read()/從DB2中讀取數(shù)據(jù) rowCNME = +odbcReaderCNME; rowCTYPE = + odbcReaderCTYPE; rowCLOC = + odbcReaderCLOC; rowCMDPFX = + odbcReaderCMDPFX; odbcReader.Close(); Console.WriteLine(Updating .); ZDAdapter.Update(ZDDataSet, SCD_GXDY_XGJL); Console.WriteLine(Commplete!); Console.WriteLine(Press any Key to Exit!); Console.Re