.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
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
asp.netÅúÁ¿ÉÏ´«Í¼Æ¬×îºÃÓÐÔ´Â룬ÔÚÏߵȣ¡£¡£¡£¡£¡£¡£¡
Ô´ÂëºÜ³¤µÄ¡£
²Î¿¼
C# code:
HttpFileCollection files = HttpContext.Current.Request.Files;
if (files.Count <= 1)
{
......
¸÷λ´óÏÀ£¬ÎÒѧϰµÄÊÇASP.NET£¬ÏëÖªµÀÏà¹Ø¼¼ÊõÓÐÄÄЩ£¬¾ÍÏñJAVA EEÖÐÓÐstruct sping jsp severlet µÈ£¬ASP.NET»¹ÓÐÄÄЩЩÏà¹Ø¼¼Êõ¡£
http://topic.csdn.net/u/20090914/21/af27de99-f0f3-4cfd-9379-13764f8ec6b1.ht ......
ÔõÑù½«ASP³ÌÐòת»»Îª.NET³ÌÐò ?
ÕÒ¸öÈ«²Å·Òë¡£
ÊÖ¶¯È¥Ð´
¸Ð¾õд¹ýaspµÄ£¬À´Ð´asp.net£¬ÉÏÊÖÓ¦¸Ã¿ìµã¡£
¸üÄÜÀí½âasp.netµÄһЩÄÚ²¿¼¼Êõ
asp.net¶¼±»·â×°ÁË
ÎÒÊÇ×ö.NetµÄ£¬¶ÔASPһֱû½Ó´¥µ½£¬ºÜİÉú¡£
¹« ......