记录一下C#+Oracle批量插入的一个方法

最新推荐文章于 2023-12-13 16:17:38 发布

转载最新推荐文章于 2023-12-13 16:17:38 发布

· 394 阅读

3 ·

版权

原文链接：http://www.cnblogs.com/qianlovebeijixiong/p/4158020.html

文章标签：

#数据库 #c#

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;
                }
            }
        }

转载于:https://www.cnblogs.com/qianlovebeijixiong/p/4158020.html