記錄一下C#+Oracle批量插入的一個方法

標籤：blog   io   ar   for   on   div   log   cti   ad   

public bool insertOracle(DataTable dataTable, string sql) //  Oracle SQL 查詢的是表頭        {            string ConnStr = WirelessCenterDAL.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;                }            }        }

　　

記錄一下C#+Oracle批量插入的一個方法