.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
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......