public bool Insertoracle (DataTable DataTable, String sql)//Oracle SQL query is table header {string connstr = Wirel essCenterDAL.Common.GetConnDMS1; using (OracleConnection conn = new OracleConnection (connstr)) {try { OracleCommand cmd = new OracleCommand (SQL, conn); OracleDataAdapter adapter = new OracleDataAdapter (cmd); Oraclecommandbuilder cb = new Oraclecommandbuilder (adapter); DataTable dsnew = new DataTable (); int count = adapter. Fill (dsnew); for (int i = 0; i < DataTable.Rows.Count; i++) {DataRow Dr = Dsnew.newrow (); for (int j = 0; J < DataTable.Columns.Count; J + +) { DR[DSNEW.COLUMNS[J]. ColumnName] = Datatable.rows[i][j]; } dsNew.Rows.Add (DR); } count = adapter. Update (dsnew); Adapter. UpdateBatchSize = 5000; Adapter. Update (dataTable); return true; } catch (Exception ex) {//loghelper.writeerrlog ("Insertoracle", ex. Message); return false; } } }
Record a way to c#+oracle BULK INSERT