adminysh

[数据库] Ehlib中DbGridEh控件的多行选择操作

在dbgrideh中允许选择多行,如何知道哪些行被选中?
是个BOOKMARK类型的属性。
SelectedRows: TBookmarkList
procedure TForm1.Button1Click(Sender: TObject);
var
 i, j: Integer;
 s: string;
begin
 if DBGrid1.SelectedRows.Count>0 then
   with DBGrid1.DataSource.DataSet do
     for i:=0 to DBGrid1.SelectedRows.Count-1 do
     begin
       GotoBookmark(pointer(DBGrid1.SelectedRows.Items[i]));
       for j := 0 to FieldCount-1 do
       begin
         if (j>0) then s:=s+‘, ‘;
         s:=s+Fields[j].AsString;
       end;
       Listbox1.Items.Add(s);
       s:= ‘‘;
     end;
end;  
 
dbgrideh 上选择多行之后,要求把所选择的记录全部添加入SQL数据库的一个固定表中。
dbgrideh.selectedrows记载了所有被选择行的bookmark;利用SelectedRows和GotoBookmark完成。代码如下:

procedure TForm1.Button1Click(Sender: TObject);
var
 i, j: Integer;
 s: string;
begin
 if DBGrid1.SelectedRows.Count>0 then
   with DBGrid1.DataSource.DataSet do
     for i:=0 to DBGrid1.SelectedRows.Count-1 do
     begin
       GotoBookmark(pointer(DBGrid1.SelectedRows.Items[i]));
       for j := 0 to FieldCount-1 do
       begin

         if (j>0) then s:=s+‘, ‘;
         s:=s+Fields[j].AsString;
       end;
       Listbox1.Items.Add(s);
       s:= ‘‘;
     end;
end;

#1楼
发帖时间:2014-1-14   |   查看数:0   |   回复数:1
adminysh
 //将选择的dbgrideh项目行,设置字段数值!

 if dbgrdh2.SelectedRows.Count>0 then
    with dbgrdh2.DataSource.DataSet do
      for i:=0 to dbgrdh2.SelectedRows.Count-1 do
        begin
          Application.ProcessMessages;
          GotoBookmark(Pointer(dbgrdh2.SelectedRows.Items[i]));
          Edit;
          FieldByName('家庭地址').AsString:='ddd';
          Post;
        end;
2014-1-14 #2楼
游客组