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

C#Á¬½Óoracle£¬²éѯÊý¾Ý²Ù×÷

Õý³£µÄoracleÊý¾Ý²éѯÊÇSQL code:
select * from ta where rq>='30-mar-10' and rq<='4-apr-10'

µ«ÊÇÔÚC#Ìí¼Óʱ¼ä¿Ø¼þdateTimePicker1£¬
dateTimePicker4.Value.ToShortDateString()
ËûµÄʱ¼ä¸ñʽÊÇ¡®2010-3-30¡¯ÕâÑùµÄ£¬ÈçºÎ°Ñת»¯³Éoracle²éѯµÄ¸ñÊ½ÄØ
Èç¹ûûÓÐÏֳɵĺ¯Êý£¬Ö»ºÃ×Ô¼ºÐ´Ò»¸öº¯ÊýÁË
ÓÃstring.FormatÓ¦¸Ã²»»áºÜÀ§ÄÑ

C# code:
string sqltext = "select * from ta where rq>= to_date('"+ dateTimePicker4.Value.ToShortDateString() +"')"



¸Ðл¥ÉϵÄ


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

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

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

www.51aspx.com

ȥϠ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

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

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

1. Oracle sid ÕýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ