public static string constr="Data Source=netservice;user id=userid;password=password;persist security info=False";
public static bool ExeSql(string sql)
{
OracleConnection conn = new OracleConnection(config.constr);
OracleCommand cmd = new OracleCommand(sql);
cmd.Connection = oconn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
}
}
public static bool ExeSql(string sql)
{
OracleConnection conn = new OracleConnection(config.constr);
OracleCommand cmd = new OracleCommand(sql);
cmd.Connection = oconn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
}
}