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

MSSQLÊý¾Ý¿âÀïµÄ¼Ç¼ת³ÉJSONµÄÎÊÌâ

ÎÒ·¢ÏÖÎÒ°ÑÊý¾Ý¼Ç¼ת³ÉJSONÒ»¸öÎÊÌâ¡£

Èç¹ûÔÚÊý¾Ý¿âÀïÃæÊÇûÓл»ÐеļǼ£¬ÊÇ¿ÉÒÔ˳Àûת»»³ÉJSONµÄ

Èç¹û»»ÐУ¬¾ÍתµÄ²»³É¹¦¡£

ÄÄÃÇÐÖµÜÖªµÀÊÇÕ¦¸ãµÄ£¿
ÎÒµÄÎÊÌâ½â¾öÁË

ÒòΪÎÒÓõÄÊÇMSSQL £¬Ï뽫ÀïÃæµÄÊý¾Ýת³ÉJSON£¬È»ºó×°³ÉExtJsµÄGridPanelÖÐ

ºó¾­¹ýÎÒ×Ô¼º×ÐϸµÄÅŲ飬·¢ÏÖ²»ÊÇJSONµÄÎÊÌ⣬¶øÊÇExtJsµÄGridPanel²»Ö§³Ö»»ÐС£

ºóÀ´ÎÒÔÚC#¶ËÓÃ.Replace("\r\n","")´¦Àíһϣ¬¾Í¿ÉÒÔÁË¡£




½Ó·Ö°É

jf


Ïà¹ØÎÊ´ð£º

vb+mssql²éѯÎÊÌâ2

±ÈÈç
Ò»¸öÊÇÓû§Áбí
UserID
1
2
3
4

Ò»¸öÊǼǼÁбí(ÿ¸öÓû§Ò»Ìì¿ÉÄÜÓжàÌõÊý¾Ý)
UserID Day
1 2009-09-22
1 2009-09-22
1 2009-09-22

2 2009-09-22
2 20 ......

MSSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆ

MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆÊÇ:GRANT ALL PRIVILEGES ON *.* TO username'@'IPµØÖ· IDENTIFIED BY 'ÃÜÂë ' WITH GRANT OPTION

ÓÐË­ÖªµÀÔÚMSSQLÖÐÔõôÉèÖÃIP·ÃÎÊÏÞÖÆ
ÒýÓÃ
MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞ ......

MSSQLÊý¾Ý¿â±íÉè¼ÆÎÊÌ⣡

ÎÒÉè¼ÆµÄ
Óû§ÐÅÏ¢±í  ³­±íÊý¾Ý±í  ÀúÊ·³­±íÊý¾Ý±í
ÎÒµÄÏë·¨ÊÇ Ã¿Ô³õ  ϵͳ×Ô¶¯ÔÚ ³­±íÊý¾Ý±íÖÐÉú²ú ÓëÓû§¹ØÁªµÄÊý¾Ý ÓÃÓÚ³­±íÔ±µÄ¼È룬µ±³­±íԱȫ²¿Â¼Èëºó °ÑÊý¾ÝÈ«²¿¸´ÖƵ½ÀúÊ·±íÖРͨʱ ......

ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{}µÄ¡£²»·½±ã°¡¡£

ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{xxxxxx}µÄ¡£²»·½±ã°¡¡£

µØÖ·´«ÖµµÄʱºòÕâÑùºÃ²»ºÃµÄ£¿

ĬÈÏÊä³öP¸ñʽ
-----------
ĬÈÏÊä³öÊÇB¸ñʽ...

ÉÏÃæËµÁË È¡³öÀ´¸ñʽ»¯Ò»ÏÂ

ѧϰÁË.

ÒýÓÃ
ĬÈÏÊä³ ......

Çó½â£ºQT4.5.3 Á¬½ÓMSSQL³É¹¦£¬Ö´ÐÐÓï¾ä³ö´í

´úÂëÈçÏ£º
        QSqlDatabase   dbconn   =   QSqlDatabase::database( "sqltest ",   false);
        if(!dbconn.isVa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ