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]¼ÓÉÏ£¨£©
ѧϰÖÐ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~¶¥Æð£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
¸ßÊÖ¶¼°ïÄã»Ø´ðÁË
ÎҾ͸æËß
Ïà¹ØÎÊ´ð£º
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
ÎÒÓÃjqueryÎÞË¢ÐÂÉÏ´«Í¼Æ¬ºó·µ»Øjson¸ñʽµÄÊý¾Ý±¨´í
£¨Êµ¼ÊÉÏͼƬÊÇÉÏ´«³É¹¦µÄÁË£¬Ö»ÊÇ·µ»Øjson¸ñʽ×ܶÁ²»µ½£¬×ÜÊDZ¨´í£©
ÎÒµ÷ÊÔÉÏ´«µÄashxÒ³ÈçÏÂ
ÎÞ·¨ÏÔʾ XML Ò³¡£
ʹÓà Ñùʽ±íÎÞ·¨²é¿´ XML ÊäÈë¡£Çë¸ü ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
¹«Ë¾¿ª·¢Ò»¸ö´¥ÃþÆÁ³ÌÐò£¬ÎÒ¸ºÔðµÄÒ»¿é£¬ÊµÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬µ±Êó±êµã»÷´°¿ÚÖÐͼƬ£¨Ò»ÕÅͼ·Ö³É¼¸²¿·Ö£©µÄÆäÖÐÒ»²¿·Öʱ£¬½«Õⲿ·ÖͼƬ½ØÈ¡³öÀ´£¬µ¯³öеĴ°¿Ú£¬½«½ØÈ¡³öµÄͼƬÏÔʾ³öÀ´¡£ÎÒʹÓÃRectangeÀà¿ØÖÆÁË·µ»Ø£¬ ......
ÍøÉÏCOPYÒÔ¼°ÕûÀí»Ø´ðÍøÓѵÄÎÊÌâ¡£´ó¼Ò¿ÉÒÔ¼ÓÈëÎÒн¨µÄQQȺһÆðÁÄÁÄ£¬¹²Í¬Ñ§Ï°¡£
QQȺºÅ£º109967503
c#µÄÒ»Ð©ÌØÕ÷£º
Íêȫ֧³ÖÀàºÍÃæÏò¶ÔÏó±à³Ì£¬°üÀ¨½Ó¿ÚºÍ¼Ì³Ð¡¢Ð麯ÊýºÍÔËËã·ûÖØÔØµÄ´¦Àí¡£
¶¨ÒåÍêÕû¡ ......