DataGridview - Show only the latest 20record

[RafaulWolf]

HI,

How can limit my data grid view to display only the latest 20 record from an access database?

[dip_developer]

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...kee p the time when the record is Inserted in a table field......then you can track the latest 20 records checking the insertion time...

[klaydze]

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

[RafaulWolf]

What do you mean by Latest??? Last saved 20 records??? Then in time of Insertion of your record You have to maintain a Timestamp...kee p 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 :)

[prabunewindia]

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 :)