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/
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд. Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ ÔÂÈÕ×éºÏµÄÐÎʽÈçÏ 10-17/04-20 ÔÂ-ÈÕ/ÔÂ- ......
DateTime startTime=DateTime(em_1.Text) DateTime endTime=DateTime(em_2.Text) string sql sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´ °à¼¶±í ½Ìʦ±í °à¼¶ID & ......
ÓÐ×Ö¶Î ÈÕÆÚ£¬id ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´ ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£ SQL code: select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id) SQL ......