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µÄ°æ±¾£¿
¶ÔµÄ£¡
Äܸø¿´Ò»ÏÂÄãµÄÁ¬½Ó×Ö·û´®Âð£¿ÊDz»ÊÇÄÇÀï³öÁËÎÊÌâ
----------------ÊÔÊÔ --------------
´Ó "¿ªÊ¼²Ëµ¥ "µ÷³ö "ÅäÖù¤¾ß "ÖÐµÄ "SQL Server ÍâΧӦÓÃÅäÖÃÆ÷ ".È»ºóµ¥»÷ "·þÎñºÍÁ¬½ÓÍâΧӦÓÃÅäÖÃÆ÷ ",Ñ¡ÔñÊý¾Ý¿âʵÀý(ĬÈÏÊÇ "SQLEXPRESS ",Ñ¡Ôñdatabase EngineµÄ "Ô¶
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸ö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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½ÔÒò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......