测试 Oracle9+asp.net 2.0。
web.config
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
default.aspx.cs
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string ConnectString = System.Configuration.ConfigurationManager.AppSettings["ConnectString"];
OracleConnection conn = new OracleConnection(ConnectString);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
try
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from web.news order by web.news.id desc";
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Response.Write("<a href="read.aspx?id=" + dr.GetOracleValue(0) + "" mce_href="read.aspx?id=" + dr.GetOracleValue(0) + "">" + dr.GetOracleString(1) + "</a><br/>");
}
dr.Close();
}
catch (Exception ee)
{
Response.Write(ee.Message.ToString());
}
finally
{
conn.Close();
}
}
}