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
Ïà¹ØÎÊ´ð£º
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 ......
±¾ÈËÒ»Ö±´ÓÊÂjavaµÄ¿ª·¢£¬ spring , strutsµÈµÈ£¬ ÏÖÔÚÂíÉÏÒª½ÓÒ»¸öasp.netµÄÏîÄ¿£¬ ²»ÖªµÀasp.netÖÐÓÐûÓкÍjavaÖеÄstrutsÀàËÆµÄ¶«Î÷£¬ ¿ÉÒÔÔÚËûµÄ»ù´¡ÉÏ£¬Ö±½Ó¿ª·¢£¬ ЧÂʸߣ¬ ¶øÇÒºÃά»¤ ¡£¡£ лл£¬Ï£Íû´ó¼Ò£¬¶ ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
ÀàËÆÓÚcsdn ÓÒ±ßÓÃʲô¿Ø¼þÏÔʾÌù×Ó±êÌâ ÒÔ¼°ÔõÑù·ÖÒ³£¿¹òÇó¸ßÊÖ´ð¸´
Ðø£º¾ÍÏñµãµ½asp°æ È»ºóÏÔʾÌù×Ó
Ëæ±ãÄ㣡£¡
·ÖÒ³¿Ø¼þÕâ¸ö¾Í¶àÁË£¡
aspnetpager
http://www.webdiyer.com/AspNetPager
ÕâÀïÏÔʾÌù× ......