Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

C#·¢Óʼþ21cn

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

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

SQL clr - MS-SQL Server / ·Ç¼¼Êõ°æ

ÏëÓÃSQL CLR×öÈçϵĴ洢¹ý³Ì,µ«ÊÇ·¢ÏÖ±¨´í: 
{ÓÉÓÚ´úÂëÒѾ­¹ýÓÅ»¯»òÕß±¾»ú¿ò¼ÜλÓÚµ÷ÓöÑÕ»Ö®ÉÏ£¬ÎÞ·¨¼ÆËã±í´ïʽµÄÖµ¡£} 
¶øÇÒÈç¹ûÊý¾Ý´Ócase 1ͨ¹ýʱ¾ÍÊÇÕýÈ·µÄ,´Ócase 2ͨ¹ýʱ´íÎó 
²¢ÇÒÔÚc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ