A question about dbgrid

lightchen

When the program is running, I want to delete a record of dbgrid,
How to get the record that I selected with the mouse in dbgrid ?????????????

What if you want to delete multiple records? That is to say like this: I hold down a key such as the control key, and then use the mouse to select the record to delete. How do I implement it? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

I hope you can enlighten me! !!
For details, younger beginner, thank you! !! !! !!

hanhanyi

Using ActionList, write in OnExecute

tonnywoo

Select dgMultiSelect in the Options property of DBGrid
Shift, Ctrl to select multiple records
Get selected records from SelectedRows

Write in CellClick event:
Clear all selected records with DBGrid1.SelectedRows.Clear statement; delete all selected records with DBGrid1.SelectedRows.Delete statement.

chenruhai

Upstairs solution

lightchen

Select dgMultiSelect in the Options property of DBGrid
Hold down Shift, Ctrl to select multiple records
Get selected records from SelectedRows

Write in the CellClick event:
DBGrid1.SelectedRows.Clear statement can be used to clear all selected records; DBGrid1.SelectedRows.Delete statement can be used to delete all selected records


As such, is it necessary to set an attribute of that dbgrid to be editable, and then the records deleted in dbgrid are directly reflected on the database ???? There is no need to write the deleted SQL statement ????????

tonnywoo

Yes, but this method is not good, I generally do not need data binding, DBGRID is only used for display.

lightchen

I use dbgrid to display all records in a table, then I want to add a row at the end of dbgrid, and count the sum of a certain field in this table (for example, there is a number of fields in this table, then I want to add Add the number field in all records to get the total number) to form a record with "total" written in front, and then display the total number under the number of dbgrid column. How to??


Another problem is that when you use dbgrid to display records, it seems that you can directly set in the properties of dbgrid to display odd-numbered records in a certain color, and even-numbered records in a certain color. How to set it??? ????

tonnywoo

Very simple, use the DBGRIDEH in the three-party control EHILB.
What you said above can be achieved.