¡¾³õѧÕßÇó½Ì¡¿SQLServerµÄʱ¼äÓë³ÌÐòÖв»Ò»ÖÂ
loatÀàÐ͵Äֵת»¯ÎªÊ±¼äÊÇ—>
C# code:
DateTime dt = DateTime.fromOADate(40277.4927000525);
MessageBox.Show(dt.ToString());
MessageBoxÏÔʾµÄʱ¼äÊÇ—>2010-4-9 11:49:29
µ«ÊÇͬÑùµÄÊý×Ö£¨¼È40277.4927000525£©£¬Èç¹û´ÓÊý¾Ý¿âÖÐÈ¡³öÀ´ÏÔʾµÄdatagridviewÖУ¬¾Í»á±ÈÉÏÃæµÄʱ¼ä¶àÁ½Ìì¡£
C# code:
SqlDataAdapter da = new SqlDataAdapter("select [ID],cast([Time] as datetime) from DatapointValue2", con);
//×¢:40277.4927000525¾ÍÊÇTimeÁÐijһÐÐÖеÄÖµ
¾¶Ô±È£¬Í¬ÑùÊÇ40277.4927000525£¬gridviewÖÐÏÔʾµÄÊÇ—>2010-4-11 11:49:29£¬Ò²¾ÍÊDZÈÕæÊµµÄʱ¼ä¶àÁ½Ìì¡£
ÎÒÏÖÔÚÏë×öµÄÊÂÊÇÏëÈÃdataGridviewµÄʱ¼äÏÔʾÕý³££¬¿É·ñÔÚsqlÓï¾äÀïÃæÖ±½Ó¼ôµôÁ½Ì죬»òÕßÓñðµÄ·½·¨¡£Ï£Íû¸ßÊÖÖ¸µã£¡£¡£¡
Íò·Ö¸Ð¼¤£¡£¡£¡£¡£¡£¡
http://msdn.microsoft.com/zh-cn/library/ms186819.aspx
¸Ðл¿Õ¾ü£¬»ØÁË£¡£¡£¡£¡
»ØÁË£¡£¡£¡£¡—>»áÁË£¡£¡£¡£¡
Ïà¹ØÎÊ´ð£º
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
Ñ¡ÔñÊý¾Ý¿â£¬µã»÷ÓÒ¼ü ÈÎÎñ->µ¼³öÊý¾Ý Ö®ºó°´ÕÕÌáʾµ¼³ö¾Í¿ÉÒÔÁË£¡
±í¶àµÄ»° ÓÃÂ¥Éϵķ½·¨ ±È½Ï·½±ã ¿ÉÒÔ°ÑÊý¾Ý¿âÀïÏàÓ¦µÄ±íµ¼³ö »òÕßÈç¹ûÄãÊDzéѯ³öÀ´µÄ ......
ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:
private void new ......
ÎÒÍùSqlServerÖмÓÊý¾ÝµÄʱºò,Ëû¸øÎÒ±¨Á˸ö´í
˵:"µ± IDENTITY_INSERT ÉèÖÃΪ OFF ʱ£¬²»ÄÜÏò±í 'O_TRAIN_CATEGORY' ÖеıêʶÁвåÈëÏÔʽֵ¡£"
ÒòΪÎÒÕâ¸ö±íµÄÖ÷¼üÉèÖõÄÊÇ×ÔÔöµÄ!ÊDz»ÊÇ×ÔÔöû¿ª°¡?Ôõô¸ ......
ÈçºÎÆÁ±ÎSQLSERVERµÇ¼Óû§ºÍÆô¶¯µÇ¼Óû§
ÆÁ±ÎʲôÒâ˼¡£¡£¡£¡£
°²ÐÔÐÔ,µÇ¼Ãû,Ñ¡ÔñµÇ¼Óû§,ÓÒ¼üÊôÐÔ,״̬,½ûÓõǼ
SQL Server Management Studio-->°²È«ÐÔ-->µÇ¼Ãû-->Ñ¡ÔñµÇ¼Óû§-->ÓÒ¼ü ......
ÎÒÔÚÆóÒµ¹ÜÀíÆ÷Öн«sqlserver µÄÒ»¸öÊý¾Ý¿âµ¼³öΪaccess£¬ÒªÓû§ÃûºÍÃÜÂë,
ÎÒÊäÈëÁËsqlÊý¾Ý¿âµÄ²»ÐÐ
accessĬÈϵÄadminÓû§ÃûÒ³²»ÐС£
Ôõô°ì£¿
µÇ¼Êý¾Ý¿âµÄÃû×ÖºÍÃÜÂë,²»Í¬·þÎñÆ÷,ÏȽ¨Á¢Á´½Ó·þÎñÆ÷
SQL cod ......