delphiÈçºÎÏòAccessÊý¾Ý±íÖÐ×Ô¶¨Òå×Ö¶Î?È»ºóÏÔʾµ½DBGridÖÐ
ÔõôûÈËÀíÎÒѽ
·Ö·Ö߯ÉÙßÖ£¬Ò»°ãÈ˶¼ÀÁµÃ½øÀ´¡¡*^_^*
SQL
creat table TableName(ID Counter Primary Key,FieldName varchar(20))
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('alter Table TestTabel add COLUMN ID Counter Primary Key' ......
Ïò¸÷λ¸ßÊÖÇóÖú¡£
ÎÒÓÃdelphi2009±àдÁËÒ»¸ö¹ÜÀíϵͳ£¬Ê¹ÓõÄÊÇaccessÊý¾Ý¿â¡£ÏÖÔÚÏëͨ¹ý¶àÈËÒ»Æð¼ÈëÊý¾Ýºó£¬½«Êý¾Ýµ¼³ö£¬µ¼³öµÄÊý¾Ý¿â°üº¬¶à¸öÏàͬµÄ±í¡£ÔÙ½«µ¼³öµÄÊý¾ÝÒÀ´Îµ¼È뵽ͬһ¸öÊý¾Ý¿âµÄÏàͬ±íÖУ¬µ¼ÈëÖ´ÐÐÓï¾äÈçÏ£º
procedure TMain.N_ImportClick(Sender: TObject);
begin
Query1.Clos ......
'Select * into '+TempTableName+' from OpenDataSource(''Microsoft.JET.OLEDB.4.0'',''Data Source='
+ExcelFilePath+';Mode=Read;Extended Properties=Excel 5.0;Persist Security Info=True'')...['
+SheetName+'$]';
Èç¹ûÎÒµ ......
ÔÎĵØÖ·£ºhttp://hi.baidu.com/sqldebug/blog/item/8e2749213082c0589922ed61.html
Ö±½ÓÌù¹ýÀ´µÄ£¬ÓеãÂÒ£¬´ó¼Ò´ÕºÏ¿´¡£
Ò»¡¢·þÎñ³ÌÐòºÍ×ÀÃæ³ÌÐòµÄÇø±ð
Windows 2000/XP/2003µÈÖ§³ÖÒ»ÖÖ½Ð×ö¡°ÏµÍ³·þÎñ³ÌÐò¡±µÄ½ø³Ì£¬ÏµÍ³·þÎñºÍ×ÀÃæ³ÌÐòµÄÇø±ðÊÇ£º
ϵͳ·þÎñ²»Óõǽϵͳ¼´¿ÉÔËÐУ»ÏµÍ³·þÎñÊÇÔËÐÐÔÚ ......
ÔÎĵØÖ·£ºhttp://hi.baidu.com/sqldebug/blog/item/58a764624a44d74eeaf8f863.html
Ò»¡¢ÈçºÎÏÞÖÆϵͳ·þÎñºÍ×ÀÃæ³ÌÐòÖ»ÔËÐÐÒ»¸ö
ÈçºÎÏÞÖÆϵͳ·þÎñºÍ×ÀÃæ³ÌÐòÖ»ÔËÐÐÒ»¸ö
ÔÚ¹¤³Ì¼ÓÈëÏÂÁдúÂë¿ÉÒÔÉèÖÃϵͳ·þÎñºÍ×ÀÃæ³ÌÐòÖ»ÔËÐÐÒ»¸ö¡£
program FleetReportSvr;
uses
SvcMgr,
Forms,
Sy ......
[size=18px]var s,n:integer;
begin
write('ÊäÈë±ä³¤µÄÌõÊýn');
readln(n);
[color=#FF0000]s:=n*(n-1)*(n-2)div 6; //±¾ÐÐÌ滻Ϊs:=n*(n-1)*(n-2)/ 6;Ôõô²»ÐУ¿£¿£¿[/color]
writeln('×é³ÉµÄÈý½ÇÐθöÊý',s);
readln;[/size]
div ÓÃÓÚÕûÊý
......