unit1.dfm

delphi中通过dbgrid来实现两个数据库之间的调用功能

object Form1: TForm1
  Left = 274
  Top = 145
  Width = 696
  Height = 480
  Caption = 'Form1'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object DBNavigator1: TDBNavigator
    Left = 376
    Top = 48
    Width = 240
    Height = 25
    DataSource = DataSource1
    TabOrder = 0
  end
  object DBGridEh1: TDBGridEh
    Left = 80
    Top = 160
    Width = 320
    Height = 120
    DataSource = DataSource1
    Flat = False
    FooterColor = clWindow
    FooterFont.Charset = DEFAULT_CHARSET
    FooterFont.Color = clWindowText
    FooterFont.Height = -11
    FooterFont.Name = 'MS Sans Serif'
    FooterFont.Style = []
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        EditButtons = <>
        FieldName = 'ZGBH'
        Footers = <>
        Title.Caption = #32844#24037#32534#21495
        Width = 50
      end
      item
        EditButtons = <>
        FieldName = 'ZGXM'
        Footers = <>
        Title.Caption = #32844#24037#22995#21517
        Width = 50
      end
      item
        EditButtons = <>
        FieldName = 'DWBH'
        Footers = <>
        Title.Caption = #21333#20301#32534#21495
        Width = 50
      end
      item
        EditButtons = <>
        FieldName = 'DWMC'
        Footers = <>
        Width = 50
      end>
  end
  object DataSource1: TDataSource
    DataSet = ADOTable1
    Left = 272
    Top = 40
  end
  object ADOConnection1: TADOConnection
    Connected = True
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=shiya' +
      'n.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:Syst' +
      'em database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Pas' +
      'sword="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode' +
      '=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Tra' +
      'nsactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create ' +
      'System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB' +
      ':Don'#39't Copy Locale on Compact=False;Jet OLEDB:Compact Without Re' +
      'plica Repair=False;Jet OLEDB:SFP=False'
    LoginPrompt = False
    Mode = cmShareDenyNone
    Provider = 'Microsoft.Jet.OLEDB.4.0'
    Left = 32
    Top = 32
  end
  object ADOTable1: TADOTable
    Connection = ADOConnection1
    TableName = 'zgk'
    Left = 96
    Top = 32
    object ADOTable1ZGBH: TWideStringField
      FieldName = 'ZGBH'
      Size = 50
    end
    object ADOTable1ZGXM: TWideStringField
      FieldName = 'ZGXM'
      KeyFields = 'ZGXM'
      Size = 50
    end
    object ADOTable1DWBH: TWideStringField
      FieldName = 'DWBH'
      Size = 50
    end
    object ADOTable1DWMC: TStringField
      FieldKind = fkLookup
      FieldName = 'DWMC'
      LookupDataSet = ADOTable2
      LookupKeyFields = 'DWBH'
      LookupResultField = 'DWMC'
      KeyFields = 'DWBH'
      Size = 50
      Lookup = True
    end
  end
  object ADOTable2: TADOTable
    Connection = ADOConnection1
    TableName = 'dwk'
    Left = 160
    Top = 32
  end
end