我想从一个窗口的 stringgrid中的用双击事件将选中的值赋给另一个窗体的edit控件,不知道这样子可以吗?
我已经试过,可以将在同一个窗体中赋值的,就是不能在两个窗体中赋值
我的程序代码如下:
procedure TfrmSearch.ssgsearchDblClick(Sender: TObject);
var
iRow: integer;
MyQuery :TADOQuery;
SqlCode,str : string;
begin
irow:=ssgsearch.Selection.Bottom;
str:=ssgsearch.Cells[3,iRow];
if frmedit_contract = nil then
frmedit_contract := Tfrmedit_contract.create(application);
try
MyQuery:= TADOQuery.Create(nil);
with MyQuery do
try
Connection := Adocon;
if Active then Close;
SQL.Clear;
SQLCode := ' set rowcount 0 select a.department_name,b.staff_name,b.contact_phone,b.mobile_phone,'
+ ' b.email,b.staff_kind,c.duty,d.position_name from run..department a,run..staff_base_infor b,run..staff_dy c,run..position d'
+ ' where b.staff_id='+''''+ str+''''
+ ' and b.staff_id=c.staff_id'
+ ' and c.department=a.department'
+ ' and c.post_id=d.position';
SQL.Add(SQLCode);
Open;
if MyQuery.RecordCount = 1 then
begin
frmedit_contract.sEdtname.Text:=FieldByName('staff_name').AsString;
frmedit_contract.sedtstatus.Text:=FieldByName('duty').AsString;
frmedit_contract.sedt1.Text:=FieldByName('staff_kind').AsString;
frmedit_contract.sedtphone.Text:=FieldByName('contact_phone').AsString;
frmedit_contract.sedtdepart.Text:=FieldByName('department_name').AsString;
frmedit_contract.sedtmoble.Text:=FieldByName('mobile_phone').AsString;
frmedit_contract.sedtposition.Text:=FieldByName('position_name').AsString;
frmedit_contract.sedtmail.Text:=FieldByName('email').AsString;
end;
except
MyQuery.Free;
end;
finally
MyQuery.Free;
close;
end;
end;
不知道为什么不能将数据库中查出的值过来!郁闷啊!
我已经试过,可以将在同一个窗体中赋值的,就是不能在两个窗体中赋值
我的程序代码如下:
procedure TfrmSearch.ssgsearchDblClick(Sender: TObject);
var
iRow: integer;
MyQuery :TADOQuery;
SqlCode,str : string;
begin
irow:=ssgsearch.Selection.Bottom;
str:=ssgsearch.Cells[3,iRow];
if frmedit_contract = nil then
frmedit_contract := Tfrmedit_contract.create(application);
try
MyQuery:= TADOQuery.Create(nil);
with MyQuery do
try
Connection := Adocon;
if Active then Close;
SQL.Clear;
SQLCode := ' set rowcount 0 select a.department_name,b.staff_name,b.contact_phone,b.mobile_phone,'
+ ' b.email,b.staff_kind,c.duty,d.position_name from run..department a,run..staff_base_infor b,run..staff_dy c,run..position d'
+ ' where b.staff_id='+''''+ str+''''
+ ' and b.staff_id=c.staff_id'
+ ' and c.department=a.department'
+ ' and c.post_id=d.position';
SQL.Add(SQLCode);
Open;
if MyQuery.RecordCount = 1 then
begin
frmedit_contract.sEdtname.Text:=FieldByName('staff_name').AsString;
frmedit_contract.sedtstatus.Text:=FieldByName('duty').AsString;
frmedit_contract.sedt1.Text:=FieldByName('staff_kind').AsString;
frmedit_contract.sedtphone.Text:=FieldByName('contact_phone').AsString;
frmedit_contract.sedtdepart.Text:=FieldByName('department_name').AsString;
frmedit_contract.sedtmoble.Text:=FieldByName('mobile_phone').AsString;
frmedit_contract.sedtposition.Text:=FieldByName('position_name').AsString;
frmedit_contract.sedtmail.Text:=FieldByName('email').AsString;
end;
except
MyQuery.Free;
end;
finally
MyQuery.Free;
close;
end;
end;
不知道为什么不能将数据库中查出的值过来!郁闷啊!
解决方案 »
- idftp上传文件出现connection closed gracefully
- delphi是否有内部类?
- 如何断开与SQL SERVER2000数据库的连接,试了N种都断不开~~~
- 请教:怎么用TIdFTP组件,实现断点续传功能?
- 求教:怎样在edit框内获得选择的路径?
- 急需ASCII码表
- 请问哪有delphi开发组件的电子书?或是书店有这样的书?
- 请问我怎么在运行是要求输入密码和用户名(delphi+access2000)在线等待
- 登录问题:使用ORACLE的系统,登录窗体输入的用户/密码应该是ORACLE中的用户/密码吧?
- 请推荐用于数据挖掘的控件,谢谢!
- 串口操作读不出数据(新手上路,多多指教)
- 简单问题:带密码Access数据库打不开?
然后赋值给另外的那个窗体.editXX.text