C#Á¬½ÓoracleÊý¾Ý¿â£¬²éѯ³öÀ´µÄÖÐÎÄÊý¾ÝÊÇÂÒÂë
C#Á¬½ÓoracleÊý¾Ý¿â£¬²éѯ³öÀ´µÄ±íµÄÖÐÎÄÊý¾ÝÊÇÂÒÂë
×¢²á±íÀïµÄ×Ö·û¼¯ÒѾ¸Ä¹ýÁË£¬ÓÃPBÖ±½Ó²é£¬ÖÐÎÄÏÔʾÕý³£
Çë¸ßÊÖÓèÒÔ½â¾ö
ûÈ˻شðÂð£¿
oracle ×Ö·û¼¯ÂÒÂë½â¾ö
Äã¼Ç¼ÄÇÖÐÎĵÄÄǸö×ֶΣ¬ÓÃʲôÊý¾ÝÀàÐÍ£¬Ò»°ãÓÐÖÐÎĵÄÔÚsqlÖÐÒªÓÃnvarcharÊý¾ÝÀàÐÍ£¬²»È»Ò²»á³öÏÖÂÒÂ룡
ÒÔǰ·¢¹ýÒ»¸öÌû×Ó£¬Ã»ÓÐʵ¼Ê½â¾ö£¬¿´À´Õâ¸öÌû×ÓÓÖÒªÂñûÁË
°ïÄ㶥һϣ¡ÄãµÃ˵Ã÷ÄãÈ¡³öµÄ×Ö¶ÎÔÚOracleÖÐÊÇʲôÀàÐͰ¡£¬ÄãÓÖÊÇÔõôдµÄ´úÂëÀ´ÏÔʾÕâ¸ö½á¹ûµÄ°¡
Äã±¾µØµÄ±àÂëÊÇ·ñÕýÈ·ÄØ
¿Í»§¶ËµÄ×Ö·û¼¯£¬ÎÒÒѾÔÚ×¢²á±íÀï¸Ä¹ýÁË£¬Óë·þÎñÆ÷Ò»ÖÂ
ÖÁÓÚÊý¾ÝÀàÐÍʲôÎÒÒ²²»ÖªµÀ£¬ÒòΪ²»ÄܽӴ¥·þÎñ¶Ë
ÎÒµÄÓï¾äÊÇ
C# code:
DataTable dta4 = new DataTable();
oda4.Fill(dta4);
dataGridView6.DataSource = dta4;
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......