修改数据时选中DBGrid中的一行,按下修改控件,在弹出的修改窗体中显示要修改的信息,不能显示所选的,显示的是其他信息. unit Unit4;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, Grids, DBGrids,unit11, ComCtrls,unit12, DB, ADODB,unit14;type
TForm4 = class(TForm)
GroupBox1: TGroupBox;
Label2: TLabel;
Label5: TLabel;
Label6: TLabel;
Label8: TLabel;
Label17: TLabel;
Edit1: TEdit;
Edit2: TEdit;
Edit7: TEdit;
Label3: TLabel;
Edit4: TEdit;
Label1: TLabel;
Edit6: TEdit;
Label7: TLabel;
Edit5: TEdit;
DBGrid1: TDBGrid;
Button1: TButton;
Button2: TButton;
Button3: TButton;
Button4: TButton;
DateTimePicker1: TDateTimePicker;
Edit8: TEdit;
DataSource1: TDataSource;
ADOQuery1: TADOQuery;
ADOCommand1: TADOCommand;
Button5: TButton;
procedure Button4Click(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure Button3Click(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure FormActivate(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure Button5Click(Sender: TObject);
procedure DBGrid1CellClick(Column: TColumn);
private
{ Private declarations }
procedure VisibleChanging; override;//
public
{ Public declarations }
end;var
Form4: TForm4;
tName:TEdit;implementation
procedure TForm4.VisibleChanging;
begin
end;
{$R *.dfm}
procedure TForm4.Button4Click(Sender: TObject);
begin
form11.setEdit(edit1,edit2,edit4,edit5,edit6,edit7,edit8,datetimepicker1);
form11.WindowState:=wsNormal;
form11.Visible:=true;
end;procedure TForm4.FormClose(Sender: TObject; var Action: TCloseAction);
begin
visible:=false;
end;procedure TForm4.Button3Click(Sender: TObject);
begin
visible:=false;
end;procedure TForm4.Button1Click(Sender: TObject);
begin
if edit8.Text<>'init' then
begin
form12.setID(edit8.Text);
form12.Visible:=true;
end;
end;procedure TForm4.FormActivate(Sender: TObject);
begin
if edit8.Text<>'init' then
begin
adoquery1.Active:=false;
adoquery1.Close;
adoquery1.SQL.Text:='select ID,开始日期,结束日期,说明 from study_info where pid='+edit8.Text;
adoquery1.Open;
adoquery1.active:=true;
end;
end;procedure TForm4.Button2Click(Sender: TObject);
begin
if not adoquery1.Eof then
begin
adocommand1.CommandText:='delete from study_info where ID='+adoquery1.FieldByName('ID').AsString;
adocommand1.Execute;
//adoquery1.SQL.Clear;
//adoquery1.SQL.Add('delete from study_info where ID='+adoquery1.FieldByName('ID').AsString);
//adoquery1.ExecSQL;
adoquery1.active:=false;
adoquery1.Close;
adoquery1.Open;
adoquery1.active:=true;
end;
end;procedure TForm4.Button5Click(Sender: TObject);
begin
{if not adoquery1.Eof then
begin
if edit8.Text<>'init' then
begin
form14.setID(adoquery1.FieldByName('ID').Value);
form14.Visible:=true;
end;
end; }
form14.ADOTable1.Active:=false ;
form14.ADOTable1.Active:=true;
form14.Visible:=true;
end;
procedure TForm4.DBGrid1CellClick(Column: TColumn);
begin
// if not adoquery1.Eof then
//begin
if edit8.Text<>'init' then
begin
form14.setID(adoquery1.FieldByName('ID').Value); end;
//end;
end;end.----------------
上传不了附件,好心的朋友加下我QQ帮帮我吧.号码是:494733528
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, Grids, DBGrids,unit11, ComCtrls,unit12, DB, ADODB,unit14;type
TForm4 = class(TForm)
GroupBox1: TGroupBox;
Label2: TLabel;
Label5: TLabel;
Label6: TLabel;
Label8: TLabel;
Label17: TLabel;
Edit1: TEdit;
Edit2: TEdit;
Edit7: TEdit;
Label3: TLabel;
Edit4: TEdit;
Label1: TLabel;
Edit6: TEdit;
Label7: TLabel;
Edit5: TEdit;
DBGrid1: TDBGrid;
Button1: TButton;
Button2: TButton;
Button3: TButton;
Button4: TButton;
DateTimePicker1: TDateTimePicker;
Edit8: TEdit;
DataSource1: TDataSource;
ADOQuery1: TADOQuery;
ADOCommand1: TADOCommand;
Button5: TButton;
procedure Button4Click(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure Button3Click(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure FormActivate(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure Button5Click(Sender: TObject);
procedure DBGrid1CellClick(Column: TColumn);
private
{ Private declarations }
procedure VisibleChanging; override;//
public
{ Public declarations }
end;var
Form4: TForm4;
tName:TEdit;implementation
procedure TForm4.VisibleChanging;
begin
end;
{$R *.dfm}
procedure TForm4.Button4Click(Sender: TObject);
begin
form11.setEdit(edit1,edit2,edit4,edit5,edit6,edit7,edit8,datetimepicker1);
form11.WindowState:=wsNormal;
form11.Visible:=true;
end;procedure TForm4.FormClose(Sender: TObject; var Action: TCloseAction);
begin
visible:=false;
end;procedure TForm4.Button3Click(Sender: TObject);
begin
visible:=false;
end;procedure TForm4.Button1Click(Sender: TObject);
begin
if edit8.Text<>'init' then
begin
form12.setID(edit8.Text);
form12.Visible:=true;
end;
end;procedure TForm4.FormActivate(Sender: TObject);
begin
if edit8.Text<>'init' then
begin
adoquery1.Active:=false;
adoquery1.Close;
adoquery1.SQL.Text:='select ID,开始日期,结束日期,说明 from study_info where pid='+edit8.Text;
adoquery1.Open;
adoquery1.active:=true;
end;
end;procedure TForm4.Button2Click(Sender: TObject);
begin
if not adoquery1.Eof then
begin
adocommand1.CommandText:='delete from study_info where ID='+adoquery1.FieldByName('ID').AsString;
adocommand1.Execute;
//adoquery1.SQL.Clear;
//adoquery1.SQL.Add('delete from study_info where ID='+adoquery1.FieldByName('ID').AsString);
//adoquery1.ExecSQL;
adoquery1.active:=false;
adoquery1.Close;
adoquery1.Open;
adoquery1.active:=true;
end;
end;procedure TForm4.Button5Click(Sender: TObject);
begin
{if not adoquery1.Eof then
begin
if edit8.Text<>'init' then
begin
form14.setID(adoquery1.FieldByName('ID').Value);
form14.Visible:=true;
end;
end; }
form14.ADOTable1.Active:=false ;
form14.ADOTable1.Active:=true;
form14.Visible:=true;
end;
procedure TForm4.DBGrid1CellClick(Column: TColumn);
begin
// if not adoquery1.Eof then
//begin
if edit8.Text<>'init' then
begin
form14.setID(adoquery1.FieldByName('ID').Value); end;
//end;
end;end.----------------
上传不了附件,好心的朋友加下我QQ帮帮我吧.号码是:494733528
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货