C sharp 如何连接DB2数据库？.doc

C#如何连接DB2数据库？ 项目中遇到的。net（C#） 连接DB2问题，解决了，和大家分享一下。 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);/创建DB2的数据源连接 /这里是用数据源连接的 /DataSourceName 数据源名称 /UserName 用户名 /pwd 用户口令 /OdbcCommand SqlConnection conSql = new SqlConnection(Data Source=oadatabaseuserdb2005;Initial Catalog=GongChengGuanLi;Persist Security Info=True;User ID=sqlUserName;Password=SqlPassword);/Sql2005的数据库连接 DB2Connection.Open();/打开DB2的数据源连接 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中读取数据 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