SQL 2005 ASP.NETÊý¾Ý¿âÁ¬½Ó×ܽá
VS2005+SQL2005 ASP.NET2.0Êý¾Ý¿âÁ¬½Ó×ܽá
ͨ¹ýÉÏƪÎÄÕ£¨http://www.cnblogs.com/user34j/archive/2007/01/23/628426.html£©µÄÉèÖÃÆäʵÒѾ²î²»¶àÍê³ÉÁË£¬Ö»ÊÇ»¹ÓÐһЩϸ½ÚµÄµØ·½Ã»ÓÐ×öºÃ£¬¾¹ýÒ»·¬Ñо¿ÏÖÔÚÖÕÓڸ㶨ÁË¡£¶ÔÓÚÏñÎÒÕâÑùµÄÐÂÊÖÀ´Ëµ£¬Õû¸öÊý¾Ý¿âÁ¬½ÓÕæÊDz»ÈÝÒס£ÏÖ×ܽáÈçÏ£º
1.¿ªÆôsql2005Ô¶³ÌÁ¬½Ó¹¦ÄÜ£¬¿ªÆô°ì·¨ÈçÏ£º
ÅäÖù¤¾ß->Sql ServerÍâΧӦÓÃÅäÖÃÆ÷->·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷->´ò¿ªMSSQLSERVER½ÚµãϵÄDatabase Engine½Úµã£¬ÏÈÔñ“Ô¶³ÌÁ¬½Ó”£¬½ÓϽ¨ÒéÑ¡Ôñ“ͬʱʹÓÃTCP/IPºÍnamed pipes”£¬È·¶¨ºóÖØÆôÊý¾Ý¿â·þÎñ¾Í¿ÉÒÔÁË¡£
2.µÇ½ÉèÖøÄΪ£ºSql Server ºÍ Windows Éí·ÝÑé֤ģʽ£¬¾ßÌåÉèÖÃÈçÏÂ:
SQL Server Management Studio¹ÜÀíÆ÷->Windows Éí·ÝÑéÖ¤Á¬½Ó·þÎñÆ÷->¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖÐÑ¡ÔñÄãµÄÊý¾Ý·þÎñÆ÷£>ÓÒ¼ü£>ÊôÐÔ£>°²È«ÐÔ£>Sql Server ºÍ Windows Éí·ÝÑé֤ģʽѡÖС£
3.ÉèÖÃÒ»¸öSql Server·½Ê½µÄÓû§ÃûºÍÃÜÂ룬¾ßÌåÉèÖÃÈçÏÂ:
£¨1£©SQL Server Management Studio¹ÜÀíÆ÷->Windows Éí·ÝÑéÖ¤Á¬½Ó·þÎñÆ÷£>¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖÐÑ¡ÔñÄãµÄÊý¾Ý·þÎñÆ÷£>Õ¹¿ª·þÎñÆ÷Éϵē°²È«ÐÔ”->µÇ½Ãû£>ÔÚsaÕʺÅÉϵãÓÒ¼ü£>“Ñ¡ÔñÒ³”Ñ¡Ôñ³£¹æ->¸ü¸ÄsaµÇ½ÕʺŵÄÃÜÂë¡£ÕâÑù¾ÍÉèÖÃÁËÒ»¸öÓû§ÃûΪsa£¬ÃÜÂëΪ:sa123456µÄÓû§¡£
£¨2£©“Ñ¡ÔñÒ³”Ñ¡Ôñ״̬->µÇ½ÐÞ¸ÄΪÆôÓÃ
4.Êý¾Ý¿âÁ¬½Ó×Ö·û´®
Êý¾Ý¿âÁ¬½Ó×Ö·û´®Óкü¸ÖÖ£¬ÏàÐÅÄã×Ô¼ºÒ²¼û¹ý£¬¶¼±»¸ãÔÎÁË
Data Server=.\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=sa123456
Data Server=·þÎñÆ÷Ãû\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=sa123456
&nb
Ïà¹ØÎĵµ£º
ÄãÖªµÀXMLÎļþ°É£¿£¨²»ÖªµÀµÄGOOGLEÈ¥£¡£©ÄÇÄãÌý˵¹ýÔÚXMLÀïÊéдSQLÓï¾äÂ𣿻»¾ä»°Ëµ£¬°ÑÄãµÄÏîÄ¿ÀïËùÓÐSQLÓï¾ä´æ´¢ÔÚXMLÎļþÀÄãÌý˵¹ýÂð£¿Äã×ö¹ýÂð£¿
ÎÒÍ·´ÎÌý˵ÊÇС°¬¸æËßÎҵģ¬ÎҸҿ϶¨ËûÊǸöÕâ·½ÃæµÄ¸ßÊÖ£¬ºÇºÇ£¨ÔÞÒ»¸ö£¬µ½´ËΪֹ£¡£©
ÄǸøÄãչʾһÏ£¬ÔÚXMLÀïÊéдSQLÓï¾ä°É
<commands>
<comman ......
1¡¢WINDOWSÉí·ÝµÇ½£º
<connectionStrings>
<add name="connectionString" connectionString="Data Source=(local);Initial Catalog=AngelicaDB;Integrated Security=True" providerName="System .Data .SqlClient" /> ......
In the last post I showed how to use the ASP.NET 3.5 Routing Engine
for URLRewriting purposes. I want to go further in this post by adding
the ability to add variables into a route path and forward and append
query string variables to the destination Web Form request.
A route can contain one or ......
Èç¹ûҪת»¯µÄÒ³ÃæÖ»ÓÐÒ»Á½¸ö£¬ÇÒÁ½ÕßÖ®¼äµÄûʲô¹ØÁª£¬¾Í¿ÉÒÔÓÃÌæ»»·½·¨ÊµÏÖ£¬ÏÈÓÃhtml±àдºÃÒ»ÕÅÍøÒ³£¬ÔÚÐèÒªÓõ½Êý¾Ý¿âµÄµØ·½ÓÃÌØÊâµÄ±êÇ©±ê¼Ç×Å£¬ÀýÈç&idµÈ¡£ÔÚÓÃ.net±àдһÕÅaspxÍøÒ³ÓÃÓÚ°ÑÕâЩ±êÇ©Ìæ»»³ÉÏëÒªµÄÊý¾Ý¿âÄÚÈÝ£¬ÕâÑù¾ÍÐÐÁË¡£²»¹ý±È½ÏÂé·³µÄÊÇÿ´Î¸üÐÂÊý¾Ý¿â¶¼Òª×ª»¯Ò»´Î¡£
»¹ÓоÍÊÇÈç¹ûÊÇÍøÒ³Ö®¼äÓк ......