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

Ò»¸öÓеãÍ·ÌÛµÄSQLÎÊÌâ

ÎÒÔÚÒ³Ãæ·ÅÈëÒ»¸öCheckBoxList¿Ø¼þ£¬Êý¾Ý´ÓÊý¾Ý¿âÖÐÈ¡³ö£¬²¢°ó¶¨µ½CheckBoxListÉÏ£¬ÎÒ´ÓÊý¾Ý¿âÖÐÈ¡³öij±íÖеÄËùÓÐÁÐÏÔʾµ½CheckBoxListÉÏ£¬µ«ÊÇÎÒÏëÒªÊǵÄÁÐÀïÃæµÄ±¸×¢£¬±ÈÈçname,ÏÔʾÐÕÃû,year£¬ÏÔʾÄêÁ䣬ÎÒµÄÊý¾ÝÊÇÒªÏÔʾ¸øÓû§¿´£¬Óû§¿Ï¶¨¿´²»¶®¸´ÔÓµÄÓ¢ÎÄ£¬Ò²²»Ô¸Òâ¿´£¬ÈçºÎ°Ñ±íÀïÃæµÄÁÐ×¢ÊÍÕ¹ÏÖ¸øÓû§¿´£¿ÇóÓï¾ä
select age as ÏÔʾÄêÁä
from ta

SQL code:
²éѯµÄʱºòÈ¡±ðÃû²»ÐÐÂð?
select name as ÐÕÃû.... from tb


ÒýÓÃ
select age as ÏÔʾÄêÁä
from ta
1

¿ÉÒÔÓÃÉÏÃæµÄ×ö·¨,Ò²¿ÉÒÔÔÚDataBoundʼþÖн«TextÊôÐÔÖØÐ´Ò»ÏÂ,ÏÔʾ³öÀ´µÄÄÚÈݾÍÊÇÓû§ÄܽÓÊܵÄÁË

²»µ¥µ¥ÊÇSQLµÄÎÊÌ⣬»¹Ç£³¶µ½ASP.NET¡£
´ó¸ÅÊÇÕâÑùµÄ£¬ÎÒÊäÈëÒ»¸ö±íÃû£¬µã»÷È·¶¨£¬ÔÚCheckBoxListÉÏÏÔʾËùÓеÄÁÐÃû£¬Óû§¸ù¾Ý×Ô¼ºÐèÇó£¬Ñ¡ÔñÐèÒªÏÔʾµÄÁÐÃû£¬µ±È»£¬ÕâÀïµÄÁÐÃû¾ÍÊDZðÃû£¬²»ÊÇÊý¾Ý¿â±íÀïµÄÁÐÃû£¬ÎÒѡȡ¼¸¸öÁУ¬µãÌá½»£¬»á°ÑÕ⼸¸öÁеÄÐÅÏ¢´«ÈëÁíÒ»¸öÒ³Ãæ£¬ÎÒÈçºÎµÃµ½ÎÒѡȡµÄÁУ¿£¿

ÏÔʾµÄʱºò¸ø³ö±ðÃû ¼´£ºSQL code:
select [name] as ÐÕÃû.... from ±í

»Øµ÷µÄʱºò¸ü¾ßcheckboxlistµÄindexÖµÊÇÄļ¸ÕÅ±í ¼´
C# code:
if(CheckBoxList1.Items[i].Selected)


´ò´íÁË
C# code




Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÇóSQLÓï¾ä£¡£¡£¡ - MS-SQL Server / Ó¦ÓÃʵÀý

clientserial devseral chunnelnum devdata5
CZ0001 308001 5000 11.1
CZ0001 308001 5001 11.2
CZ0001 308001 5002 11.3
CZ0001 3080 ......

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ºÅ