5,889
社区成员
发帖
与我相关
我的任务
分享
string conString = @"driver={IBM DB2 ODBC DRIVER};database=bl_devp;hostname=192.20.30.107;
port=50000;protocol=TCPIP;uid=db2inst1;pwd=db122; CurrentSchema=zz";
OdbcConnection con = new OdbcConnection(conString);
con.Open();
OdbcCommand cmd = new OdbcCommand("select * from tbd21esign", con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("OK");
string conString = @"Server=192.20.30.107:50000;Database=bl_devp;UID=db2inst1;PWD=db122;
CurrentSchema=zz;Connection Lifetime=60;Connection Reset=false;Max Pool Size=5;
Min Pool Size=3;Pooling=True;Connect Timeout=15";
DB2Connection con = new DB2Connection(conString);
con.Open();
DB2Command cmd = new DB2Command("select * from tb21esign", con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("OK");
string connectString = @"Database=BL_DEVP;User ID=db2inst1;Password=db122;Server=192.20.30.107:50000;
CurrentSchema=zz;Connection Lifetime=60;Connection Reset=false;Max Pool Size=5;
Min Pool Size=3;Pooling=True;Connect Timeout=15";
DbProviderFactory dbFactory = DbProviderFactories.GetFactory("IBM.Data.DB2");
Microsoft.Practices.EnterpriseLibrary.Data.Database database = new GenericDatabase(connectString, dbFactory);
DbCommand dbCmd = database.GetSqlStringCommand("select * from zz.tb21esign");
database.ExecuteNonQuery(dbCmd);
MessageBox.Show("OK");
string connectionString = "Dsn=departdb;uid=db2admin;pwd=db2;Database=departdb;";
string sql = "select * from administrator.CENTERTODEPT_APPLICATION";
System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(connectionString);
cn.Open();
System.Data.Odbc.OdbcDataAdapter adapter = new System.Data.Odbc.OdbcDataAdapter(sql, cn);
System.Data.DataSet ds = new DataSet();
adapter.Fill(ds);
this.DataGrid1.DataSource = ds.Tables[0];
cn.Close();
DataGrid1.DataBind();
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=oadatabase\\userdb2005;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.Tables["SCD_GXDY_XGJL"].Rows.Count; i++)
{
Console.WriteLine("importing "+i+" .....");
DataRow row = ZDDataSet.Tables["SCD_GXDY_XGJL"].Rows[i];
int KHDM = 0;
try
{
KHDM = int.Parse("" + row["KHDM"]);
}
catch (Exception paresException)
{
KHDM = 0;
}
//KHDM
if ("" + row["KHDM"] != "" && 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中读取数据
{
row["CNME"] = ""+odbcReader["CNME"];
row["CTYPE"] = "" + odbcReader["CTYPE"];
row["CLOC"] = "" + odbcReader["CLOC"];
row["CMDPFX"] = "" + odbcReader["CMDPFX"];
}
odbcReader.Close();
}
}
Console.WriteLine("Updating ....");
ZDAdapter.Update(ZDDataSet, "SCD_GXDY_XGJL");
Console.WriteLine("Commplete!");
Console.WriteLine("Press any Key to Exit!");
Console.Read();
}
}
}