Asp.netÓëSQLÒ»Æð´ò°ü²¿Êð°²×°
Õû¸öSQLºÍAsp.net(vb.net)Ò»Æð´ò°üµÄÈ«¹ý³ÌдһÏ¡£
Ò».×¼±¸±ØÒªµÄÎļþ
1. SQL½Å±¾Îļþ£¬Éú³ÉÒÔºó°²×°¹ý³ÌÖÐÐèÒªµÄ±íºÍ´æ´¢¹ý³ÌµÈµÈ£»
Éú³ÉÖ®ºó£¬¾ÍÔÝʱ°ÑËüÃüÃûΪdb.sql(×¢Òâ´óСд)
2.LisenceFile.rtfµÄ°²×°Îļþ£¬ÒòΪÎÒµÄϵͳÊǸöÈ˵ģ¬¶øÇÒfreeµÄ£¬ËùÒÔ¾ÍûÓÐ×ö¡£Õâ¸öÒÔºóÒ²ÊÇÒªÓõ½µÄ¡£
¶þ.ÔÚ×Ô¼ºÏÖÓеÄÏîÄ¿ÀïÃæ´´½¨²¿ÊðÏîÄ¿:
1. ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£(ͼ1-2)
2. ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеē°²×°ºÍ²¿ÊðÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñÖеēWeb °²×°ÏîÄ¿”¡£ÔÚ“Ãû³Æ”¿òÖмüÈë Test Installer¡£(ͼ1-3)
3. µ¥»÷“È·¶¨”¹Ø±Õ¶Ô»°¿ò¡£
4. ÏîÄ¿±»Ìí¼Óµ½½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷ÖУ¬²¢ÇÒÎļþϵͳ±à¼Æ÷´ò¿ª¡£
5. ÔÚ“ÊôÐÔ”´°¿ÚÖУ¬Ñ¡Ôñ ProductName ÊôÐÔ£¬²¢¼üÈë GCRM¡£
(1-2)
(ͼ1-3)ÆäËûÏîÄ¿µÄ×÷ÓÿÉÒԲο¼Webcast
Èý¡£½« VbNetTestÏîÄ¿µÄÊä³öÌí¼Óµ½²¿ÊðÏîÄ¿ÖÐ(¼ÙÈçÄãµÄÐéÄâĿ¼ÊÇSQLANDASPNet)
1. ÔÚ“Îļþϵͳ±à¼Æ÷”ÖУ¬Ñ¡Ôñ“Web Ó¦ÓóÌÐòÎļþ¼Ð"¡£ÔÚ“²Ù×÷”²Ëµ¥ÉÏ£¬Ö¸Ïò“Ìí¼Ó”£¬È»ºóÑ¡Ôñ“ÏîÄ¿Êä³ö”¡£(ͼ1-4)
2. ÔÚ“Ìí¼ÓÏîÄ¿Êä³ö×锶Ի°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿”ÏÂÀÁбíÖеēSQLANDASPNet”¡£
3. µ¥»÷“È·¶¨”¹Ø±Õ¶Ô»°¿ò¡£
4. ´ÓÁбíÖÐÑ¡Ôñ“Ö÷Êä³ö”ºÍ“ÄÚÈÝÎļþ”×飬Ȼºóµ¥»÷“È·¶¨”¡£(ͼ1-5)
(ͼ1-4)
£¨Í¼1-5£©ÆäËûµÄ×÷ÓÿÉÒԲο¼webcast£¬Ô´Îļþ¾ÍÊÇËùÓÐÏîÄ¿µÄµÄÎļþ
ËÄ.
´´½¨×Ô¶¨Òå°²×°¶Ô»°¿ò
1. ÔÚ½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷ÖÐÑ¡Ôñ“Test Installer”ÏîÄ¿¡£ÔÚ“ÊÓͼ”²Ëµ¥ÉÏÖ¸Ïò“±à¼Æ÷”£¬È»ºóÑ¡Ôñ“Óû§½çÃ攡£ (ͼ1-6)
2. ÔÚÓû§½çÃæ±à¼Æ÷ÖУ¬Ñ¡Ôñ“°²×°”ϵēÆô¶¯”½Úµã¡£ÔÚ“²Ù×÷”²Ëµ¥ÉÏ£¬Ñ¡Ôñ“Ìí¼Ó¶Ô»°¿ò”¡£
3. ÔÚ“Ìí¼Ó¶Ô»°¿ò”¶Ô»°¿òÖУ¬Ñ¡Ôñ“Ðí¿ÉÐÒ锶Ի°¿ò£¬È»ºóµ¥»÷“È·¶¨”¹Ø±Õ¶Ô»°¿ò¡£ (×¢£ºÎÒûÓÐÌí¼Ó£¬ÒòΪÔÝʱÎÒ»¹ÊDz»ÐèÒª£¬ÐèÒªµÄÒªÌí¼ÓÒ»ÏÂŶ£©
4. ÔÚ“Ìí¼Ó¶Ô»°¿ò”¶Ô»°¿òÖУ¬Ñ¡Ôñ“Îı¾¿ò (A)”¶Ô»°¿ò£¬È»ºóµ¥»÷“È·¶¨
Ïà¹ØÎĵµ£º
´ÓA±íËæ»úÈ¡10Ìõ¼Ç¼,ÓÃSELECT TOP 10 * from ywle order by newid()
order by Ò»°ãÊǸù¾Ýijһ×Ö¶ÎÅÅÐò,newid()µÄ·µ»ØÖµ ÊÇuniqueidentifier ,order by newid()Ëæ»úÑ¡È¡¼Ç¼ÊÇÈçºÎ½øÐеÄ
newid()ÔÚɨÃèÿÌõ¼Ç¼µÄʱºò¶¼Éú³ÉÒ»¸öÖµ, ¶øÉú³ÉµÄÖµÊÇËæ»úµÄ, ûÓдóСд˳Ðò. ËùÒÔ×îÖÕ½á¹ûÔÙ°´Õâ¸öÅÅÐò, ÅÅÐòµÄ½á¹ûµ±È»¾ÍÊÇÎ ......
×÷Òµ¹ÜÀí
×Ô¶¯´¦ÀíÒ»¸öÈÎÎñµÄµÚÒ»²½ÊÇ´´½¨¶ÔÓ¦µÄ×÷Òµ£¬×÷Òµ¿ÉÒÔʹÓÃÁ½ÖÖ¹¤¾ßÀ´´´½¨£¬¼´´´½¨×÷ÒµÏòµ¼ºÍSQL Server ÆóÒµ¹ÜÀíÆ÷¡£´´½¨×÷Òµ×îÈÝÒ׵ķ½·¨ÊÇʹÓô´½¨×÷ÒµÏòµ¼£¬Ò»°ãÀ´Ëµ£¬Èç¹ûÒª´´½¨×÷Òµ£¬±ØÐëÖ´ÐÐÒÔÏÂÈý¸ö²½Ö裺
(1)¶¨Òå×÷Òµ²½£»
(2)Èç¹û¸Ã×÷Òµ²»ÊÇÓû§Ö¸¶¨Ö´ÐУ¬´´½¨×÷ÒµÖ´Ðеĵ÷¶Èʱ¼ä£»
(3)֪ͨ²Ù×÷Ô±×÷Òµ ......
/// <summary>
/// ¹ýÂ˱ê¼Ç
/// </summary>
/// <param name="NoHTML">°üÀ¨HTML£¬½Å±¾£¬Êý¾Ý¿â¹Ø¼ü×Ö£¬ÌØÊâ×Ö·ûµÄÔ´Âë </param>
/// <returns>ÒѾȥ³ý±ê¼ÇºóµÄÎÄ×Ö</returns>
&nbs ......
1.¶ÔIEä¯ÀÀÆ÷½øÐÐÉèÖÃ
Îļþ-¡µÒ³ÃæÉèÖÃ-¡µ½«ÀïÃæµÄҳüºÍÒ³½ÅµÄÄÚÈÝÇå¿Õ ¾ÍOKÁË
2.Ò³Ãæ´úÂëʵÏÖ Javascript
<!--<br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--><!-- & ......