By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 860 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

DataGridview - Show only the latest 20record

P: 10
HI,

How can limit my data grid view to display only the latest 20 record from an access database?
Apr 27 '07 #1
Share this Question
Share on Google+
4 Replies


dip_developer
Expert 100+
P: 648
HI,

How can limit my data grid view to display only the latest 20 record from an access database?
What do you mean by Latest??? Last saved 20 records??? Then in time of Insertion of your record You have to maintain a Timestamp...keep the time when the record is Inserted in a table field......then you can track the latest 20 records checking the insertion time...
Apr 27 '07 #2

P: 30
HI,

How can limit my data grid view to display only the latest 20 record from an access database?
my idea with your question is, you can base it to the time when you save your record. you have a column for the time then make a line of query to validate all your records. thats my idea. hehe
Apr 27 '07 #3

P: 10
What do you mean by Latest??? Last saved 20 records??? Then in time of Insertion of your record You have to maintain a Timestamp...keep the time when the record is Inserted in a table field......then you can track the latest 20 records checking the insertion time...

do you hav a sample of the example? or links to tutorials on such topics?
THx :)
May 3 '07 #4

prabunewindia
100+
P: 199
just take only the top 20 rows from table based on date
and display
do you hav a sample of the example? or links to tutorials on such topics?
THx :)
May 3 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.