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

Access±¨´í¡°Óï·¨´íÎó ²Ù×÷·û¶ªÊ§¡± - .NET¼¼Êõ / C#

SQL code:

select A.commandKey,A.enabled,A.commandFile,A.targetControl,A.rightId,A.type,[B].[value] as commandType,A.state,[C].[value] as commandState,A.parent,A.commandText,A.commandTipText,A.icon,A.description
from t_commands as A
inner join t_parameters as B on [A].[type]=[B].[code]
inner join t_parameters as C on [A].[state]=[C].[code]
where B.id=3 and C.id=4





ÈçÉÏSQL£¬Ö´ÐеÄʱºò¾ÍÌáʾ¡°Óï·¨´íÎ󣨲Ù×÷·û¶ªÊ§£©ÔÚ¡®[A].[type]=[B].[code]  
inner join t_parameters as C on [A].[state]=[C].[code] ¡¯ÖС±µÄÌáʾ£¬È»ºóÎÒ·¢ÏÖÈç¹û°ÑºóÃæµÄjoinÓï¾äÈ¥µô²»Á¬½ÓµÄ»°¾ÍÄÜÕý³£²éѯ³öÊý¾Ý£¬ÊDz»ÊÇAccess²»Ö§³Ö¶à¸öÁ¬½Ó²éѯµÄ£¿
select * from (select * from table1 t1 left join table2 t2 on t1.id=t2.id) t left join table3
  t3 on t.id=t3.id 
Ö»ÓÐÓÃLEFT¡¡JOIN+RIGHT¡¡JOIN

select A.commandKey,A.enabled,A.commandFile,A.targetControl,A.rightId,A.type,.[value] as commandType,A.state,[C].[value] as commandState,A.parent,A.commandText,A.commandTipText,A.icon,A.description 
from (t_commands as A 
inner join t_parameters as B on [A].[type]=[B].[code] )
inner join t_parameters as C on [A].[state]=[C].[code] 
where B.id=3 and C.id=4


[b]¼ÓÉÏ£¨£©

ѧϰÖÐ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~¶¥Æð£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡


¸ßÊÖ¶¼°ïÄã»Ø´ðÁË
ÎҾ͸æËß


Ïà¹ØÎÊ´ð£º

ÀûÓÃC#±àдtxtת»¯µ½xmlµÄ³ÌÐò

txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔ­Êý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......

ajax¶ÁÈ¡ashxÊä³öµÄjsonÊý¾Ý±¨´í - .NET¼¼Êõ / C#

ÎÒÓÃjqueryÎÞË¢ÐÂÉÏ´«Í¼Æ¬ºó·µ»Øjson¸ñʽµÄÊý¾Ý±¨´í
£¨Êµ¼ÊÉÏͼƬÊÇÉÏ´«³É¹¦µÄÁË£¬Ö»ÊÇ·µ»Øjson¸ñʽ×ܶÁ²»µ½£¬×ÜÊDZ¨´í£©
ÎÒµ÷ÊÔÉÏ´«µÄashxÒ³ÈçÏÂ
ÎÞ·¨ÏÔʾ XML Ò³¡£ 
ʹÓà Ñùʽ±íÎÞ·¨²é¿´ XML ÊäÈë¡£Çë¸ü ......

winform±à³ÌÓëASP.NETÓÐÁ¬ÏµÂð - .NET¼¼Êõ / C#

ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼­Åжϵȶ¼ÐèÒªwinform»ù´¡

C#ÓïÑÔ 
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹

Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......

c# Winform ´¥ÃþÆÁ³ÌÐò - .NET¼¼Êõ / C#

¹«Ë¾¿ª·¢Ò»¸ö´¥ÃþÆÁ³ÌÐò£¬ÎÒ¸ºÔðµÄÒ»¿é£¬ÊµÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬µ±Êó±êµã»÷´°¿ÚÖÐͼƬ£¨Ò»ÕÅͼ·Ö³É¼¸²¿·Ö£©µÄÆäÖÐÒ»²¿·Öʱ£¬½«Õⲿ·ÖͼƬ½ØÈ¡³öÀ´£¬µ¯³öеĴ°¿Ú£¬½«½ØÈ¡³öµÄͼƬÏÔʾ³öÀ´¡£ÎÒʹÓÃRectangeÀà¿ØÖÆÁË·µ»Ø£¬ ......

C#ÓëJAVAµÄÓŵãÓëȱµã(½ö¹©²Î¿¼) - .NET¼¼Êõ / C#

ÍøÉÏCOPYÒÔ¼°ÕûÀí»Ø´ðÍøÓѵÄÎÊÌâ¡£´ó¼Ò¿ÉÒÔ¼ÓÈëÎÒн¨µÄQQȺһÆðÁÄÁÄ£¬¹²Í¬Ñ§Ï°¡£
  QQȺºÅ£º109967503
c#µÄÒ»Ð©ÌØÕ÷£º
Íêȫ֧³ÖÀàºÍÃæÏò¶ÔÏó±à³Ì£¬°üÀ¨½Ó¿ÚºÍ¼Ì³Ð¡¢Ð麯ÊýºÍÔËËã·ûÖØÔØµÄ´¦Àí¡£
¶¨ÒåÍêÕû¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ