Title: Sort DBGrid columns in 2 lines of code
Question: Have you seen long examples of sorting DBGrids Online. Well here is an example in 2 lines of code. This will sort any column you want by double clicking on any cell in the column.
Answer:
procedure TForm1.DBGrid1DblClick(Sender: TObject);
var
str1: String;
begin
str1 := DBGrid1.SelectedField.FieldName;
myadoqry.Sort := str1+' ASC';
end;
You should allow the user to select a cell in a column. You can use the DBGrid's readonly property to disallow the user the ability to delete a row. just set
DBGrid1.readonly := True;
You can also do this from the Designer