how to display records based on selection of date


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: how to display records based on selection of date

  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, 05: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, 10:33 AM
  3. Replies: 2
    Last Post: 10-30-2002, 09:28 PM
  4. UI for Selection of Date Portions...
    By Michael Cole in forum Architecture and Design
    Replies: 3
    Last Post: 12-03-2000, 08:20 PM
  5. Replies: 2
    Last Post: 11-22-2000, 01:50 AM

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


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center