DataGridView/BindingSource Count Limit

[SgtJarrow]

I have a DataGridView bound directly to a SQL table via a BindingSource object. The BindingSource is sorted DESC for a couple fields.

Without creating a view or anything, is there a way to display only top X items?

This is a version history page of a project. I did not want to create a view or SQL to pull the data, but the table now has about 200 records in it and I want to display the last 20 or so...

If not, I'll make a view to pull the top 20.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[nickdel]

Robert, I dont think this is possible with a bound dgv. Even if it were, it would be more efficient to do a "select top 20" query and then bind to datagrid.

Cheers

Nick