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

¹ØÓÚDelphiʹÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿âµÄÎÊÌâ

СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐÍ»æÍ¼£¬Íû¸æÖªÒ»¶þ£¬²»Ê¤¸Ð¼¤£¡
ÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¿
DBGrid.datasource.dataset.fieldbyname('xxx').asfloat

ÒýÓÃ
ÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¿
DBGrid.datasource.dataset.fieldbyname('xxx').asfloat

¶Á³öµÄÊý¾ÝʱԭÀ´Êý¾Ý¿âÖж¨ÒåµÄDOUBLEÀàÐÍÂð£¿
ÎÒÏë¶Á³öÌØ¶¨µÄÊý¾Ý£¬È»ºó»æÖÆÊý¾ÝµÄÀúÊ·ÇúÏßͼ

DBGrid.datasource.dataset.fieldbyname('xxx').value

ÒýÓÃ
¶Á³öµÄÊý¾ÝʱԭÀ´Êý¾Ý¿âÖж¨ÒåµÄDOUBLEÀàÐÍÂð£¿
ÎÒÏë¶Á³öÌØ¶¨µÄÊý¾Ý£¬È»ºó»æÖÆÊý¾ÝµÄÀúÊ·ÇúÏßͼ

¶Á³öµÄÊý¾ÝʱԭÀ´Êý¾Ý¿âÖж¨Òå¿ÉÒÔ²»ÊÇDOUBLEÀàÐÍ£¬µ«Äãת»»³ÉdoubleÐ͵ϰ£¬ÐèÒªÊý¾Ý¿âÖеÄÄÚÈÝÒª·ûºÏdoubleÀàÐ͵ĹæÔò£¬·ñÔò¾Í»á³ö´í

DataSet.First;
while Not DataSet.Eof do
begin
With DataSet
  value:=DBGrid.datasource.dataset.fieldbyname('xxx').value;
end
DataSet.Next;
end;


Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

delphi ÔõÑù½«ucs2±àÂëת»»³ÉÖÐÎÄ

½ÓÊÕµ½µÄÎı¾ÄÚÈÝÊÇucs2±àÂë¸ñʽ£¬ÇëÎÊÔõÑùת»»³ÉÖÐÎÄ
°´ÎÒµÄÀí½â£¬UCS-2ÊÇ×Ö·û¼¯£¬¾ßÌåµÄ±àÂëÓÐUTF-8£¬UTF-16 (LE/BE)µÈ¡£
Èç¹ûÄãÓÃDelphi 2009¼°ÒÔÉϰ汾£¬¿ÉÒÔ¿´¿´TEncodingÀà¡£
btw. Äã˵µÄת»»³ÉÖÐÎÄÊÇɶÒâË ......

delphi動態調ÓÃdllµÄÀ§»ó

procedure RunFunction;  
  type  
  TFunc = function(A: Integer): Integer;stdcall;¡¡//ÕâÀï¸ù¾ÝDLLÀïÃæº¯ÊýµÄÉùÃ÷ÐÞ¸Ä  
  var  
  ......

DelphiÔõôȡ·µ»ØÄÚÈÝÖеÄÖ¸¶¨²¿·Ö.

·µ»ØµÄÄÚÈÝÊÇÈçÏ´úÂë,ÔõôÄÜÇþµÀ2b?
<p class="text1">1a </p>
<p class="text1">2b </p>
<p class="text1">3c </p>
<p cl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ