public int SaveDataTable(string safeSql, DataTable dt) { try { open(); switch (dbtype) { case "Mssql": cmd_mssql.CommandText = safeSql; SqlDataAdapter da_mssql = new SqlDataAdapter(cmd_mssql); SqlCommandBuilder cb_mssql = new SqlCommandBuilder(da_mssql); return(da_mssql.Update(dt)); //case "Access": // cmd_access.CommandText = safeSql; // OleDbDataAdapter da_access = new OleDbDataAdapter(cmd_access); // OleDbCommandBuilder cb_access = new OleDbCommandBuilder(da_access); // return da_access.Update(dt); case "Oracle": cmd_oracle.CommandText = safeSql; DDTek.Oracle.OracleDataAdapter da_oracle = new DDTek.Oracle.OracleDataAdapter(cmd_oracle); DDTek.Oracle.OracleCommandBuilder cb_oracle = new DDTek.Oracle.OracleCommandBuilder(da_oracle); return(da_oracle.Update(dt)); default: throw new Exception("无法识别的数据库类型!"); } } catch (Exception ex) { throw new Exception(ex.Message); } }
internal HyOracleCommandBuilder(DDTek.Oracle.OracleCommandBuilder innerBuilder) { this.InnerBuilder = innerBuilder; }