www.pudn.com > Excel.zip > MainF.pas

unit MainF; 
 
interface 
 
uses 
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, 
  Dialogs, DBCtrls, Grids, DBGrids, ExtCtrls, ComCtrls, StdCtrls, ADODB; 
 
type 
  TMainForm = class(TForm) 
    PageControl1: TPageControl; 
    ViewSheet: TTabSheet; 
    SQLSheet: TTabSheet; 
    Panel1: TPanel; 
    DBNavigator1: TDBNavigator; 
    ExcelGrid: TDBGrid; 
    InsertBtn: TButton; 
    UpdateBtn: TButton; 
    RefreshBtn: TButton; 
    LoadBtn: TButton; 
    CreateBtn: TButton; 
    StatusBar: TStatusBar; 
    procedure InsertBtnClick(Sender: TObject); 
    procedure UpdateBtnClick(Sender: TObject); 
    procedure RefreshBtnClick(Sender: TObject); 
    procedure LoadBtnClick(Sender: TObject); 
    procedure CreateBtnClick(Sender: TObject); 
  private 
    { Private declarations } 
  public 
    { Public declarations } 
  end; 
 
var 
  MainForm: TMainForm; 
 
implementation 
 
uses MainD; 
 
{$R *.dfm} 
 
procedure TMainForm.InsertBtnClick(Sender: TObject); 
begin 
  with MainDm.ExcelCmd do 
  begin 
    CommandText := 'INSERT INTO [ITEMS$] (OrderNo, ItemNo, PartNo, Qty, Discount) ' + 
                   'VALUES (9999, 8888, 7777, 6666, 0)'; 
    Execute; 
  end; //with 
end; 
 
procedure TMainForm.UpdateBtnClick(Sender: TObject); 
begin 
  with MainDm.ExcelCmd do 
  begin 
    CommandText := 'UPDATE [ITEMS$] ' + 
                   'SET [Discount] = 10 WHERE [OrderNo] = ' + 
                   QuotedStr('9999'); 
    Execute; 
  end; //with 
end; 
 
procedure TMainForm.RefreshBtnClick(Sender: TObject); 
begin 
  MainDm.RefreshExcelData; 
end; 
 
procedure TMainForm.LoadBtnClick(Sender: TObject); 
begin 
  MainDm.LoadData; 
end; 
 
procedure TMainForm.CreateBtnClick(Sender: TObject); 
begin 
  MainDm.CreateExcelFile; 
  MainDm.OpenExcelFile; 
end; 
 
end.