
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
__________________
Жизнь такова какова она есть и больше никакова.
Помогаю за спасибо.
|