1 / 22

資料庫操作

資料庫操作. BCB & Database. Local Database Paradox, dBase, FoxPro, Aaccess Remote Database SQL Server , Oracle, Sybase …. 存取模式. BDE BDE 頁籤 存取 Paradox ， dBase ， FoxPro 資料庫 ADO 微軟資料存取標準， ADO 頁籤  存取 SQL Server, Aaccess dbExpress InterBase 存取 InterBase 資料庫. BDE. ADO. dbExpress.

lexiss
Download Presentation

資料庫操作

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 資料庫操作

  2. BCB & Database • Local Database Paradox, dBase, FoxPro, Aaccess • Remote Database SQL Server, Oracle, Sybase …

  3. 存取模式 • BDE BDE頁籤存取Paradox，dBase，FoxPro資料庫 • ADO 微軟資料存取標準，ADO頁籤 存取SQL Server, Aaccess • dbExpress • InterBase 存取InterBase資料庫

  4. BDE ADO dbExpress InterBase Data Aaccess 元件 Data Controls 元件 存取模式

  5. BDE (Borland Database Engine) • BDE設定 BDE Administrator Access97, Paradox, dBase, FoxPro, InterBase, SQL Server • TTable元件 • TDatabase元件 • TBDEClientDataset元件

  6. BDE設定 設定資料庫別名 設定驅動程式

  7. Database Desktop－Paradox File  NewTable

  8. Database Desktop－Paradox 輸入欄位資料

  9. Database Desktop－Paradox 儲存資料表

  10. Database Desktop－Paradox 編輯資料 維護資料表結構 Tools->Utilities -> Restructure 記得 BCB與 BDE Administrator要關閉

  11. 設定Alias BDE<－>Paradox Paradox BDE

  12. BDE設定Alias Database  New

  13. BDE設定Alias 設定Alias與資料庫所在

  14. Form Wizard DataBase  FormWizard

  15. Form Wizard 選擇Alias

  16. Form Wizard

  17. Form Wizard

  18. BDE ADO dbExpress InterBase Data Aaccess 元件 Data Controls 元件 存取模式 資料庫 使用者介面

  19. BDE(Table) ADO dbExpress InterBase Data Aaccess 元件 (DataSource) Data Controls 元件(DbGrid) 存取模式 資料庫 使用者介面

  20. BDE+Data Access+Data Control • BDE－Table DatabaseName TableName Active=True • DataSource DataSet=Table1 • DBGrid DataSource 方便，但是彈性不大 改用個別欄位顯示 (加入圖形)

  21. BDE+Data Access+Data Control • 欄位編輯器

  22. BDE+Data Access+Data Control • 欄位編輯器 Table 1 AutoCalcFields=true void __fastcall TForm1::Table1CalcFields(TDataSet *DataSet) { Table1avg->Value=…….; }

More Related