I am using a datagrid with unbound columns and a Select Column. The SelectedIndexChanged event captures the values of the cells in the selected row using this statement:<BR><BR>DataGrid1.SelectedItem.Cells(1). Text<BR><BR>And the following SQL statement in the DataGrid1_SortCommand:<BR><BR>strSql = "select * from dvSTD1 order by " & e.SortExpression.ToString()<BR><BR>It works fine before sorting any column. The problem starts when I sort a column and then select a row, it gives me the data of another row! Not the row I have selected. It seems that the Select Command of a row does not detect the new order of the datagrid and always reverts back to the original order!<BR><BR>Your help to solve this problem is highly appreciated.<BR>