Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÎÒµÄÓÊÏä ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

ÇóÒ»¸ösql Óï¾ä

  table1
  Ãû³Æ      Èë¿âÊý
  CT»ú        3   
  CT»ú        5
  X¹â»ú      4 ......

²»Ã÷°×µÄSQL×¢ÈëÎÊÌâ

ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò

ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ