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

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect Timeout=30";
£¨1£©£¨2£©ÓÐÇø±ðÂð£¿
SqlConnection objConnection=new SqlConnection(strConnection);

Èç¹ûÁ¬½Ó202.196.35.3ÉϵÄSQLserverÊý¾Ý¿â
ÊÇ·ñServer=202.196.35.3¼´¿É£¿
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; 

http://www.connectionstrings.com/

Â¥Ö÷²Î¿¼´ËÍøÕ¾°É¡£
ʲôÁ¬½Ó¶¼ÓÐÁË

當È»ÓÐ區別ѽ£¬Server¿ÉÒÔÊÇIPµØÖ·¡£
µÚÒ»種£ººÃÏñÊDzÉÓÃWindows認證ģʽ¡£µÚ¶þ種£º²ÉÓÃSQL Server認識ģʽ£¬ËùÒÔ¼ÓÈëSQL ServerµÄÓÃ戶與ÃÜ碼¡£


Ïà¹ØÎÊ´ð£º

c# ÓÐûÓÐÓÃÓÚC/SµÄ htmlÎı¾±à¼­Æ÷

c# ÓÐûÓÐÓÃÓÚC/SµÄ htmlÎı¾±à¼­Æ÷

¾ÍÏñweb½çÃæµÄÎı¾ÄÚÈݱ༭Æ÷


up

C/S»¹Òª±àÒëÆ÷¸ÉÂï°¡
ÓÖ²»ÓÿØÖÆÑùʽ
Ã²ËÆÃ»Óаɠ Èç¹ûÓÐÁË֪ͨÏÂÎÒ  ÎÒÒ²Òªliujintaohfbb@163.comÎÒµÄÓÊÏä ......

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ