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

Sql server Óë vs.netµÄ°²×°ÎÊÌâ

ÔÚÏȰ²×°ÁËvs.net 2008 ºóÔõô°²×° Sql server 2005¡£ËÑÁ˺ܶàÎÄÕ£¬¿ÉÊÇ»¹ÊÇûÓп´µ½Ôõô²ÅÄܹ»°²×°ÉÏ¡£

×ÜÊÇÔÚ°²×°sql serverµÄ¿Í»§¶Ë£¨management studio£©Ê±ºò±¨´í£¬×°ÄǸöÊý¾Ý¿â server ÒýÇæµÄʱºòûÓÐÎÊÌâ¡£°Ñ.net frameworkÐ¶ÔØÁËÒ»ºó£¬»¹ÊÇ×°²»ÉÏ¡£ºÃÏñ˵ÒѰ²×°µÄ°æ±¾±È´ý°²×°µÄ°æ±¾¸ß£¬Éý¼¶Ê§°Ü¡£¸ã²»Çå³þµ½µ×ÒªÐ¶ÔØ×°vsʱºò×°µÄÄÇЩ×é¼þ¡£

ÓÐûÓиßÊÖ¸ø¸ö¿ÉÒÔÓõķ½°¸°¡£¬ÐèÒªÏÈÐ¶ÔØÄÇЩ¸ö×é¼þ£¡£¡Ð»ÁË
¹þ¹þ£¬ÎÒÊÇÏȰ²×° µÄ2005£¬ÔÙ×°µÄVS2008 ,û·¢ÏÖÎÊÌâ

ÏÈ2005ºó2008°É£¬Ã»°ì·¨£¬.net frameworkʼÖÕ²»¹»Îȶ¨



End_rbody_60301788//-->
¸Ã»Ø¸´ÓÚ2009-10-11 09:02:57±»¹ÜÀíԱɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP








cedar_zhao
(cedar_zhao)

µÈ¡¡¼¶£º



#4Â¥ µÃ·Ö£º20»Ø¸´ÓÚ£º2009-10-10 21:11:21



ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!




Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º ......

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......

SQL Server 2005 ÎÞ·¨µÇ½

ÎÊÌâÃèÊö

    ÓÐÁ½Ì¨·þÎñÆ÷ DB1£¨10.10.10.1£©  DB2£¨10¡¢10¡¢10¡¢2£©    ÕâÁ½Ì¨»úÆ÷×öµÄ  Ⱥ¼¯  ÐéÄâIP £¨10¡¢10¡¢10¡¢11£©

¹úÇì·Å¼Ù»ØÀ´·¢ÏÖ ·þÎñÆ÷ ÎÞ·¨µÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ