Hi,
I've made a grid using your tool and try to edit a line. Every thing it's working, except the part of sorting the column. Here are my select command and update command.
$ds->SelectCommand = "SELECT `id`, `station_name`, `phone_number`, `comments`, `coordinator`, `konfig_date`, `Status` from konfig ORDER BY `Status` DESC";
$ds->UpdateCommand = "update konfig set comments='@comments', coordinator='@coordinator', Status='@Status' where id='@id'";
here is the column code:
$column = new GridDropDownColumn();
$column->DataField = "Status";
$column->HeaderText = "Status";
$column->AddItem("Open");
$column->AddItem("Closed");
$gridKonfig->MasterTable->AddColumn($column);
I want when I change the status from "Open" to "close", that row to move bottom of the page. I want to see first only the status Open!