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µÄ "Ô¶
Ïà¹ØÎÊ´ð£º
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£» QQ£º413763818£» eamil:swebook@126.com ÍøÉÏÒ»´ó¶Ñ£¡ www.51aspx.com ȥϠ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â ´óÖÂÈçÏ ½¨Á¢ÁÙʱ±í ¶¨ÒåÔ±¹¤Óαê Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾) ......
protected void btnLogin_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login"); &nb ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......