²¿ÊðASP.NET·ÃÎÊoracleÌáʾÕÒ²»oracle¿Í»§¶Ë×é¼þÎÊÌâ
Ç°Á½Ì콫×Ô¼º±¾»úÆ÷ÖеÄASP.NETÓ¦Óò¿Êðµ½ÁË·þÎñÆ÷ÉÏ,½á¹û³öÏÖÁËЩÎÊÌâ.ÕÛÌÚÁËÁ½Ìì²Å¸ãÇå³þ.
Ê×ÏÈ·¢ÏÖ°²×°.NET3.5ʱºòÐèÒªÁ¬½ÓInternet,(Æäʵ°²×°°üÍêÕûµÄÀëÏß°²×°°ü)¶ø·þÎñÆ÷ÊÇÄÚ²¿ÍøÂçµÄ,ÿ°ì·¨Ö»ÄÜ°²×°Ò»¸öVS2008ÉÏÈ¥,Õæ²»Ã÷°×ΪºÎ°²×°VSʱºòdotNetFrameworkÓÖ²»ÐèÒªÁ¬½ÓInternetÁË.
ºóÀ´·¢ÏÖÔÚ±¾»úÆ÷ûÓÐÎÊÌâµÄÓ¦Óò¿ÉÏÈ¥ºóÓÖ²»ÄÜ·ÃÎÊÊý¾Ý¿âÁË(ʹÓÃOLEDB·½Ê½Á¬½ÓµÄORACLE),Ìáʾ±¾»úÆ÷δ°²×°oracle8.17ÒÔÉϵĿͻ§¶Ë,(ÒѾ°²×°ÁË,¶øÇÒÓÃsqlplus¿ÉÒÔ·ÃÎÊ)¿ªÊ¼ÒÔΪÊÇoralce°²×°³öÁËÎÊÌâÓÖ°²×°ÁËoracle9.2¿Í»§¶ËÒ²Ò»Ñù,ºóÀ´google²ÅÖªµÀÊÇNTFSÎļþϵͳ°²È«ÎÊÌâ,½â¾ö·½·¨£º ÔÚoracle/binĿ¼£¬¼ÓÈë¸øÒÔÏÂÓû§/×é,ÊÚÍêȫȨÏÞ:
asp.net machine account
administrator
authenticated users
²¢ÇÒ½«Asp.net¼ÓÈëµ½administrator×飬ÔÙÖØÆô
ºóÓÖ³öÏÖ´íÎó,ÌáʾÎÞ·¨»ñÈ¡Oracle´íÎóÐÅÏ¢,googleÁËϲÅÖªµÀʹжÔØoralce8.17ûÓÐɾ³ý×¢²á±íÐÅÏ¢°²×°oracle9.2¾ÍÎÞ·¨Ð´×¢²á±íÁË.ËùÒÔжÔغóÐèÒªÊÖ¹¤ÇåÀí×¢²á±í,ºóÔÚ°²×°.
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
/*sum()over()*/
--ĬÈϼÆËãËùÓÐÐеĺϼÆ
select t.empno,t.ename,t.sal,t.deptno,sum(t.sal)over()
from scott.emp t;
--partition by·Ö×éºÏ¼Æ
select t.empno,t.ename,t.sal,t.deptno,
sum(t.sal)over(partition by t.deptno)
from scott.emp t
order by t.deptno,t.sal;
......
alter table t_att_over_haul_safe_pres add c clob;
update t_att_over_haul_safe_pres set c=prt_precautions;
alter table t_att_over_haul_safe_p ......
1.GridViewÎÞ´úÂë·ÖÒ³ÅÅÐò£º
Ч¹ûͼ£º
1.AllowSortingÉèΪTrue£¬aspx´úÂëÖÐÊÇAllowSorting="True"£»
2.ĬÈÏ1Ò³10Ìõ£¬Èç¹ûÒªÐÞ¸ÄÿҳÌõÊý£¬ÐÞ¸ÄPageSize¼´¿É£¬ÔÚaspx´úÂëÖÐÊÇPageSize="12"¡£
3.ĬÈϵÄÊǵ¥ÏòÅÅÐòµÄ£¬ÓÒ»÷GridViewµ¯³ö“ÊôÐÔ”£¬Ñ¡ÔñAllowSortingΪTrue¼´¿É¡£
2.GridViewÑ¡ÖУ¬±à¼£¬È¡Ïû£¬É¾³ ......