.net²Ù×÷OracleµÄ´úÂë - .NET¼¼Êõ / ASP.NET
³õѧ.net,Ҳû½Ó´¥¹ýoracle,²»ÖªµÀ¸ÃÈçºÎÏÂÊÖ¡£Íû¸ßÈËÖ¸µã¡£
ADO.NET
System.Data.OracleClient
OracleConnection
OraCommand
OraDataAdapter
ÐèÒªµÄÃü¿Õ¼ä
using System;
using System.Data;
using System.Data.OracleClient;
ORACLEµÄ°²×°ÅäÖá£È¥Ñ§Ï°Ñ§Ï°
http://oracle.chinaitlab.com/List_2.html
ѧϰ£¬½Ó·Ö
°¥ °ëÒ¹»ØÌû£¡ÎҸоõ»¹ÊÇÔÚ·¢µã´úÂë±È½ÏºÃ£¡ÔÚ¸øÂ¥Ö÷Ìù²¿·Ö´úÂ룡£¡
C# code:
/// <summary>
/// Ö´ÐвéѯÓï¾ä£¬·µ»ØOracleDataReader
/// </summary>
/// <param name="strOracle">²éѯÓï¾ä</param>
/// <returns>OracleDataReader</returns>
public static OracleDataReader ExecuteReader(string strOracle)
{
OracleConnection connection = new OracleConnection(connectionString);
OracleCommand cmd = new OracleCommand(strOracle, connection);
try
{
connection.Open();
OracleDataReader myReader = cmd.ExecuteReader();
return myReader;
}
catch (System.Data.OracleClient.OracleException e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// Ö´ÐвéѯÓï¾ä£¬·µ»ØDataSet
/// </su
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......