C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
²»¶®°¥£¬connectÊÇʲô·½·¨°¡£¿
C# code:
SqlConnection conn = new SqlConnection();
if (conn.State == ConnectionState.Connecting)
{
........
}
Ö´Ðиöselect getdate();¿´ÊÇ·ñ³ö´í
Õâ¸ö·½·¨×î¼òµ¥
ÏȲâÊÔÁ¬½ÓÒÑÏ ÔÚÄã×ÀÃæÉϽ¨Ò»¸ö ºó׺ÃûΪ udl µÄÎļþ
²âÊÔһϿ´Á¬½ÓÊÇ·ñ³É¹¦
²»ºÃÒâ˼ ÎÒû¿´Çå³þÌâÄ¿ ÊÇÓÃC#
Ö§³Ö¡¡¡¡¡¡
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ÎÒµÄÓÊÏä ......
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
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 ......