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# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï° http://www.hxzi.com/view/61402.html B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
ÍøÉÏ¿´Á˺ܶ࣬ºÃÏñÕâÑùµ÷ÓúܺãºExcel.Application(); µ«ÊÇÐèÒªÒýÈëʲôÃüÃû¿Õ¼ä»òÕßdll²ÅÄÜÔËÐÐExcelÕâ¸öÀàÄØ£¿ Excel.dll Excel.dllÔÚExcel°²×°³ÌÐòÏ£¬ using Microsoft.Office.Interop.Excel; ......
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ? dts¹¤¾ß µ¼Èëµ¼³ö¹¤¾ß. DD ¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»ÁËµÄ Ö±½ÓÐ ......
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 ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8 ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£ ½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë ÇëÎÊÎÊÌâÔÚÄÄ£¿ ×°¸öÖÐÎÄÈí¼þ¼´¿É. ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......