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

vc ado sqlserver´ò°ü·¢²¼ºóµÄÆæ¹ÖÎÊÌâ

Á½Ì¨µçÄÔ£º¿ª·¢»úºÍÄ¿±ê»ú¡£
¿ª·¢»ú »·¾³£ºvc6.0+sql server2000
Ä¿±ê»ú »·¾³£ºsql server2000

ʹÓÃÄ¿±ê»úÄ¿µÄ£º²âÊÔ³ÌÐòÊÇ·ñÄܳɹ¦·¢²¼µ½Ã»ÓÐvc»·¾³µÄpcÉÏ¡£

²½Ö裺
1.½«¿ª·¢»úÉϵÄÊý¾Ý¿â±¸·ÝºóÔÚÄ¿±ê»ú»Ö¸´£¬³É¹¦£»

2.¿ª·¢»ú´úÂëÖÐÉèÖÃadoµÄdata sourceΪĿ±ê»úµÄserver£¬±àÒë³örelease°æ±¾¡£

3.ÔÚ¿ª·¢»úÉÏÔËÐÐrelease°æµÄexe£¬¿ÉÒԳɹ¦Á¬½Ó²¢·ÃÎÊÄ¿±ê»úµÄsql·þÎñÆ÷£¬¸÷¿Ø¼þ¶¼Õý³££»

4.½«releaseÓÃinstallshield´ò°üºó£¬ÔÚÄ¿±ê»úÉÏ°²×°ÔËÐУ¬Á¬½ÓÊý¾Ý¿âÈ´»¹ÊÇÒªÁ¬½Óµ½¿ª·¢»úµÄserver¡£

Ææ¹ÖÎÊÌ⣬ºÜÊÇÓôÃÆ£¬¸ßÊÖ°ï¿´¿´£¡
ÄÑÌâ°¡  °ïæ°¡

1¡¢ÄãµÄexe¿ÉÒÔÔÚÄ¿±ê»úÖÐÕý³£ÔËÐÐÂð£¿
2¡¢ÄãµÄÊý¾Ý¿âIP/Server IPÉèÖöÔÁËÂð£¿

ÒýÓÃ
1¡¢ÄãµÄexe¿ÉÒÔÔÚÄ¿±ê»úÖÐÕý³£ÔËÐÐÂð£¿
2¡¢ÄãµÄÊý¾Ý¿âIP/Server IPÉèÖöÔÁËÂð£¿


¾ÍÊÇÔÚÄ¿±ê»úÔËÐÐexeºó£¬×ÜÊÇÁ¬½ÓÎÒ±¾»úµÄserver£¬ÒѾ­ÉèÖÃÁËÄ¿±ê»úµÄserverΪdata source

ÊÇÄãµÄConnectionStringÓÐÎÊÌâ

Á¬½Ó×Ö·û´®Ö¸Ïòµ½¿ª·¢µÄÄÇ̨»úÆ÷ÁË

ÇëʹÓà 127.0.0.1 ÒÔÖ¸Ïò±¾»ú¡£

ÕÒµ½ÎÊÌâÁË£¬ÊÇÄǸöadodc¿Ø¼þµÄÎÊÌ⣬ÉèÖÃËücontrolÊôÐÔÖеÄUse Connection StringµÄʱºòÐèÒªbuildһϣ¬È»ºóÑ¡Ôñ·þÎñÆ÷ΪĿ±ê·þÎñÆ÷£¬µ«ÊǺÃÏñµÃɾ³ýÁËÔÙÕâÑùÉèÖòÅÄÜÆð×÷Óã¬ÔÚÔ­À´µÄÉÏÃæ¸ÄÁËÖ®ºó²»Æð×÷Óã¬Ì«Ææ¹ÖÁË¡£


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......

Ôõô²ÅÄÜÈÃc#³ÌÐòÍÑÀësqlServerÒ²ÄÜ·ÃÎÊÊý¾Ý¿â£¿


ÈçÌâ
±¾È˲ËÄñ
²»ÊÇÓÃsql×öµÄÊý¾Ý¿âÈí¼þ µÄʹÓûúÆ÷ÉÏ ¶¼µÃ°²×° sqlServer°É¡£¡£..
ÎÒ¿´µ½ÓÐЩÈí¼þ µã¿ªÈí¼þ Êý¾Ý¿â¾ÍÒѾ­µ¼Èë½øÈ¥ÁË ¸ùĿ¼ֻÓиömdb
ÇëÎʸßÊÖÃÇÓûùÓÚsqlµÄ c#³ÌÐò Ôõô×ö³ÉÄÇÑù ......

Çósqlserver 2005 Êý¾Ý¿âÁ¬½Ó½â¾öÎÊÌâ¡£

ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......

sqlServer like

Ç°ÖÃlikeÈçºÎʹÓÃ
      ±ÈÈ磬¡®1,2¡¯   like   ¡®1,2,3¡¯ÔõôƥÅä
      ÊDz»ÊÇ¡®%1,2%¡¯like¡®1,2,3¡¯
charindex(',' + '1,2' + ',&# ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ