Please..help Me..with date filtering..
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: Please..help Me..with date filtering..

  1. #1
    Join Date
    May 2011
    Posts
    2

    Exclamation Please..help Me..with date filtering..

    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

  2. #2
    DataMiser is online now Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    4,782

    Re: Please..help Me..with date filtering..

    The easy way to to sort the the data when you select it from the database.

    i.e. Order by ExpirationDate
    Always use [code][/code] tags when posting code.

  3. #3
    Join Date
    May 2011
    Posts
    2

    Re: Please..help Me..with date filtering..

    Quote Originally Posted by DataMiser View Post
    The easy way to to sort the the data when you select it from the database.

    i.e. Order by ExpirationDate

    sir how to do this sir please give me some idea...

  4. #4
    DataMiser is online now Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    4,782

    Re: Please..help Me..with date filtering..

    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.
    Always use [code][/code] tags when posting code.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center