DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    30

    how to display records based on selection of date

    Hi.
    I have to display records based on selection of date.
    I have a scenario like "Enter start date - textbox - Enter End Date - textbox and then a Button. On Clicking this button it shd display all records within this date range. How to do this in vb.net..
    Thanks...

  2. #2
    Join Date
    Jul 2007
    Location
    Minnesota
    Posts
    155
    In your SQL query that retrieves records, your syntax will be something like this.
    Assuming textbox1.text has beginning date and textbox2.text is the end date.

    Code:
    "SELECT * FROM Yourtable WHERE Date BETWEEN "& textbox1.text &" AND " & textbox2.text &" "

Similar Threads

  1. SQL and date range selection
    By cal in forum Database
    Replies: 4
    Last Post: 01-06-2008, 04:29 AM
  2. Date and/or Time selection ASP.NET Control
    By Active Up in forum dotnet.announcements
    Replies: 0
    Last Post: 05-13-2003, 09:33 AM
  3. Replies: 2
    Last Post: 10-30-2002, 08:28 PM
  4. UI for Selection of Date Portions...
    By Michael Cole in forum Architecture and Design
    Replies: 3
    Last Post: 12-03-2000, 07:20 PM
  5. Replies: 2
    Last Post: 11-22-2000, 12:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links