ado+sql´´½¨±í
¸÷λ´ó¼ÒºÃ
VC+ado+sql´´½¨±í
ÎÒÊý¾Ý¿âÀïÓÉÒ»ÕÅTABLE±í£¬ÏÖÔÚÎÒÒªÒ»ÕÅTABLE1±í¡££¨×¢£ºÎÒËù½¨µÄTABLE1±íͨ¹ý¶Ô»°¿òÉϵÄÒ»±à¼¿òÊäÈ룬µã»÷°´Å¥ºóÒª½¨Á¢TABLE1±í£¬²¢ÇÒTABLE1±íÖеÄËùÓÐ×Ö¶ÎÊÇ´ÓTABLE±íÖжÁ³ö£¨³ýTABLE±íÖеĵÚÒ»¸öID×ֶΣ©Ò²¾ÍÊÇ˵TABLE1ÖеÄ×ֶκÍTABLEÖеÄÒ»Ñù³ýID×Ö¶ÎÍ⣩£¬Õâ¸öÎÊÌâÔõô½â¾öѽ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
лл
ÔõôûÓÐÈ˻شð£¬Õâ¸öÎÊÌâºÜÄÑÂ𣿣¿£¿£¿£¿£¿
SELECT CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS userynht,
//ºì×Ö±êʶµÄÊÇÄãÒª¶ÁÈ¡µÄ±í
ÄãµÄQQÔÚÏßÂð£¿
Ïà¹ØÎÊ´ð£º
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
t_a{
id ,
name,
age,
pid, ¶ÔÓ¦t_b(id)
}
t_b{
id£¬
ywlx£¬
}
±¾ÈËÏëÓÃ
ÕâÖÖÀàÐ͵IJéѯ
String sql = "select name,age,y ......