unit1.dfm

一个模糊查询文件

object Form1: TForm1
  Left = 192
  Top = 113
  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
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 104
    Top = 8
    Width = 352
    Height = 29
    Caption = 'SoundMAX  Co., Ltd  Part No List'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clRed
    Font.Height = -24
    Font.Name = 'MS Sans Serif'
    Font.Style = []
    ParentFont = False
  end
  object Label2: TLabel
    Left = 16
    Top = 40
    Width = 133
    Height = 20
    Caption = 'Please Input  SQL '
    Color = clWhite
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clLime
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = []
    ParentColor = False
    ParentFont = False
  end
  object DBGrid1: TDBGrid
    Left = 16
    Top = 128
    Width = 577
    Height = 297
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object EXCEL: TButton
    Left = 600
    Top = 224
    Width = 75
    Height = 25
    Caption = 'EXCEL'
    TabOrder = 1
    OnClick = EXCELClick
  end
  object BitBtn1: TBitBtn
    Left = 600
    Top = 328
    Width = 75
    Height = 25
    TabOrder = 2
    Kind = bkClose
  end
  object Button1: TButton
    Left = 600
    Top = 152
    Width = 75
    Height = 25
    Caption = 'Query'
    TabOrder = 3
    OnClick = Button1Click
  end
  object Memo1: TMemo
    Left = 16
    Top = 64
    Width = 657
    Height = 57
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = []
    Lines.Strings = (
      
        'select prd_no,name,spc from prdt where (name like '#39'%'#30005#38459'%'#39') order ' +
        'by prd_no')
    ParentFont = False
    ScrollBars = ssBoth
    TabOrder = 4
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    Left = 176
    Top = 8
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 240
    Top = 8
  end
  object ExcelApplication1: TExcelApplication
    AutoConnect = False
    ConnectKind = ckRunningOrNew
    AutoQuit = False
    Left = 328
    Top = 8
  end
  object ADOConnection1: TADOConnection
    ConnectionString = 
      'Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initi' +
      'al Catalog=DB_S;Data Source=soundmax-server'
    Provider = 'SQLOLEDB.1'
    Left = 80
    Top = 8
  end
end