Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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




Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

sql ½ØÈ¡×Ö·û´®

ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......

ÇóÒ»sql¡¾Ð»Ð»¡¿ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
a±í:
 p_id status  
  1 0
  2 0
b±í
rec_id pid purchase_qty receive_qty flag
1 1 10 10 0
2 ......

Çó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

CREATE PROCEDURE [selectvipcompany] 
@username varchar(50), 
@companyname varchar(50), 
@endtime varchar(1) 
AS 
declare @sql varchar(1000) 
set @sql=''  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ