ASP.NET 2.0Á¬½ÓOracle 10g
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;//ÒýÈëÃüÃû¿Õ¼ä
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
String connstr = "Data Source=orcl;User ID=system;Password=orcl;Unicode=True";
OracleConnection oraConn = new OracleConnection(connstr);
OracleDataAdapter da = new OracleDataAdapter("select * from lin", oraConn);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
Á¬½ÓÊôÐÔ»òÔÚweb.confgiÖеÄÅäÖÃ
Æäʵֱ½ÓдÉÏÃæµÄ´úÂë»á³ö²»ÉÙ´íÎóµÄ£¬Òª×öÁ½¸ö¹¤×÷²Å¿ÉÒÔ¡£
1. ASP.NET2.0ÀïĬÈϲ»ÄÜÖ±½ÓÌí¼Óusing System.Data.OracleClient;ÐèÒªÔÚÌî¼ÓÒýÓõÄ.NET×é¼þ¿òÀïÑ¡ÔñSystem.Data.OracleClientÌí¼Óºó²ÅÄÜÓá£
2. ÔÚASP.NET1.1Öе÷ÓÃWeb.configÖеÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®Ê±Ê¹ÓÃÓï¾äSystem.Configuration.ConfigurationSettings.AppSettings["oracle"];,ÔÚ2.0ÀïÐëҪʹÓÃSystem.Configuration.ConfigurationManager.AppSettings["oracleconn"];,²¢ÇÒÐèÏÈÔÚÌî¼ÓÒýÓõÄ.NET×é¼þ¿òÀïÑ¡ÔñSystem.ConfigurationÌí¼Óºó²ÅÄÜÓá£
3.ÒÔÉϲÉÓõÄÊÇ´ÓASP.NETÇ¨ÒÆÀ´µÄ´úÂë·ç¸ñ£¬Èç¹û²ÉÓÃ2.0ÖеÄconnectionStrings,ÐèÒªÐ޸ĵĴúÂëÈçÏÂ:
Web.Config
<connectionStrings>
<add name="oracleconn" connectionString="User ID=Óû§Ãû;Password=ÃÜÂë;Data Source=Êý¾Ý¿â·þÎñÃû" providerName="System.Data.OracleClient"/>
</connectionStrings>
´úÂëÈçÏÂÐèÒªÐÞ¸Ä,ÆäËû¶¼²»±ä:
string strcon = Syste
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤
ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃæ¹¤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle OraDb10g_home1”&mdash ......
Oracle Database 10g ÌṩÁËÒ»¸öÏÔÖø¸Ä½øµÄ¹¤¾ß£º×Ô¶¯¹¤×÷¸ºÔØÐÅÏ¢¿â (AWR:Automatic Workload Repository)¡£Oracle ½¨ÒéÓû§ÓÃÕâ¸öÈ¡´ú Statspack¡£AWR ʵÖÊÉÏÊÇÒ»¸ö Oracle µÄÄÚÖù¤¾ß£¬Ëü²É¼¯ÓëÐÔÄÜÏà¹ØµÄͳ¼ÆÊý¾Ý£¬²¢´ÓÄÇЩͳ¼ÆÊý¾ÝÖе¼³öÐÔÄÜÁ¿¶È£¬ÒÔ¸ú×ÙDZÔÚµÄÎÊÌâ¡£Óë Statspack ²»Í¬£¬¿ìÕÕÓÉÒ»¸ö³ÆÎª MMON µÄеĺó ......
×î½üÒ»¶Îʱ¼äһֱûд²©¿Í£¬²»ÊÇÀÁ£¬ÊÇѧÁËÌ«¶à¶«Î÷¡£ÒÔºóÂýÂý²¹ÉÏ¡£ 1. odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´ odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´Ê×ÒªÌõ¼þ£º°²×°oracle client¡£°²×°ÍêÖ®ºóÌí¼Ó£¬µ«ÊÇ»¹±ØÐëÔÚ°²×°Ä¿Â¼ÏÂͨ³£ÊÇC:\oracle\ora90\network\ADMIN\tnsnames.oraÖÐÌí¼ÓÒ»¸öÁ¬½Ó£¬Èçϸñʽ£º DXS =
(DESCRIPTION =
......
½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾÀ¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤ÆÚ¼Æ»®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......