110,533
社区成员
发帖
与我相关
我的任务
分享
public static DataSet runSql(string sql)
{
OracleConnection conn = null;
try
{
logger.Debug("Running SQL: " + sql);
conn = (OracleConnection)DBUtils.getConnection();
DataSet ds = null;
using(conn)
{
if (sql.ToLower().StartsWith("select"))
{
conn.Open();
OracleCommand comm = new OracleCommand(sql);
comm.Connection = conn;
comm.CommandType = CommandType.Text;
OracleDataAdapter da = new OracleDataAdapter(comm);
ds = new DataSet();
da.Fill(ds);
}
// insert /delete/update
else
{
conn.Open();
IDbCommand comm = new OracleCommand(sql);
comm.Connection = conn;
comm.ExecuteNonQuery();
}
return ds;
}
}
catch (Exception e)
{
string m = "Error in running SQL: " + sql + "\r\nError Message: \r\n" + e.Message;
logger.Error(m);
throw new WBISException(m);
}
}