C#½«¿ÕÖµ´«Èëµ½Oracle×Ö¶ÎÀàÐÍΪDatatimeµÄ×Ö¶Î
½ñÌì×öÏîÄ¿µÄʱºò£¬½«null´«ÈëOracleµÄ±íÖУ¬¾ÍÊDz»³É¹¦
¾¹ý³¢ÊԵóöÁËÁ½¸ö½â¾ö·½°¸£º
1.´«ÈëOracleDateTime.NULL
2.Nullable<DateTime> optime = DBNull.Value; ´«Èëoptime(¿ªÊ¼ÍøÉÏÕҵĴð°¸ÊÇNullable<DateTime> optime = null·¢ÏÖ»¹Êǻᱨ´í)
Ïà¹ØÎĵµ£º
OracleÖÐÌṩһϵÁÐÀàÐÍ£¬Ã¿¸öÀàÐ͵ÄÌصãÈçÏ£º
char£º´æ´¢¹Ì¶¨³¤¶ÈµÄ×Ö·û£¬Èç¹û×Ö·û³¤¶È²»¹»»áÔÚÓұ߲¹¿Õ¸ñ¡£±ÈÈ磺name char£¨10£©£¬µ±¸øname¸³ÖµÎª'zhangsan'ʱ»áÔÚÓұ߲¹³ä2¸ö¿Õ¸ñ¡£charÀàÐ͵ÄÈÝÁ¿Îª1¡«2000B£¬Ã»ÓÐÖ¸¶¨ÔòĬÈϳ¤¶ÈΪ1¡£
varchar2£º´æ´¢³¤¶È¿É±äµÄ×Ö·û£¬ºÍcharÀàÐ͵IJ»Í¬£¬Ëü²»»á×Ô¶¯²¹³ä¿Õ¸ñ£¬ÇÒ¶¨ÒåÊ ......
¡¡¡¡¡¡ÓÃc#¸øPDA×öÁËÒ»¸öPC¶ËµÄͨѶ³ÌÐò£¬ÐèÒª±£´æÁ½¸ö²ÎÊý¡£ÓÃDelphiʱ£¬ÊDZ£´æÔÚiniÎļþÖУ¬c#¶ÁдXML±È½Ï·½±ã£¬¾ÍÓÃxmlÎļþÀ´±£´æÁË¡£
¡¡¡¡¡¡
¡¡
class CXmlClass
{
private string XmlFilePath;
/// <summary>
/// ÏÂÔص½PDAµÄTXTÎļþ·¾¶¡¡
/// </summary>
......
±ÈÈçÓÃÒ»¸öÀàÃèÊöÒ»ÕźÏͬ£¬¶øÕâ¸öÀàʵÀý»¯ºóÆäÖеÄ×ֶα£´æןÏͬµÄÐÅÏ¢£¬Èç¹ûÏÖÔÚÒª°ÑÕâ¸öÀàµÄʵÀý·¢Ë͵½Áíһ̨»úÆ÷¡¢ÁíÒ»¸ö´°Ìå»òÊÇÏë±£´æÕâ¸öÀàÒÔ±ãÒÔºóÔÙÈ¡³öÀ´Ó㨳־û¯¶ÔÏ󣩣¬¿ÉÒÔ¶ÔÕâ¸öÀà½øÐÐÐòÁл¯£¨ÐòÁл¯Êµ¼ÊÉÏÊÇÒ»¸öÐÅÏ¢Á÷£©£¬´«ËÍ»ò±£´æ£¬ÓõÄʱºòÔÙ·´ÐòÁл¯ÖØÐÂÉú³ÉÕâ¸ö¶ÔÏó
ΪʲôÄúÏëҪʹÓÃÐòÁл¯ ......
ÔÚrootÕ˺ÅÖÐ,¿ÉÒÔÕý³£µ÷Óô洢¹ý³Ì.
»»µ½common_userÕ˺Åʱ,ͬһ´æ´¢¹ý³ÌÃûµ÷ÓóöÏÖÎÊÌâ.
×·×Ùµ÷ÊÔʱ³öÏÖ:
SELECT command denied to user 'common_user'@'localhost' for table 'proc'
ËÑË÷½â¾ö·½°¸:
MySqlConnection myconnection = new MySqlConnection("server=localhost;user id=common_user; password=***;dat ......