ASP.NET
ͨ³££¬SQL Óï¾äºÍ´æ´¢¹ý³Ì°üÀ¨ÔËÐÐʱ¼ÆËãµÄ²ÎÊý¡£Ê¹ÓòÎÊý±àдµÄ SQL Óï¾ä³Æ×÷²ÎÊý»¯ SQL Óï¾ä¡£
ʹÓà SqlDataSource ¿Ø¼þʱ£¬¿ÉÒÔÖ¸¶¨Ê¹ÓòÎÊýµÄ SQL ²éѯºÍÓï¾ä¡£Í¨¹ý¸ù¾ÝÔËÐÐʱ¼ÆËãµÄÖµ¶ÁдÊý¾Ý¿âÐÅÏ¢£¬ÕâÓÐÖúÓÚÌáÉýÊý¾Ý°ó¶¨»·¾³µÄÁé»îÐÔ¡£¿ÉÒÔ´Ó¸÷ÖÖÔ´»ñÈ¡²ÎÊýÖµ¡£ÕâЩԴ°üÀ¨ ASP.NET Ó¦ÓóÌÐò±äÁ¿¡¢Óû§±êʶºÍÓû§Ñ¡ÔñµÄÖµ¡£¿ÉÒÔʹÓòÎÊýÖ´ÐÐÏÂÁвÙ×÷£ºÌṩÓÃÓÚÊý¾Ý¼ìË÷µÄËÑË÷Ìõ¼þ£»ÌṩҪÔÚÊý¾Ý´æ´¢ÇøÖвåÈë¡¢¸üлòɾ³ýµÄÖµ£»ÌṩÓÃÓÚÅÅÐò¡¢·ÖÒ³ºÍɸѡµÄÖµ¡£
Ò»¡¢Ê¹ÓòÎÊý
ͬËùÓеÄÊý¾ÝÔ´¿Ø¼þÒ»Ñù£¬SqlDataSource ¿Ø¼þÔÚÔËÐÐʱ½ÓÊÜÊäÈë²ÎÊý£¬²¢ÔÚ²ÎÊý¼¯ºÏÖжԲÎÊý½øÐйÜÀí¡£Ã¿Ò»ÏîÊý¾Ý²Ù×÷¶¼ÓÐÒ»¸öÏà¹ØµÄ²ÎÊý¼¯ºÏ¡£¶ÔÓÚÑ¡Ôñ²Ù×÷£¬¿ÉÒÔʹÓà SelectParameters ¼¯ºÏ£»¶ÔÓÚ¸üвÙ×÷£¬¿ÉÒÔʹÓà UpdateParameters ¼¯ºÏ£¬ÒÀ´ËÀàÍÆ¡£
¿ÉÒÔΪÿ¸ö²ÎÊýÖ¸¶¨Ãû³Æ¡¢ÀàÐÍ¡¢·½ÏòºÍĬÈÏÖµ¡£¶ÔÓÚ´ÓÌØ¶¨¶ÔÏó£¨ÀýÈ磬¿Ø¼þ¡¢»á»°±äÁ¿»òÓû§ÅäÖÃÎļþ£©»ñȡֵµÄ²ÎÊý£¬ÐèÒªÉèÖÃÆäËûÊôÐÔ¡£ÀýÈ磬ControlParameter ÒªÇóÉèÖà ControlID ÒÔ±êʶҪ´ÓÖлñÈ¡²ÎÊýÖµµÄ¿Ø¼þ£¬ÒÔ¼°ÉèÖà PropertyName ÊôÐÔÒÔÖ¸¶¨°üº¬²ÎÊýÖµµÄÊôÐÔ¡£
ÁíÍ⣬SqlDataSource ¿Ø¼þ½«»ùÓÚÖ§³Ö×Ô¶¯¸üС¢²åÈëºÍɾ³ý²Ù×÷µÄÊý¾Ý°ó¶¨¿Ø¼þ£¨ÀýÈç GridView »ò FormView ¿Ø¼þ£©Ëù´«µÝµÄÖµ×Ô¶¯´´½¨²ÎÊý¡£
¶þ¡¢ÔÚÃüÁîÖÐÖ¸¶¨²ÎÊý
ʹÓà SqlDataSource ¿Ø¼þʱ£¬¿ÉÒÔ½«¸Ã¿Ø¼þµÄÃüÁîÊôÐÔÉèÖÃΪ²ÎÊý»¯ SQL Óï¾ä»ò´æ´¢¹ý³ÌµÄÃû³Æ¡£Èç¹ûÖ¸¶¨ÃüÁîµÄ´æ´¢¹ý³Ì£¬±ØÐ뽫¸ÃÃüÁîµÄÃüÁîÀàÐÍÖ¸¶¨Îª StoredProcedure¡£
2.1¡¢²ÎÊýÃû³Æ
SqlDataSource ¿Ø¼þ¿ÉÒÔ½« ParameterPrefix ÊôÐÔµÄÖµÌí¼Óµ½ËùÓвÎÊýÃû³ÆµÄ¿ªÍ·¡££¨Ä¬ÈϵÄǰ׺Ϊ“@”¡££©
Èç¹û GridView ¿Ø¼þµÈÊý¾Ý°ó¶¨¿Ø¼þ°ó¶¨µ½ SqlDataSource ¿Ø¼þ£¬ÔÚÖ´Ðиüлòɾ³ý²Ù×÷ÆÚ¼ä£¬¸ÃÊý¾Ý°ó¶¨¿Ø¼þ»áͬʱ½«µ±Ç°¼Ç¼ֵºÍÔʼ¼Ç¼ֵ´«µÝµ½ SqlDataSource ¿Ø¼þ¡£µ±Ç°Öµ´«µÝµ½ Values ×ÖµäÖС£Ôʼֵ´«µÝµ½ Keys »ò OldValues ×ÖµäÖС£¶ÔÓÚ¸ø¶¨µÄÊý¾Ý²Ù×÷£¬ÕâЩ×ÖµäµÄÄÚÈݽ«»á×·¼Óµ½»ù´¡ DbCommand ¶ÔÏóµÄ Parameters ¼¯ºÏÖС£
ÔÚ SqlDataSource ¿Ø¼þµÄ SQL ÃüÁîÖУ¬Ê¹ÓÃÃüÃûÔ¼¶¨Ê¹²ÎÊýռλ·ûÓë´«µÝµ½¸ÃÃüÁîµÄÔÀ´µÄÖµÏàÆ¥Å䡣ͨ¹ýÉèÖà SqlDataSource ¿Ø¼þµÄ OldValuesParameterFormatString ÊôÐÔ£¬¿ÉÒÔ½¨Á¢¸Ãռλ·ûÃû³ÆµÄ¸ñʽ¡£½« OldValuesParameterFormatStrin
Ïà¹ØÎĵµ£º
£¼input id = " loFile " type = " file " runat = " server " £¾
£¼form method = " post " enctype =" multipart/form-data " runat = " server "£¾
£¼/form £¾
1.»ñµÃÉÏ´«ÎļþµÄÃû³Æ£º£¨¹Ø¼üÊÇPostedFileÀàµÄÓ¦Óã©
ʹÓÃPathÀàÖеÄGetFileName·½·¨£¬¾ßÌåÈçÏ£º
lstrFileName = loFile.PostedFile.FileName ......
ASP.NET URLË«Ïò¸ÄдµÄʵÏÖ
¡¡¡¡ÎÒÃÇÔÚ½øÐÐWeb³ÌÐò¿ª·¢Ê±£¬ÎªÁ˽øÐÐËÑË÷ÒýÇæÓÅ»¯£¨SEO£©£¬ÍùÍùÐèÒª¶ÔwebµÄ·ÃÎʵØÖ·½øÐÐÓÅ»¯£¬È罫http://localhost/Default.aspx?tab=performanceÐÞ¸ÄΪhttp://localhost/Default_performance.aspx£¬ºóÒ»¸öµØÖ·Äܹ»¸üºÃµØ±»ËÑË÷ÒýÇæËÑË÷µ½£¬´Ó¶ø´ïµ½ÁËËÑË÷ÒýÇæÓÅ»¯µÄÄ¿µÄ¡£Î¢ÈíÓÐÒ»¸ö¿ªÔ´À ......
Ê×ÏÈÔÚ Web.Config ÖÐÌí¼ÓÄ£ÄâÕʺÅ
<identity impersonate="true" userName="administrator"password="password" />
Æä´Î ÒªÌí¼Ó EXCEL com ×é¼þ¡£Èç¹ûÊÇEXCEL2003,ÔòÌí¼Ó EXcel library 11.0 °æ±¾¡£ÎÒ°ÑÓõ½µÄÒýÓÃÍ·ÎļþÁоÙÈçÏ£º
&nbs ......
ÔÚASP.NET 2.0 ±¾µØ»¯¼¼ÊõÖ®Ñо¿µÄ»Ø¸´ÖÐÌáµ½ÁËÒÔÏÂÁ½µã£º
1.ÕâÖ»Êǵ¥¸öÒ³ÃæµÄÇл»£¬ÈçºÎ×öÕû¸öÕ¾µãµÄÇл»ÄØ£¿£¨ hjh £©
2.¹ØÓÚÈçºÎ½«×ÊÔ´Ö±½ÓÏÔʾ……¼ÈÈ»¿Ø¼þÄܹ»½«Ç¶ÈëdllµÄ×ÊÔ´Ö±½ÓÏÔʾ£¬²»ÖªµÀÍøÕ¾ÄÜ·ñÒ²½«Ç¶Èë×ÊÔ´Ö±½Óµ÷ÓÃWebResourceÏÔÊ¾ÄØ£¿£¨Cat Chen £©
ÓÉÓÚ²»ÊÇÒ»Á½¾ä¿ÉÒÔ˵Ç壬ËùÒÔÔÙ¿ªÒ»Æª×Ðϸ ......
ÑÝÁ·£ºÊ¹Óà XCOPY ²¿Êð ASP.NET Web Ó¦ÓóÌÐò
²¿Êð ASP.NET Ó¦ÓóÌÐò·Ç³£¼òµ¥¡£ÄúÐèÒª½«Ëù´´½¨µÄÓ¦ÓóÌÐòÎļþ´Ó¿ª·¢¼ÆËã»ú¸´ÖƵ½½«³ÐÔØÓ¦ÓóÌÐòµÄ³ÉÆ· Web ·þÎñÆ÷¡£¿ÉÒÔʹÓà XCOPY ÃüÁîÐй¤¾ß»òϲ»¶µÄ FTP Ó¦ÓóÌÐò£¬½«Îļþ´ÓÒ»¸öλÖø´ÖƵ½ÁíÒ»¸öλÖá£Óйس£¹æ²¿ÊðµÄ¸ü¶àÐÅÏ¢£¬Çë²Î¼û .NET Framework ²¿Êð»ù´¡¡£
×¢Òâ
......