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

SQL SERVER 2005 ²»ÔÊÐíÔ¶³ÌÁ¬½Ó - .NET¼¼Êõ / C#

ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) 




ÐÐ 23: SqlDataAdapter dataAp = new SqlDataAdapter(comd);
ÐÐ 24: DataSet dt = new DataSet();
ÐÐ 25: dataAp.Fill(dt, "news");ÐÐ 26: this.GridView1.DataSource = dt.Tables[0].DefaultView;
ÐÐ 27: this.GridView1.DataBind();
¸÷λ´óϺÃÇ £¡ÇëÎÊÕâÊÇʲôÒâ˼£¡¡¡ÎÒÊÔ¹ý¸ÄÁËSQL server ÀïÃæµÄÅäÖùÜÀíÆ÷ºÍÍâΧӦÓÃÅäÖÃÆ÷ÁË£¡ ½á¹û¶¼²»Ðа¡£¡

ÅäÖùÜÀíÆ÷ tcp/ipÆôÓÃÁËÂð

Á¬½Ó×Ö·û´®ÊÇ·ñÕýÈ·
 
¿ªÊ¼¡¡£­£¾¡¡ËùÓгÌÐò¡¡£­£¾¡¡MS SQL Server £­£¾¡¡ÅäÖù¤¾ß¡¡£­£¾¡¡Sql serverÍâΧӦÓÃÅäÖÃÆ÷¡¡£­£¾·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷¡¡£­£¾¡¡´ò¿ªMSSQLSERVER½ÚµãϵÄDatabase¡¡Engine½Úµã£¬Ñ¡Ôñ"Ô¶³ÌÁ¬½Ó"£¬½ÓÏÂÀ´½¨ÒéÑ¡Ôñ¡±Í¬Ê±Ê¹ÓÃTCP/IPºÍnamed pipes ¡±,È·¶¨ºó£¬ÖØÆôÊý¾Ý¿â·þÎñ£® 


@@

»Ø¸´2# 3#¡¡ÒÔÉÏ·½·¨ÎÒ¶¼ÊÔ¹ýÁË£¡

ÄãµÄSQL2005µÄ°æ±¾£¿

ÒýÓÃ
ÄãµÄSQL2005µÄ°æ±¾£¿


¶ÔµÄ£¡

Äܸø¿´Ò»ÏÂÄãµÄÁ¬½Ó×Ö·û´®Âð£¿ÊDz»ÊÇÄÇÀï³öÁËÎÊÌâ

----------------ÊÔÊÔ --------------
´Ó "¿ªÊ¼²Ëµ¥ "µ÷³ö "ÅäÖù¤¾ß "ÖÐµÄ "SQL Server ÍâΧӦÓÃÅäÖÃÆ÷ ".È»ºóµ¥»÷ "·þÎñºÍÁ¬½ÓÍâΧӦÓÃÅäÖÃÆ÷ ",Ñ¡ÔñÊý¾Ý¿âʵÀý(ĬÈÏÊÇ "SQLEXPRESS ",Ñ¡Ôñdatabase EngineµÄ "Ô¶


Ïà¹ØÎÊ´ð£º

¼±ÇóASP¡£NETC#¹ºÎï³µ´úÂë

×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡

www.51aspx.com

ȥϠ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ