ASP.NET SQL ×¢ÈëÃâ·Ñ½â¾ö·½°¸
UrlScanµÄ3.1ÊÇÒ»¸ö°²È«µÄ¹¤¾ß£¬ÏÞÖÆÁËIISµÄHTTPÇëÇ󽫴¦ÀíÀàÐÍ¡£ ͨ¹ý×èÖ¹ÌØ¶¨µÄHTTPÇëÇó£¬ÔÚURLScan 3.1°²È«¹¤¾ßÓÐÖúÓÚ·ÀÖ¹¶Ô·þÎñÆ÷Ó¦ÓóÌÐò¿ÉÄÜÓꦵÄÇëÇó¡£ UrlScanµÄ3.1ÊÇURLScan 2.5µÄ¸üа汾¡£Ö§³ÖIIS 5.1ÖУ¬IIS 6.0ºÍIIS 7.0ÔÚWindows VistaºÍWindows Server 2008¡£ÏÂÔØµØÖ·http://download.csdn.net/source/2057125
×èÖ¹¶ÔWebÓ¦ÓóÌÐò¿ÉÄÜÓꦵÄÇëÇó
UrlScan3.1¸ù¾Ý¹ÜÀíÔ±ÉèÖõĹæÔò¹ýÂËËùÓд«Èëµ½·þÎñÆ÷µÄÇëÇó¡£Ö»ÒªÇëÇóͨ¹ý¹ýÂË£¬²ÅÄܵõ½·þÎñÆ÷µÄ´¦Àí¡£
¼õÇáSQL×¢Èë¹¥»÷
ͨ¹ý UrlScan3.1µÄ¿ÉÅäÖÿÉÒÔ¹ýÂËHTTP²éѯ×Ö·û´®ÖµºÍÆäËûµÄHTTP±êÍ·£¬ÒÔ¼õÇáSQL×¢Èë¹¥»÷£¬´Ó¶ø¹®¹ÌÓ¦ÓóÌÐòµÄ°²È«¡£
·ÖÎöÈÕÖ¾Îļþ
UrlScan3.1ÌṩÁËW3C¸ñʽµÄÈÕÖ¾Îļþ·ÖÎöÎļþ£¬×ñÑ΢ÈíÈÕÖ¾·ÖÎöÆ÷2.2·ÖÎö½â¾ö·½°¸¡£
ÌØÕ÷
еÄURLScan 3.1°æ±¾¿ÉÒÔ°²×°ÔÚIIS 5.1£¬IIS 6.0ºÍIIS 7.0 ÉÏ
´´½¨¶ÀÌØµÄ“¾Ü¾ø”¹æÔòÓÃÓÚ¼ì²â²éѯ×Ö·û´®£¬ËùÓбêÌ⣬»òÌØ¶¨Í·¡£
ÔÚÒ»¸öÈ«¾ÖµÄDenyQueryStringÅäÖýÚÖУ¬Äú¿ÉÒÔ×Ô¶¨ÒåÇëÇó¹æÔò
ÔÚÒ»¸öÈ«¾ÖµÄAlwaysAllowedUrlsÅäÖýڲ¿·ÖÔÊÐíÄúÖ¸¶¨°²È«µÄÍøÖ·£¬´Ó¶øÍ¨¹ýURLµÄ¼ì²é¡£
ÔÚÒ»¸öÈ«¾ÖµÄAlwaysAllowedQueryStringsÅäÖýÚÖУ¬¿ÉÒÔÖ¸¶¨²éѯ×Ö·û´®µÄ°²È«£¬½«Í¨¹ýËùÓеIJéѯ×Ö·û´®¼ì²é¡£
תÒåÐòÁУ¨È磥0D£¥£©£¬¿ÉÓÃÓÚ·ñÈϹæÔò£¬ËùÒÔ¿ÉÒÔ·ñ¶¨µÄCRLFºÍÉæ¼°·Ç´òÓ¡×Ö·ûµÄÆäËûÐòÁС£
UrlScanµÄ¶à¸öʵÀý¿ÉÒÔΪվµã°²×°¹ýÂËÆ÷£¬Æä×Ô¼ºµÄÅäÖú͹æÔò£¨Urlscan.iniµÄ£©Ã¿¸ö¡£
¸ü¸Ä֪ͨ»á´«²¥µ½IIS¹¤×÷½ø³Ì¡£
ÔöÇ¿µÄW3C¸ñʽµÄÅäÖôíÎó¸ñʽ¼Ç¼ÔÚ±¸×¢Ê¹Í·ÖС£
Ïà¹ØÎĵµ£º
×î½ü×öÒ»¸öÏîÄ¿,˵ÆðÀ´±È½Ï¶ñ,ÊÇ´ÓÁíÒ»¸ö±íÖжÁÈ¡Êý¾ÝË͵½Õâ¸ö±íÖÐ.¶øÇÒÒªÓô¥·¢Æ÷Ñ»·ÕâЩÄÚÈÝÔÙ·¢³öÈ¥.
¿ÉÊÇÈç¹ûÕâ¸öÊý¾ÝÁ¿ºÜ´óµÄ»°,»áÒ»ÏÂ×Ó¹ÒËÀ.ËùÒÔ¾ÍÏëµ½ÁË.Äܲ»ÄÜ,ÿ´ÎÎÒ´«Ò»µã,¸ô¼¸ÃëÔÙËÍÒ»µã.
ÏÂÃæÊÇÒ»¸ö¼òµ¥µÄÀý×Ó
declare @i int
set @i=1
while @i<101
begin
insert into Cname ([name],csex,Number) ......
select *from student
select student_id from student
select student_id ,student_name from student
select student_id student_name from student ½«student_name ×÷Ϊstudent_idµÄ±ðÃû´¦Àí
È磺 select student_id a from student
select a=student_id from student
´Óstudent±íÖзֱð¼ ......
¿ì¹ýÄ꣬ºÃ¾Ãûдʲô¶«Î÷ÁË¡£²»ÖªµÀ×î½üÊÇ̫æÁË£¬»¹ÊÇ×Ô¼ºÓеãÀÁ£¬Ð´Ð©×Ô¼º»ýÀ۵Ķ«Î÷¡£¶¼ÊÇЩ×î»ù±¾µÄÓ¦Ó㬺ʹó¼Ò·ÖÏíÏ¡£
ÑéÖ¤ÂëÔÚºÜ¶àµØ·½¶àÓõ½£¬ÍøÉϸ÷ÖÖÐÎÐÎɫɫµÄ´úÂëÒ³ºÜ¶àÁË£¬ÎÒ¾ÍÊÇ´ò·¢µãʱ¼äддÁË¡£
ÔÀí£ºÍ¨¹ýGUI+Éú³ÉÓÐËĸöÊý×ÖµÄͼƬ£¬½«ËĸöÊý×Ö´æ·Åµ½SessionÖУ¬È»ºóͨ¹ýÑéÖ¤ÄãÊäÈëµÄÑéÖ¤ÂëºÍSession ......
µÚÒ»Õ ASP.NET Ajax¼ò½é
1.1ʲôÊÇAjax
Ò»£®Ê²Ã´ÊÇAjax
AjaxÊÇAsynchronous JavaScript and XML(Òì²½JavaScript ºÍXML)µÄËõд£¬ÓÉÖøÃûÓû§ÌåÑéר¼ÒJesse-James GarrettÔÚ2005Äê2ÔÂ18ÈÕ·¢±íµÄһƪÃûΪAjax:a New Approach to Web ApplicationsÎÄÕÂÖÐÊ×ÏÈÌá³ö¡£
Ajax²¢²»ÊÇÖ»°üº¬JavaScri ......