unit1.~pas

sql的操作程序,为dephi编程人员提供参考

unit Unit1;

interface

uses
  Windows, Messages, Classes, SysUtils, Graphics, Controls, StdCtrls, Forms,
  Dialogs, DBCtrls, DB, DBGrids, DBTables, Grids, ExtCtrls;

type
  TForm1 = class(TForm)
    Table1NAME: TStringField;
    Table1SIZE: TSmallintField;
    Table1WEIGHT: TSmallintField;
    Table1AREA: TStringField;
    Table1BMP: TBlobField;
    DBGrid1: TDBGrid;
    DBNavigator: TDBNavigator;
    Panel1: TPanel;
    DataSource1: TDataSource;
    Panel2: TPanel;
    Table1: TTable;
    DBComboBox1: TDBComboBox;
    procedure FormCreate(Sender: TObject);
    procedure DBGrid1DrawDataCell(Sender: TObject; const Rect: TRect;
      Field: TField; State: TGridDrawState);
    procedure DBGrid1ColExit(Sender: TObject);
    procedure DBGrid1KeyPress(Sender: TObject; var Key: Char);
  private
    { private declarations }
  public
    { public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

procedure TForm1.FormCreate(Sender: TObject);
begin
  Table1.Open;
end;

procedure TForm1.DBGrid1DrawDataCell(Sender: TObject; const Rect: TRect;
  Field: TField; State: TGridDrawState);
begin
  if (gdFocused in State) then
    if (Field.FieldName = DBComboBox1.DataField ) then
    begin
      DBComboBox1.Left := Rect.Left + DBGrid1.Left;
      DBComboBox1.Top := Rect.Top + DBGrid1.top;
      DBComboBox1.Width := Rect.Right - Rect.Left;
      DBComboBox1.Height := Rect.Bottom - Rect.Top;
      DBComboBox1.Visible := True;
    end;
end;

procedure TForm1.DBGrid1ColExit(Sender: TObject);
begin

  If DBGrid1.SelectedField.FieldName 
  = DBComboBox1.DataField then
  begin
      DBComboBox1.Visible := false;
  end;

end;

procedure TForm1.DBGrid1KeyPress(Sender: TObject; var Key: Char);
begin

  if (key <> chr(9)) then
    begin
      if (DBGrid1.SelectedField.FieldName
     =DBComboBox1.DataField) then
      begin
             DBComboBox1.SetFocus;
          SendMessage(DBComboBox1.Handle, 
        WM_Char, word(Key), 0);
      end;
    end;

end;

end.