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

delphi ÔÚDBChartÏÔʾ - Delphi / Êý¾Ý¿âÏà¹Ø

ÎÒÏëʵÏÖ½«Ò»¸ö°àµÄ³É¼¨ °´ÕÕÁùÊ®·ÖÒÔÏ£¬ÁùÊ®µ½°ËÊ®£¬°ËÊ®ÒÔÉÏ·Ö³ÉÈý×é¡£
ÔÚDBChartµÄÌõÐÎͼÀXÖáÊÇÕâÈý¸ö·ÖÊý¶Î£¬YÖáʽ¸ö·ÖÊý¶ÎµÄÈËÊý¡£
Êý¾Ý¿âÊÇsql2000µÄ
Ê×ÏȽ¨Á¢ÁË´æ´¢¹ý³ÌÈçÏÂ
create procedure makeview
@classname varchar(10),@coursename varchar(20),@semeter varchar(5)
as
begin
  create table #view
  (
  score varchar(50),
  num int
  )
  insert into #view
  select 'score<60',count(1) from OrigScore where ×îÖճɼ¨<60 And °à¼¶ºÅ=@classname And ¿ª¿ÎѧÆÚ=@semeter And ¿Î³ÌÃû³Æ=@coursename
  group by ×îÖճɼ¨
  union all
  select '60<score<80',count(1) from OrigScore where ×îÖճɼ¨<80 And ×îÖճɼ¨>60 And °à¼¶ºÅ=@classname And ¿ª¿ÎѧÆÚ=@semeter And ¿Î³ÌÃû³Æ=@coursename
  group by ×îÖճɼ¨
  union all
  select 'score>80',count(1) from OrigScore where ×îÖճɼ¨>80 And °à¼¶ºÅ=@classname And ¿ª¿ÎѧÆÚ=@semeter And ¿Î³ÌÃû³Æ=@coursename
  group by ×îÖճɼ¨

  select * from #view

end;
ÊÇûÓдíÎóµÄ¡£
È»ºóÔڲ鿴°´Å¥Àï´úÂëÈçÏÂ
ADOStoredProc1.Close;
 ADOStoredProc1.ProcedureName:='makeview';
 ADOStoredProc1.Parameters.Refresh;
 ADOStoredProc1.Parameters.ParamByName('@classname').Value:=bjh1.Text ;
 ADOStoredProc1.Parameters.ParamByName('@coursename').Value:=kcm1.Text;
 ADOStoredProc1.


Ïà¹ØÎÊ´ð£º

Ç¿ÁÒ½¨ÒéDELPHI°æ¸ü»»´ó°æ - Delphi / ·Ç¼¼ÊõÇø

hongqi162¡¢windindance
´Ë2È˳¤ÆÚ²»ÔÚÏߣ¬ÌرðÊÇwindindance
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
hongqi162»¹ÊǾ­³£ÉÏÀ´×ª×ªµÄ

ÒýÓÃ
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
ÆäʵҲ²»ÊÇʲôÄÜÁ¦µÄÔ­Òò£¬Ö÷Òª¿ÉÄÜÊÇʱ¼äÎÊÌâ°É
¹¤×÷µÄ»¹ÒªÉÏ°à£¬Ñ§Ï ......

¸¶·ÑÇódelphiÆ´Òô±à³Ì - Delphi / ·Ç¼¼ÊõÇø

¾ßÌåÒªÇóÓ뱨³êQQ729851670
771234717

¡°Æ´Òô±à³Ì¡±ÊÇʲôÒâ˼

ÒýÓÃ
¡°Æ´Òô±à³Ì¡±ÊÇʲôÒâ˼
1.¸øÒ»¸ö×Ö¿ÉÒÔÏÔʾƴÒô£¬¶àÒô×ֵĻ°ÄÜÏÔʾ¶ÔÓ¦µÄ¶à¸öÆ´Òô
2.¶Ô°üº¬¶àÒô×ֵĴÊÓïÖÇÄÜʶ±ð¸ø³öÆ´Òô¡£
3.¶ÔÒ»¶Î ......

¿ÄÇóC/SÔ´Âë - Delphi / Êý¾Ý¿âÏà¹Ø

ÏÖÓÐparadoxÊý¾Ý¿âʹÓÃBDEÇý¶¯£¬Äâ¸ÄΪC/S°æ£¬Ôö¼ÓÍøÂç¶ÁÈ¡Êý¾Ý¹¦ÄÜ¡£ÇëÄÄλ´óÏÀ£¬ÌṩԴÂë¡£
˵¾ä²»¿ÍÆøµÄ»°£¬ÓÃparadox×öC/SÊÇ×ÔÑ°ËÀ·¡£
»»Ò»¸öÍøÂçÊý¾Ý¿â

ÒòΪ²»Ï붯´óÊÖÊõ£¬½öÄܹ²Ïí¼¸¸öÎļþ¼´¿É¡£

Da ......

delphi IDEµÄÎÊÌâ - Delphi / VCL×é¼þ¿ª·¢¼°Ó¦ÓÃ

ÎÒÊÇÐÂÊÖÏ£Íû´ó¼ÒôÅç¡£¡£
¾ÍÊÇÏëÎÊһϠ¹ØÓÚIDEµÄÎÊÌâ··
ÕÒÁ˺þ㬾ÍÊÇûÕÒÈ«¡£
Ï£Íû´ó¸çÃÇÌṩһϹþ¡£¡£¡£¡£
лл··
ÄãÏëÎÊIDEµÄʲôÎÊÌâ

¿ÉÒÔ¾ßÌ嵽ʲôÎÊÌâÂï


ÏÖÔÚµÄͬѧÌáÎ ......

delphiµ÷ÓÃocx - Delphi / ÍøÂçͨÐÅ/·Ö²¼Ê½¿ª·¢

СµÜÏëÓÃdelphi×öÒ»¸ö²¦ºÅ³ÌÐò£¬½«µçÐŵÄÒƶ¯¹Ì»°ÓÃUSBÁ¬µ½µçÄÔÉÏ£¬Í¨¹ý±àдµÄ²¦ºÅ³ÌÐòÔÚµçÄÔÉϲ¦´òµç»°¡£
ÏÖÔÚÓÐÖÐÐ˵ÄocxºÍdll²å¼þ£¬½Ó¿Ú˵Ã÷Ò²¸øÁË¡£µ«ÊÇÒòΪûÓÐÕâ·½ÃæµÄ¾­Ñ飬Çë¸÷λ´óÏÀ¸øÓèÖ¸µã¡£Íò·Ö¸Ðл¡£¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ