Показать сообщение отдельно
  #2  
Старый 05.04.2009, 19:10
Аватар для Страдалецъ
Страдалецъ Страдалецъ вне форума
Гуру
 
Регистрация: 09.03.2009
Адрес: На курорте, из окна вижу теплое Баренцево море. Бррр.
Сообщения: 4,723
Репутация: 52347
По умолчанию

Вот смотрите, маленький вариант:
В примере используется Таблица Sample (id:Autonumber,Context:Text;Picture:Text)
Код:
unit Unit11;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, DBCtrls, DB, ADODB, ExtDlgs, StdCtrls, JPEG, Mask;

type
  TForm11 = class(TForm)
    Image1: TImage;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    DBNavigator1: TDBNavigator;
    DBEdit1: TDBEdit;
    DBMemo1: TDBMemo;
    Button1: TButton;
    OpenPictureDialog1: TOpenPictureDialog;
    procedure ADOTable1AfterScroll(DataSet: TDataSet);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form11: TForm11;

implementation

{$R *.dfm}

procedure TForm11.ADOTable1AfterScroll(DataSet: TDataSet);
begin
 if not ADOTable1.FieldByName('Picture').IsNull
 then Image1.Picture.LoadFromFile(ADOTable1.FieldValues['Picture']);
end;

procedure TForm11.Button1Click(Sender: TObject);
begin
 OpenPictureDialog1.FileName := VarToStr(DBEdit1.Field.Value);
 if not OpenPictureDialog1.Execute then Exit;
 DBEdit1.Field.Value := OpenPictureDialog1.FileName;
end;

end.
Код:
object Form11: TForm11
  Left = 0
  Top = 0
  Caption = 'Form11'
  ClientHeight = 161
  ClientWidth = 370
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object Image1: TImage
    Left = 254
    Top = 8
    Width = 107
    Height = 113
    Center = True
    Proportional = True
    Stretch = True
  end
  object DBNavigator1: TDBNavigator
    Left = 8
    Top = 127
    Width = 240
    Height = 25
    DataSource = DataSource1
    TabOrder = 0
  end
  object DBEdit1: TDBEdit
    Left = 8
    Top = 8
    Width = 212
    Height = 21
    DataField = 'Picture'
    DataSource = DataSource1
    TabOrder = 1
  end
  object DBMemo1: TDBMemo
    Left = 8
    Top = 32
    Width = 240
    Height = 89
    DataField = 'Context'
    DataSource = DataSource1
    TabOrder = 2
  end
  object Button1: TButton
    Left = 223
    Top = 8
    Width = 25
    Height = 21
    Caption = '...'
    TabOrder = 3
    OnClick = Button1Click
  end
  object ADOConnection1: TADOConnection
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\'#1061#1086#1079#1103#1080#1085'\Doc' +
      'uments\Demo.mdb;Persist Security Info=False;'
    LoginPrompt = False
    Mode = cmShareDenyNone
    Provider = 'Microsoft.Jet.OLEDB.4.0'
    Left = 96
    Top = 56
  end
  object ADOTable1: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    AfterScroll = ADOTable1AfterScroll
    TableName = 'Sample'
    Left = 128
    Top = 56
  end
  object DataSource1: TDataSource
    DataSet = ADOTable1
    Left = 160
    Top = 56
  end
  object OpenPictureDialog1: TOpenPictureDialog
    Left = 192
    Top = 56
  end
end
__________________
Жизнь такова какова она есть и больше никакова.
Помогаю за спасибо.
Ответить с цитированием