貼一段,看看吧, procedure TForm1.BitBtn1Click(Sender: TObject); var i:integer; begin IF Application.MessageBox('你确實要作批量刪除嗎?','提示',mb_YESNO or MB_ICONQUESTION or MB_DEFBUTTON2)=IDNO then Abort; For i:=0 to DBGrid.SelectedRows.Count-1 Do ADOQuery.Delete; If ADOQuery.State in dsEditModes then ADOQuery.Post; end;
使用书签列表(TBookMarkList)] 代码如下: procedure TForm1.Button1Click(Sender: TObject); var i: Integer; begin if DBGrid1.SelectedRows.Count>0 then with DBGrid1.DataSource.DataSet do for i:=0 to DBGrid1.SelectedRows.Count-1 do begin GotoBook(pointer(DBGrid1.SelectedRows.Items[i])); delete; end; end;
但我打算写个SQL代码实现
很简单的
做变量就可以了
通过使用SelectedRows[i]属性来获得选中行中的某一行。
procedure TForm1.BitBtn1Click(Sender: TObject);
var
i:integer;
begin
IF Application.MessageBox('你确實要作批量刪除嗎?','提示',mb_YESNO or MB_ICONQUESTION or MB_DEFBUTTON2)=IDNO then
Abort;
For i:=0 to DBGrid.SelectedRows.Count-1 Do
ADOQuery.Delete;
If ADOQuery.State in dsEditModes then
ADOQuery.Post;
end;
代码如下:
procedure TForm1.Button1Click(Sender: TObject);
var
i: Integer;
begin
if DBGrid1.SelectedRows.Count>0 then
with DBGrid1.DataSource.DataSet do
for i:=0 to DBGrid1.SelectedRows.Count-1 do
begin
GotoBook(pointer(DBGrid1.SelectedRows.Items[i]));
delete;
end;
end;