Ó²ÅÌÊý¾Ý»Ö¸´µ¼º½
RAIDÊý¾Ý»Ö¸´µ¼º½
 | ÍøÕ¾Ê×Ò³ | Êý¾Ý»Ö¸´×ÊÁÏ | Êý¾Ý»Ö¸´Èí¼þ | ×ÉѯÁôÑÔ | Êý¾Ý»Ö¸´²©¿Í | Êý¾Ý»Ö¸´ÂÛ̳ | 
Êý¾Ý»Ö¸´Èí¼þÏÂÔØ
¹«Ë¾¼ò½é Êý¾Ý»Ö¸´³É¹¦°¸Àý Êý¾Ý»Ö¸´±¨¼Û Êý¾Ý»Ö¸´Åàѵ Êý¾Ý»Ö¸´¼¼ÊõÎÄÕ Êý¾Ý»Ö¸´¿Í·þÖÐÐÄ Êý¾Ý»Ö¸´·þÎñÁªÏµ·½Ê½
ÄúÏÖÔÚµÄλÖ㺠±±ÑÇÊý¾Ý»Ö¸´¼¼ÊõÕ¾ >> Êý¾Ý»Ö¸´×ÊÁÏ >> ·þÎñÆ÷Óë´æ´¢¼¼Êõ >> ÎÄÕÂÕýÎÄ
[ͼÎÄ]VS2005+SQL2005 ASP.NET2.0Êý¾Ý¿âÁ¬½Ó            ¡¾×ÖÌ壺С ´ó¡¿
VS2005+SQL2005 ASP.NET2.0Êý¾Ý¿âÁ¬½Ó
×÷ÕߣºÎ´Öª    ÎÄÕÂÀ´Ô´£ºÍøÂç    µã»÷Êý£º    ¸üÐÂʱ¼ä£º2009-6-17
ÓÚµÄÐÂÊÖÀ´Ëµ£¬Õû¸öÊý¾Ý¿âÁ¬½Ó²»Ì«ÈÝÒ×£¬¸ù¾ÝÁ¬½Ó¹ý³ÌÖеÄÎÊÌâ×ܽáÈçÏ¡£

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
Data Server=localhostSQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=sa123456
Data Server=.;Initial Catalog=Northwind;User ID=sa;Password=sa123456
Data Server=·þÎñÆ÷Ãû;Initial Catalog=Northwind;User ID=sa;Password=sa123456
¡­¡­

ÄÇÖÖÕýÈ·,Õâ¸úÊý¾Ý¿â°æ±¾ÓйØϵ£¬Èç¹ûÊÇSQL Server 2005 Express°æ±¾£¬Ôò±ØÐëÒªÓС°SQLEXPRESS¡±¡£¶øÇÒÈç¹ûÕâ¸ö×Ö·û´®ÊǶ¨ÒåΪһ¸ö±äÁ¿µÄʱºò£¬VS2005»¹»áÔÚ¡°¡±µÄÏÂÃæ¼Ó¸öºìÉ«µÄ²¨ÀËÏßÌáʾÄã¡°SÊÇÎÞ·¨Ê¶±ðµÄתÒåÐòÁС±£¬Òò´ËÈç¹û×Ö·û´®ÊǶ¨ÒåΪһ¸ö±äÁ¿µÄʱºòÓ¦¸Ãд³ÉServer=.SQLEXPRESS¡£

5.×¢²áSQL ServerÊý¾Ý¿â:

ÔÚ·¾¶¡°C:WindowsMicrosoft.netFrameworkv2.0.50727¡±ÏÂÔËÐС°ASPNET_REGSQL¡±Ö¸Á¾Í»á³öÏÖASP.NET SQL Server Setup WizardÏòµ¼£¬Á¬Ðø°´ÏÂÁ½¸öÏÂÒ»²½ºó¾Í»á³öÏÖSQL Server×¢²á½çÃ棬ÌîÈëÄãҪע²áµÄÊý¾Ý¿â²ÎÊý¾Í×¢²áºÃÁË¡£×¢²áÍêºó»áÔÚÄãµÄÊý¾Ý¿âÀï¶à¼¸¸ö±í£¨Èçͼ£©£º

6.ÉèÖÃÊý¾Ý¿âÁ¬½Ó×Ö·û´®:

´ò¿ªIIS£­>ÔÚĬÈÏÍøÕ¾»òÊÇÍøÕ¾ËùÔÚµÄÐéÄâĿ¼µã»÷ÓÒ¼üÑ¡ÔñÊôÐÔ£­>Ñ¡ÔñASP.NETÑ¡Ï£­>±à¼­ÅäÖã­>ÔÚ¡°³£¹æ¡±Ò³Ç©±à¼­¡°LocalSQLServer¡±Êý¾Ý¿âÁ¬½Ó×Ö·û´®£º

Data Server=.SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=sa123456

7.ÉèÖÃweb.configÎļþ:

ÔÚweb.configÎļþÌí¼ÓÈçϳÌÐò£º

<connectionStrings>
  <add name="LocalSQLServer" connectionString="Data Source=
.SQLEXPRESS;Initial Catalog=Northwind;
User ID=sa;Password=sa123456" 
providerName="System.Data.SQLClient"/>
 </connectionStrings>

ÕâÑù±ã´ó¹¦¸æ³ÉÁË¡£

ÏÂÃæÀ´²âÊÔ£º

1.¿íËɵÄÁ¬½Ó²âÊÔ£º

¿íËɵÄÁ¬½Ó²âÊÔʹÓÃSQLDataSourceVS2005·þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷Ñ¡ÖÐÊý¾Ý¿âµã»÷ÓÒ¼ü£­>Ñ¡ÔñÐÞ¸ÄÁ¬½Ó£­>ÌîÈë·þÎñÆ÷Ãû£­>ʹÓÃSQL ServerÉí·ÝÑéÖ¤ÌîÈëÓû§Ãûsa¼°ÃÜÂësa123456£­>Ñ¡Ôñ»òÊäÈëÒ»¸öÊý¾Ý¿âÃû£ºNorthwind£­>µã»÷²âÊÔÁ¬½Ó

¿íËɵÄÁ¬½Ó²âÊÔÁ¬½Ó³É¹¦²¢²»ÄÜ˵Ã÷Êý¾Ý¿â¾ÍÁ¬½ÓÁË£¬Ò»¿ªÊ¼ÎÒ¾ÍÊǹÒÔÚÕâÀ¿íËɵÄÁ¬½Ó²âÊÔ²âÊÔÁ¬½Ó³É¹¦£¬¿ÉÊÇʼÖÕÎÞ·¨¶Á³öÊý¾Ý¿âµÄÄÚÈݵ½ÍøÒ³ÀïÍ·¡£

2.ÑϽ÷µÄÁ¬½Ó²âÊÔ£º

ÔÚVS2005ÀïÑ¡ÔñÍøÕ¾²Ëµ¥£­>ASP.NETÅäÖýøÈëASP.NETÍøÕ¾¹ÜÀí¹¤¾ß£­>Ñ¡ÔñÌṩ³ÌÐò£­>µã»÷AspNetSQLProviderµÄ²âÊÔ£¬Èô²âÊԳɹ¦£¬ËµÃ÷Êý¾Ý¿âÉèÖÃÍêÈ«ÕýÈ·£¬·ñÔòµÃ´ÓÍ·À´¹ýºÃºÃ²é²éÎÊÌâÔÚÄÄÀï¡£

ÎÄÕ¼È룺a    ÔðÈα༭£ºa 
  • ÉÏһƪÎÄÕ£º

  • ÏÂһƪÎÄÕ£º
  • ¡¾·¢±íÆÀÂÛ¡¿¡¾¼ÓÈëÊղء¿¡¾¸æËߺÃÓÑ¡¿¡¾´òÓ¡´ËÎÄ¡¿¡¾¹Ø±Õ´°¿Ú¡¿
    ÍøÓÑÆÀÂÛ£º£¨Ö»ÏÔʾ×îÐÂ10Ìõ¡£ÆÀÂÛÄÚÈÝÖ»´ú±íÍøÓѹ۵㣬Óë±¾Õ¾Á¢³¡Î޹أ¡£©
    ¹ØÓÚÎÒÃÇ | RAIDÊý¾Ý»Ö¸´ | ÓÑÇéÁ´½Ó | RSSÉú³É | XMLÉú³É | ÎÄÕÂHTMLµØͼ | ÏÂÔØHTMLµØͼ

    °æȨËùÓÐ ±±ÑÇÊý¾Ý»Ö¸´ÖÐÐÄ
    È«¹úͳһ¿Í·þµç»°:4006-505-808
    ±±¾©Êк£µíÇøÓÀ·á»ùµØ·á»ÛÖз7ºÅвÄÁÏ´´Òµ´óÏÃB×ù205ÊÒ
    ¾©ICP±¸05011939
    /×ÄÁ