SqlConnection SQL_Conn = new SqlConnection("SQLServer数据库连接字符串");
SqlDataAdapter SQL_Dap = new SqlDataAdapter("select 列名1,列名2... from SQL表名", SQL_Conn);
DataSet SQL_ds = new DataSet();
SQL_Dap.Fill(SQL_ds, "SQL表名称");
OracleConnection Ora_Conn = new OracleConnection("Oracle数据库连接字符串");
OracleDataAdapter Ora_Dap = new OracleDataAdapter("select 列名1,列名2... from 表名1", Ora_Conn);
DataSet Ora_da = new DataSet();
Ora_Dap.Fill(Ora_da, "表1");
Ora_Dap.InsertCommand = Ora_Conn.CreateCommand();
Ora_Dap.InsertCommand.CommandText = "insert into 表名1 (列名1,列名2...) values(@列名1变量,@列名2变量...)";
OracleParameter par;
par = Ora_Dap.InsertCommand.Parameters.Add("@列名1变量", OracleType.VarChar, 255);
// 必须设置源列名(SQL表名称中的列名)
par.SourceColumn = "列名1";
par.SourceVersion = DataRowVersion.Current;
par = Ora_Dap.InsertCommand.Parameters.Add("@列名2变量", OracleType.VarChar, 255);
// 必须设置源列名(SQL表名称中的列名)
par.SourceColumn = "列名2";
par.SourceVersion = DataRowVersion.Current;
for (int i = 0; i < SQL_ds.Tables["SQL表名称"].Rows.Count; i++)
{
Ora_da.Tables["表1"].Rows.Add(new string[] { SQL_ds.Tables["SQL表名称"].Rows[i][0].ToString(), SQL_ds.Tables["SQL表名称"].Rows[i][1].ToString() });
}
// 使用适配器的更新命令,将内存中的表更新至数据库
Ora_Dap.Update(Ora_da);
// 更新第二章表类似