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

C#Á´½ÓORACLEÖ´ÐÐ ´æ´¢¹ý³Ì ·µ»ØDATASET

ÈçÌ⣬ÎÒÏëͨ¹ýoracleµÄÒ»¸ö´æ´¢¹ý³Ì·µ»ØÒ»¸öDATASET£¬¿ÉÊÇÔõôҲʵÏÖ²»ÁË£¬ÔÚÍøÉÏ¿´ÄÇЩ˵½¨°ü¿ÉÎÒŪ²»ºÃ£¬ÅªÁ˺ü¸ÌìÍ·´óÁË£¬Ë­ÓпÉÒԳɹ¦Ö´ÐеĴúÂë¿ÉÒÔ·¢Ò»¶Î¸øÎÒ£¬»òÕßÖ¸µãÏ´ó¸ÅÔõôŪ£¬ÍøÉÏ¿½±´µÄ±ðÀ´¡£ÏÈлл¸÷λ¡£
?¸÷λ½Ì½ÌÎÒ£¬Í·ÌÛÁ˺ü¸ÌìÁË

²Î¿¼

..

ȷʵÊǸöÎÊÌ⣬¸ßÊÖ°ïæÁË¡£¡£


¹Ø×¢

Â¥ÉÏ£¬ÄãµÄLonely ÔÚÄÄÀï¸ÄµÄ£¿ÎÒÔõôÕÒ²»µ½

Çëliangxian°ïÎÒ¿´¿´ÎÒÕâ¸öÄÄÀïÓÐÎÊÌ⣬
ÏÂÃæÊǽ¨°üµÄ
CREATE OR REPLACE package SCOTT.pk_wt
is
type mytype is ref cursor;
procedure p_wt(mycs out mytype);
return varchar2;
end;
/
CREATE OR REPLACE package BODY SCOTT.pk_wt
is
procedure p_wt(mycs out mytype)
is
begin
open mycs for select * from TMP_HIS_PPTN_JP;
end p_wt;
end pk_wt;
/
ÔÙÏÂÃæÊÇC#Óï¾ä£¬¿ÉÊÇÖ´ÐÐ×ÜÊDZ¨´í


OracleConnection con = new OracleConnection(BaseCollection.getLogo());//×ÔÒѶ¨ÒåµÄÊý¾Ý·ÃÎʽӿÚ
            con.Open();
            OracleCommand cmd = new OracleCommand("pk_wt.p_wt", con);
            cmd.CommandType = CommandType.StoredProcedure;
            OracleParameter p1 = new OracleParameter("mycs", OracleType.Cursor);
            p1.Direction = System.Data.ParameterDirect


Ïà¹ØÎÊ´ð£º

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

¼±ÇóASP¡£NETC#¹ºÎï³µ´úÂë

×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡

www.51aspx.com

ȥϠ......

developer suiteÁ´½Óµ½oracle·þÎñÆ÷

Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ