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

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Îı¾±à¼­Æ÷

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

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


up

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

C#asp.netÉú³É ExcelµÄÎÊÌâ

ÍøÉÏ¿´Á˺ܶ࣬ºÃÏñÕâÑùµ÷ÓúܺãºExcel.Application();
µ«ÊÇÐèÒªÒýÈëʲôÃüÃû¿Õ¼ä»òÕßdll²ÅÄÜÔËÐÐExcelÕâ¸öÀàÄØ£¿

Excel.dll

Excel.dllÔÚExcel°²×°³ÌÐòÏ£¬
using Microsoft.Office.Interop.Excel;
......

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

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

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

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

Çë½ÌÒ»¸ösqlÊý¾ÝɸѡÎÊÌâ

ÓÐ×Ö¶Î
ÈÕÆÚ£¬id

ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´

ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)

SQL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ