unitsinglegoods.dfm

一个操作sql server的实例

object FormSingleGoods: TFormSingleGoods
  Left = 237
  Top = 119
  Width = 349
  Height = 296
  Caption = '商品信息'
  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 Label1: TLabel
    Left = 40
    Top = 24
    Width = 23
    Height = 13
    Caption = 'ID：'
  end
  object Label2: TLabel
    Left = 40
    Top = 88
    Width = 40
    Height = 13
    Caption = 'Name：'
  end
  object Label3: TLabel
    Left = 192
    Top = 88
    Width = 47
    Height = 13
    Caption = 'EName：'
  end
  object Label4: TLabel
    Left = 40
    Top = 160
    Width = 31
    Height = 13
    Caption = 'Unit：'
  end
  object Label5: TLabel
    Left = 192
    Top = 160
    Width = 36
    Height = 13
    Caption = 'Price：'
  end
  object DBEdit1: TDBEdit
    Left = 40
    Top = 56
    Width = 121
    Height = 21
    Color = clBtnFace
    DataField = 'iNo'
    DataSource = DataSource1
    ReadOnly = True
    TabOrder = 0
  end
  object DBEdit2: TDBEdit
    Left = 40
    Top = 120
    Width = 121
    Height = 21
    DataField = 'sName'
    DataSource = DataSource1
    TabOrder = 1
  end
  object DBEdit3: TDBEdit
    Left = 192
    Top = 120
    Width = 121
    Height = 21
    DataField = 'sEName'
    DataSource = DataSource1
    TabOrder = 2
  end
  object BitBtn1: TBitBtn
    Left = 56
    Top = 224
    Width = 75
    Height = 25
    TabOrder = 3
    OnClick = BitBtn1Click
    Kind = bkOK
  end
  object BitBtn2: TBitBtn
    Left = 208
    Top = 224
    Width = 75
    Height = 25
    TabOrder = 4
    Kind = bkCancel
  end
  object DBEdit4: TDBEdit
    Left = 40
    Top = 192
    Width = 121
    Height = 21
    DataField = 'iUnit'
    DataSource = DataSource1
    TabOrder = 5
  end
  object DBEdit5: TDBEdit
    Left = 192
    Top = 192
    Width = 121
    Height = 21
    DataField = 'fPrice'
    DataSource = DataSource1
    TabOrder = 6
  end
  object Query1: TQuery
    OnNewRecord = Query1NewRecord
    DatabaseName = 'TestDatabase'
    RequestLive = True
    SQL.Strings = (
      'Select * from Goods Where 0=1')
    Left = 216
    Top = 16
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 296
    Top = 16
  end
end