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

¡¾³õѧÕßÇó½Ì¡¿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

¸Ðл¿Õ¾ü£¬»ØÁË£¡£¡£¡£¡

»ØÁË£¡£¡£¡£¡—>»áÁË£¡£¡£¡£¡


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

win7Éϰ²×°sqlserver - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£

ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ


ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾­ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£

SQLSERVER 2000Ã ......

ÈçºÎ°ÑmysqlÀïµÄÊý¾Ýµ¼Èëµ½sqlserverÀ

ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄѰÉ
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯ ......

¼±¼±¼±,SqlServerµÄÎÊÌâ

ÎÒÍùSqlServerÖмÓÊý¾ÝµÄʱºò,Ëû¸øÎÒ±¨Á˸ö´í
˵:"µ± IDENTITY_INSERT ÉèÖÃΪ OFF ʱ£¬²»ÄÜÏò±í 'O_TRAIN_CATEGORY' ÖеıêʶÁвåÈëÏÔʽֵ¡£"
ÒòΪÎÒÕâ¸ö±íµÄÖ÷¼üÉèÖõÄÊÇ×ÔÔöµÄ!ÊDz»ÊÇ×ÔÔöû¿ª°¡?Ôõô¸ ......

sqlserverµ¼³öaccessÖеÄÎÊÌâ

ÎÒÔÚÆóÒµ¹ÜÀíÆ÷Öн«sqlserver µÄÒ»¸öÊý¾Ý¿âµ¼³öΪaccess£¬ÒªÓû§ÃûºÍÃÜÂë,
ÎÒÊäÈëÁËsqlÊý¾Ý¿âµÄ²»ÐÐ
accessĬÈϵÄadminÓû§ÃûÒ³²»ÐС£
Ôõô°ì£¿
µÇ¼Êý¾Ý¿âµÄÃû×ÖºÍÃÜÂë,²»Í¬·þÎñÆ÷,ÏȽ¨Á¢Á´½Ó·þÎñÆ÷

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