Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

C#¿ª·¢oracleµÄÎÊÌâ

±¾²ËÄñÔÚÁ·Ï°Ê¹ÓÃvs2005¿ª·¢oracle10gÊý¾Ý¿âʱ£¬³öÏÖÏÂÃæµÄ´íÎ󣬴Óû½Ó´¥¹ýorcale£¬Ï£Íû¸÷λ´óÏÀ°ïСµÜ½â´ðÒɻ󡫡«Ð»Ð»£¡


µ±"select * from companyinform"ȱÉÙ¡°;¡±Ê±£¬´íÎóÌáʾÈçÏÂͼ£º



PS£ºoracleÊý¾Ý¿âºÍvs2005¶¼×°ÔÚͬһ·þÎñÆ÷ÉÏ£¬·þÎñÆ÷win2003SP2
Ï£ÍûºÃÐÄÈ˰ïÐÂÊÖÏ¡«¡«

select * from dbo.companyinform , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£

Ã²ËÆÃ»ÓÐÕâ¸ö±í ¡£¡£¡£

sqloda.Fill(xxx,xxx)
ΪʲôÄãÒªÌîµÚ¶þ¸ö²ÎÊý£¿ Ö»ÓÐdatasetÀïÃæÓÐÃûΪxxxµÄtableʱ²ÅÄÜÕâÑùÓðÉ

×¢ÒâÄãµÄconnStringÖеÄÕË»§ÊÇ·ñ¾ßÓзÃÎʴ˱íµÄȨÏÞ

È¥µô";",ÔÚ²éѯÓï¾äµÄ±íÃûǰ£¬¼ÓÉÏÃüÃû¿Õ¼ä°É...
ÒýÓÃ
select * from dbo.companyinform  , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£


µÚ¶þÕÅͼµÄ´úÂëÊǶԵģ¬×Ô¼º¼ì²éÊý¾Ý¿â£¬¿´±íÃû¶Ô²»¶Ô£¬¿´ÏÂÄãµÇ½µÄÕʺÅÏÂÃæÓÐûÓÐÕâ¸ö±í

ÒýÓÃ
È¥µô";",ÔÚ²éѯÓï¾äµÄ±íÃûǰ£¬¼ÓÉÏÃüÃû¿Õ¼ä°É...
ÒýÓà 2 Â¥ kyoybs µÄ»Ø¸´:select * from dbo.companyinform  , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£


Ê×ÏȸÐл¸÷λµÄ½â´ð£¬µ«ÊÇ»¹ÊÇû½â¾ö¡£oracleÊý¾Ý¿âµÄÁ¬½Ó×Ö·û´®Îª£º

connstring = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=JSC)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=WebServiceTest)));User Id=wsdb;Password=ws


Ïà¹ØÎÊ´ð£º

C#·¢Óʼþ21cn

21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½Ô­Òò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ