Printable View
I am a newbee in vb.net 2008 i am making a simple inventory system.
now my problem is i want to get the filter earliest date in my data table and put it to a textbox..
ex.
Product Name Expiration Date
Paracetamol 06/01/2011
amoxicillin 08/12/2011
Mefinamic 12/1/2011
I want to filter the earliest date "06/01/2011" and put it to textbox...
i need your help..please..thanks
The easy way to to sort the the data when you select it from the database.
i.e. Order by ExpirationDate
Quote:
Originally Posted by DataMiser
sir how to do this sir please give me some idea...
Well I do not know how you are gettign your data from your data table but normally you would use a SQL select statement, if you add to that the order by clause your data will be sorted in the way you specify. In this case by date which would make the first record the least date.
If you do not know how to write a select statement I would suggest google, there are many examples all over the web.