Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP.NETÁ¬½ÓSQLServer³öÏֵĴíÎó£¬Ôõô½â¾öÄØ£¿

asp.netÁ¬½ÓSQLServer2005µÄʱºòÎÒ¿´ÊéÉÏÓÐ2ÖÖConnectionString·½·¨£¬ÎÒ¶¼ÊÔÁËÏ£¬£¨ÎÒµÄÊý¾Ý¿âbookdb.mdf£©
1.sqlconn.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\bookdb.mdf;Integrated Security=True;User Instance=True";
ÕâÖÖÁ¬½Ó³É¹¦ÁË

2.sqlconn.ConnectionString = "Data Source=localhost;Initial Catalog=bookdb;Integrated Security=True;";
ÕâÖ־ͳöÏÖÁË´íÎó£¬ÈçÏ£º
ÔÚÓë SQL Server ½¨Á¢Á¬½Óʱ³öÏÖÓëÍøÂçÏà¹ØµÄ»òÌØ¶¨ÓÚʵÀýµÄ´íÎó¡£Î´ÕÒµ½»òÎÞ·¨·ÃÎÊ·þÎñÆ÷¡£ÇëÑé֤ʵÀýÃû³ÆÊÇ·ñÕýÈ·²¢ÇÒ SQL Server ÒÑÅäÖÃΪÔÊÐíÔ¶³ÌÁ¬½Ó¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó)

ÕâÊÇʲô´íÎóÄØ£¿ÎÒÍøÉÏÒ²ËÑË÷¹ý£¬ËµÊÇÍâΧÅäÖÃÄÇÔ¶³ÌÁ¬½ÓÉèÖÃͬʱʹÓÃTCP/IPºÍnamed pipes£¬ÎÒÉèÖÃÁË£¬Êý¾Ý¿âÒ²ÖØÆôÁË£¬¿ÉÊÇÎÊÌ⻹ÊÇÄÇÑù£¬Ôõô½â¾öÄØ£¿
Ô¶³ÌÁ¬½Ósql server 2000·þÎñÆ÷µÄ½â¾ö·½°¸

¡¡¡¡Ò» ¿´ping ·þÎñÆ÷IPÄÜ·ñpingͨ¡£

¡¡¡¡Õâ¸öʵ¼ÊÉÏÊÇ¿´ºÍÔ¶³Ìsql server 2000·þÎñÆ÷µÄÎïÀíÁ¬½ÓÊÇ·ñ´æÔÚ¡£Èç¹û²»ÐУ¬Çë¼ì²éÍøÂ磬²é¿´ÅäÖ㬵±È»µÃÈ·±£Ô¶³Ìsql server 2000·þÎñÆ÷µÄIPƴдÕýÈ·¡£

¡¡¡¡¶þ ÔÚDos»òÃüÁîÐÐÏÂÊäÈëtelnet ·þÎñÆ÷IP ¶Ë¿Ú£¬¿´ÄÜ·ñÁ¬Í¨¡£

¡¡¡¡Èçtelnet 202.114.100.100 1433

¡¡¡¡Í¨³£¶Ë¿ÚÖµÊÇ1433£¬ÒòΪ1433ÊÇsql server 2000µÄ¶ÔÓÚTcp/IPµÄĬÈÏÕìÌý¶Ë¿Ú¡£Èç¹ûÓÐÎÊÌ⣬ͨ³£ÕâÒ»²½»á³öÎÊÌ⡣ͨ³£µÄÌáʾÊÇ¡°¡­¡­ÎÞ·¨´ò¿ªÁ¬½Ó,Á¬½Óʧ°Ü"¡£

¡¡¡¡Èç¹ûÕâÒ»²½ÓÐÎÊÌ⣬Ӧ¸Ã¼ì²éÒÔÏÂÑ¡Ïî¡£

¡¡¡¡1 ¼ì²éÔ¶³Ì·þÎñÆ÷ÊÇ·ñÆô¶¯ÁËsql ser


Ïà¹ØÎÊ´ð£º

asp.net·ÖÒ³ÎÊÌâ

select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......

ASP¿ò¼Ü - .NET¼¼Êõ / ASP.NET

±¾ÈËÒ»Ö±´ÓÊÂjavaµÄ¿ª·¢£¬ spring , strutsµÈµÈ£¬ ÏÖÔÚÂíÉÏÒª½ÓÒ»¸öasp.netµÄÏîÄ¿£¬ ²»ÖªµÀasp.netÖÐÓÐûÓкÍjavaÖеÄstrutsÀàËÆµÄ¶«Î÷£¬ ¿ÉÒÔÔÚËûµÄ»ù´¡ÉÏ£¬Ö±½Ó¿ª·¢£¬ ЧÂʸߣ¬ ¶øÇÒºÃά»¤ ¡£¡£ лл£¬Ï£Íû´ó¼Ò£¬¶ ......

sql ËÑË÷Óï¾ä - .NET¼¼Êõ / ASP.NET

<table style="width: 1000px"><tr>
  <td style="height: 38px; width: 35px;">
  ÐÕÃû</td>
  ......

Êý¾Ý±íÉú³ÉÌØ¶¨¸ñʽµÄxml - .NET¼¼Êõ / ASP.NET

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......

aspÒ³ÃæÏÔʾÐÅÏ¢ - .NET¼¼Êõ / ASP.NET

ÀàËÆÓÚcsdn ÓÒ±ßÓÃʲô¿Ø¼þÏÔʾÌù×Ó±êÌâ ÒÔ¼°ÔõÑù·ÖÒ³£¿¹òÇó¸ßÊÖ´ð¸´
Ðø£º¾ÍÏñµãµ½asp°æ È»ºóÏÔʾÌù×Ó

Ëæ±ãÄ㣡£¡
·ÖÒ³¿Ø¼þÕâ¸ö¾Í¶àÁË£¡
aspnetpager
http://www.webdiyer.com/AspNetPager

ÕâÀïÏÔʾÌù× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ