C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try { connection.connect() return true; } catch() { return false; } Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£ÒýÓà try { connection.connect() return true; } catch() { return false; } ²»¶®°¥£¬connectÊÇʲô·½·¨°¡£¿ C# code: SqlConnection conn = new SqlConnection(); if (conn.State == ConnectionState.Connecting) { ........ } Ö´Ðиöselect getdate();¿´ÊÇ·ñ³ö´í Õâ¸ö·½·¨×î¼òµ¥ ÏȲâÊÔÁ¬½ÓÒÑÏ ÔÚÄã×ÀÃæÉϽ¨Ò»¸ö ºó׺ÃûΪ udl µÄÎļþ ²âÊÔһϿ´Á¬½ÓÊÇ·ñ³É¹¦ ²»ºÃÒâ˼ ÎÒû¿´Çå³þÌâÄ¿ ÊÇÓÃC#ÒýÓà C# code SqlConnection conn=new SqlConnection(); if (conn.State== ConnectionState.Connecting) { ........ } Ö§³Ö¡¡¡¡¡¡ conn.State== ConnectionState.Connecting ÅжϾͿÉÒÔÁËe C# code Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/
Ïà¹ØÎÊ´ð£º
c# ÓÐûÓÐÓÃÓÚC/SµÄ htmlÎı¾±à¼Æ÷ ¾ÍÏñweb½çÃæµÄÎı¾ÄÚÈÝ±à¼Æ÷ up C/S»¹Òª±àÒëÆ÷¸ÉÂï°¡ ÓÖ²»ÓÿØÖÆÑùʽ Ã²ËÆÃ»ÓÐ°É Èç¹ûÓÐÁË֪ͨÏÂÎÒ ÎÒÒ²Òªliujintaohfbb@163.comÎÒµÄÓÊÏä ......
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
PBÖпª·¢µÄ¡£ DateTime startTime=DateTime(em_1.Text) DateTime endTime=DateTime(em_2.Text) string sql sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8 ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£ ½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë ÇëÎÊÎÊÌâÔÚÄÄ£¿ ×°¸öÖÐÎÄÈí¼þ¼´¿É. ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
ÓÐ×Ö¶Î ÈÕÆÚ£¬id ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´ ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£ SQL code: select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id) SQL ......