unit2.dfm

《C++Builder数据库程序设计》配书光盘 1.光盘内容 Readme.txt 光盘使用说明 书中各章范例文件

object Form1: TForm1
  Left = 192
  Top = 107
  Width = 430
  Height = 252
  Caption = 'excel2.bpr'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object DBGrid1: TDBGrid
    Left = 8
    Top = 8
    Width = 401
    Height = 105
    DataSource = DataSource1
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'MS Sans Serif'
    Font.Style = []
    ParentFont = False
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = '书名'
        Width = 113
        Visible = True
      end
      item
        Expanded = False
        FieldName = '第二季'
        Width = 43
        Visible = True
      end
      item
        Expanded = False
        FieldName = '第二季'
        Width = 47
        Visible = True
      end
      item
        Expanded = False
        FieldName = '第三季'
        Width = 46
        Visible = True
      end
      item
        Expanded = False
        FieldName = '第四季'
        Width = 46
        Visible = True
      end
      item
        Expanded = False
        FieldName = '合计'
        Width = 48
        Visible = True
      end>
  end
  object DBGrid2: TDBGrid
    Left = 8
    Top = 128
    Width = 409
    Height = 89
    DataSource = DataSource2
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'Delphi入门与实战'
        Width = 109
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'F2'
        Width = 49
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'F3'
        Width = 48
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'F4'
        Width = 42
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'F5'
        Width = 47
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'F6'
        Visible = True
      end>
  end
  object ADOConnection1: TADOConnection
    Connected = True
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data ' +
      'Source=BOOK1.xls;Mode=Share Deny None;Extended Properties=Excel ' +
      '8.0;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet ' +
      'OLEDB:Database Password="";Jet OLEDB:Engine Type=35;Jet OLEDB:Da' +
      'tabase Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OL' +
      'EDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="' +
      '";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Datab' +
      'ase=False;Jet OLEDB:Don'#39't Copy Locale on Compact=False;Jet OLEDB' +
      ':Compact Without Replica Repair=False;Jet OLEDB:SFP=False'
    LoginPrompt = False
    Mode = cmShareDenyNone
    Provider = 'Microsoft.Jet.OLEDB.4.0'
    Left = 16
    Top = 16
  end
  object ADOQuery1: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'Select  *  From [书籍销售$]')
    Left = 48
    Top = 16
  end
  object ADOQuery2: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'Select  *  From 书目')
    Left = 24
    Top = 88
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 88
    Top = 16
  end
  object DataSource2: TDataSource
    DataSet = ADOQuery2
    Left = 56
    Top = 88
  end
end