datatables oracle,用OracleDataAdapter将DataTable写入Oracle数据库

using System;

using System.Configuration;

using System.Data;

using System.Data.OracleClient;

using System.Collections;

......

......

......

public static int ExecuteDataTable(DataTable dt)

{

//创建一个连接对象

using (OracleConnection connection = new OracleConnection(ConnectionString))

{

OracleDataAdapter OracleAdapter = new OracleDataAdapter();

//#region  查询

//OracleAdapter.SelectCommand = new OracleCommand();

//OracleAdapter.SelectCommand.CommandType = CommandType.Text;

//OracleAdapter.SelectCommand.CommandText = "SELECT JSDM,JSMC,JSMS,SCBS,JSLXDM FROM HT_YHJS  ";

//OracleAdapter.SelectCommand.Connection = connection;

//#endregion

#region  添加

string insertSql = "INSERT INTO HT_YHJS (JSDM,JSMC,JSMS,JSLXDM) VALUES (:JSDM,:JSMC,:JSMS,:JSLXDM)";

OracleAdapter.InsertCommand = new OracleCommand();

OracleAdapter.InsertCommand.CommandType = CommandType.Text;

OracleAdapter.InsertCommand.CommandText = insertSql;

OracleParameter[] insertParms = {

new OracleParameter(":JSDM", OracleType.VarChar, 6, "JSDM"),

new OracleParameter(":JSMC", OracleType.VarChar, 20, "JSMC"),

new OracleParameter(":JSMS", OracleType.VarChar, 120, "JSMS"),

new OracleParameter(":JSLXDM", OracleType.Char, 10, "JSLXDM")

};

OracleAdapter.InsertCommand.Parameters.AddRange(insertParms);

OracleAdapter.InsertCommand.Connection = connection;

#endregion

#region  更新

string updateSql = "UPDATE HT_YHJS SET JSMC=:JSMC, JSMS=:JSMS, JSLXDM=:JSLXDM WHERE JSDM=:JSDM";

OracleAdapter.UpdateCommand = new OracleCommand();

OracleAdapter.UpdateCommand.CommandType = CommandType.Text;

OracleAdapter.UpdateCommand.CommandText = updateSql;

OracleParameter[] updateParms = {

new OracleParameter(":JSMC", OracleType.VarChar, 20 , "JSMC"),

new OracleParameter(":JSMS", OracleType.VarChar, 120, "JSMS"),

new OracleParameter(":JSLXDM", OracleType.Char, 10, "JSLXDM"),

new OracleParameter(":JSDM", OracleType.VarChar, 6, "JSDM")

};

updateParms[0].IsNullable = false;

OracleAdapter.UpdateCommand.Parameters.AddRange(updateParms);

OracleAdapter.UpdateCommand.Connection = connection;

#endregion

#region  删除

string deleteSql = "DELETE FROM HT_YHJS WHERE JSDM=:JSDM";

OracleParameter[] deleteParms = {

new OracleParameter(":JSDM", OracleType.VarChar, 6,"JSDM")

};

OracleAdapter.DeleteCommand = new OracleCommand();

OracleAdapter.DeleteCommand.CommandType = CommandType.Text;

OracleAdapter.DeleteCommand.CommandText = deleteSql;

OracleAdapter.DeleteCommand.Parameters.AddRange(deleteParms);

OracleAdapter.DeleteCommand.Connection = connection;

#endregion

int r = OracleAdapter.Update(dt);

dt.AcceptChanges();

return r;         }