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