Exemplo n.º 1
0
        /// <summary>
        /// 更新表,带事务
        /// </summary>
        /// <param name="dt">表</param>
        /// <param name="con">数据库连接</param>
        public void Update(DataTable dt, IDbConnection con, IDbTransaction ts)
        {
            OracleDataAdapter    sda = new OracleDataAdapter();
            OracleCommandBuilder scb = new OracleCommandBuilder(sda);

            try
            {
                sda.SelectCommand             = new OracleCommand("SELECT * FROM " + dt.TableName, con as OracleConnection);
                sda.SelectCommand.Transaction = ts as OracleTransaction;
                scb.RefreshSchema();
                sda.Update(dt);
            }
            catch (OracleException ex)
            {
                throw (ex);
            }
        }