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ÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡
www.51aspx.com
ȥϠ......
Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......