I'm working on a web form with a DataGrid control on it. I want to show only the last three lines of a table. I don't see any properties of the grid for this purpose, but I think I could do it by adding to the WHERE statement in the data connection configuration. Trouble is, I can't find out how to find the last record, or some other SQL statement that will do the job.
Thanks for any ideas...