Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ "Ô¶


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

C#·¢Óʼþ21cn

21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½Ô­Òò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ