unit1.~dfm

使用ADO进行二进制字段读写的一个例子

object Form1: TForm1
  Left = 251
  Top = 121
  Width = 746
  Height = 480
  Caption = 'Blob Save'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 13
  object DBGrid1: TDBGrid
    Left = 0
    Top = 41
    Width = 738
    Height = 393
    Align = alClient
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    OnCellClick = DBGrid1CellClick
  end
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 738
    Height = 41
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Button1: TButton
      Left = 562
      Top = 9
      Width = 75
      Height = 23
      Caption = 'Save Blob'
      TabOrder = 0
      OnClick = Button1Click
    end
    object DBNavigator1: TDBNavigator
      Left = 282
      Top = 9
      Width = 280
      Height = 23
      DataSource = DataSource1
      TabOrder = 1
    end
    object Button2: TButton
      Left = 6
      Top = 9
      Width = 75
      Height = 23
      Caption = 'Connect'
      TabOrder = 2
      OnClick = Button2Click
    end
    object TableNameComboBox: TComboBox
      Left = 93
      Top = 9
      Width = 181
      Height = 21
      Style = csDropDownList
      ItemHeight = 13
      TabOrder = 3
      OnChange = TableNameComboBoxChange
    end
    object Button3: TButton
      Left = 637
      Top = 9
      Width = 75
      Height = 23
      Caption = 'Update'
      TabOrder = 4
      OnClick = Button3Click
    end
  end
  object StatusBar1: TStatusBar
    Left = 0
    Top = 434
    Width = 738
    Height = 19
    Panels = <>
  end
  object ADOConnection1: TADOConnection
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password="";Persist Security Info=True;User ' +
      'ID=sa;Initial Catalog=netrep;Data Source=10.0.1.144;Use Procedur' +
      'e for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation' +
      ' ID=SUN;Use Encryption for Data=False;Tag with column collation ' +
      'when possible=False'
    LoginPrompt = False
    Provider = 'SQLOLEDB.1'
    AfterConnect = ADOConnection1AfterConnect
    BeforeDisconnect = ADOConnection1BeforeDisconnect
    Left = 105
    Top = 114
  end
  object ADOTable1: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    TableName = 'prof_template'
    Left = 237
    Top = 129
  end
  object DataSource1: TDataSource
    DataSet = ADOTable1
    Left = 72
    Top = 24
  end
  object SaveDialog1: TSaveDialog
    Left = 150
    Top = 42
  end
  object OpenDialog: TOpenDialog
    Left = 363
    Top = 78
  end
end