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 ......
°ÑÒµÎñ²ãµÄ¶¼Ð´ÔÚdllÎļþÖÐÁË£¬ÏÖÔÚÏëÒªÐ޸ģ¬´ó¼Ò¶¼ÓÃʲô¹¤¾ß´ò¿ª£¿
ÓÃvisual studio×Ô´øµÄ ildasm¿ÉÒÔÂð£¿
ÆÚ´ý¸ßÊÖ
LZºÃÀ÷º¦
Ó÷´±àÒëÈí¼þ
ÎÒÓÃReflectorÖ»ÄÜ¿´£¬²»Äܸİ¡£¿
ÓÐÃ ......
ASP.NET MVC¼Ü¹¹·¢²¼ÁË,ÄãÓÃÁËÂð£¿
»¹ÔÚѧϰÖÐ
ÎÒÒ²ÔÚѧϰ¡£ÂòÊ飬Ìý½Ì³Ì£¬¿´ÍøÉÏ×ÊÁÏ£¬ÏÂÔØÀý×Ó£¬¸Ð¾õÌý²»´íµÄ£¬²»¹ý±ÈÆ𹤳§Ä£Ê½£¬ËƺõÑ·É«Á˵㡣¡£¡£»¶Óµ½ÎÒ²©¿Í»¥Ïàѧϰ
¶¼ÓÃÁË5¸ö°æ±¾ÁË ´Ó PV1 µ½beta ......
·þÎñÆ÷ÏÖÔÚÊÇ¡£net 2.0µÄ
ÎÒÏÖÔÚµÄÏîÄ¿¾ÍÊÇasp.net mvc + linqµÄ£¬ÏÖÔÚ·þÎñÆ÷µÄ»·¾³ÅäÖÃÓò»ÁË¡£
²»ÖªµÀÓÐÇ°±²Åöµ½¹ýÕâÑùµÄÎÊÌâû¡£
ÄѵÀ·þÎñÆ÷±ØÐëҪװ.net3.5 ºÍ asp.net mvc
ÇëÇ°±²Ö¸µã
²»×°ÄãÈÏΪÄãÒªÔõô ......