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

vb 6.0 + sql combo Óë text ÎÊÌâ

¸÷λ¸ßÊÖÃÇ  Ê×ÏÈлл´ó¼Ò¸øÎÒ½²½âÉϴεÄÁ½¸öÎÊÌâ  ¿É°ïÁËÎÒ´óæÁË¡£Ð¡µÜÓÖ³öÏÖÐÂÎÊÌâÁË£¬Âé·³´ó¼ÒÖ¸½ÌÖ¸½Ì
ÎÒÓà combo µ÷ÓÃtbs_xsxx±íÖÐµÄ name×ֶΣ¬ ÏëÒª  text ÖгöÏÖtbs_xsxx±íÖÐÏàÓ¦µÄ×Ö¶Î class ÃèÊöÓÐÎÊÌ⣬Àý×ÓÈçÏ£º
tbs_xsxx
name  class
ÕÅÃ÷  ÈýÄê¼¶Îå°à
Àî¿Æ  ÎåÄê¼¶Ëİà
¡­¡­  ¡­¡­
¡­¡­  ¡­¡­
ÏÖÔÚÔÚform´°ÌåÖУ¬ÓÐcombo1  text1

ÎÒÏëÈà µãcombo1ÖÐµÄ ÕÅÃ÷  ÔÚ text1ÖоͳöÏÖ  ÈýÄê¼¶Îå°à
        µãcombo1ÖÐµÄ Àî¿Æ  ÔÚ text1ÖоͳöÏÖ  ÎåÄê¼¶Ëİà

Çë¸ßÊÖÃÇÖ¸½ÌÖ¸½Ì£¡£¡£¡
VB code:

'ÓòéѯÓï¾ä "select class from tbs_xsxx where name='" & trim(combo1.text) & "'"
'ÕÒµ½¶ÔÓ¦µÄ°à¼¶



ÒýÓÃ
VB code'ÓòéѯÓï¾ä "select class from tbs_xsxx where name='" & trim(combo1.text) & "'"
'ÕÒµ½¶ÔÓ¦µÄ°à¼¶


ÊÇÔÚcombo1_chickÀïÃæÐ´Õâ¸ö´úÂëÂð£¿
Äܲ»ÄÜÏêϸµã лл£¡£¡ 

ÎҵȵÃÕæÐÁ¿à°¡£¡£¡Ð»Ð»É³·¢£¡£¡

slq = ¡°select name  class from...¡±

½¨Á¢¸öcollection¡£
combo¡£add rs£¨0)
col.add rs(1)

combol_click
text = col(combo.listindex + 1)
end sub
¿´µÄ¶®°É¡£
{{----}


Ïà¹ØÎÊ´ð£º

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

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

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

vbÖÐÈçºÎʵÏÖ¶ÔÏóÊôÐԵĶ¯Ì¬ÉèÖà - VB / »ù´¡Àà

±¾ÈËʹÓõÄÊÇVB6.0°æ±¾
¼ÙÉèÓÐÒ»¸ö¶ÔÏóA£¬AÄÚÓÐÀàÐÍΪBµÄ¶ÔÏóÊôÐÔ¡£ÏÖÔÚµÄÎÊÌâÊÇ£¬ÐèÒªÌí¼ÓÈô¸É¸öB¶ÔÏó×÷ΪA¶ÔÏóµÄÊôÐÔ¡£È磬
 A.B1,A.B2,...
µ«¾ßÌåÌí¼Ó¶àÉÙ¸öB¶ÔÏó×÷ΪA¶ÔÏóµÄÊôÐÔÔòÊÓ¾ßÌåÇé¿ö²»Í¬¶ø²»Í¬ ......

sql server - Java / Eclipse

Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....

ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡

½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......

sql ËÑË÷Óï¾ä - .NET¼¼Êõ / ASP.NET

<table style="width: 1000px"><tr>
  <td style="height: 38px; width: 35px;">
  ÐÕÃû</td>
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ