hi. i just want to ask how can i populate a listview n vb.net that has a is limited by a date from and date to. i have a datetimepicker for start date and datetimepicker for end date and i want do list all the entry of my database in listview that is within the range of the start date and end date. thanks in advance
iefilec
0
Newbie Poster
Recommended Answers
Jump to PostAre you having a problem with the SQL part, the ListView part, or both? My SQL is rusty so I'll leave that to the experts as I have no SQL implementation to play with, however, the ListView part is something I can help you with. What specifically are you having …
Jump to PostOne of the ways is to create a SELECT command for your database with the range in the select clause.
With this command you can create a datareader to read row-by-row from your database and using each row, add a listview item (with subitems if needed) until no more data …
All 5 Replies
Reverend Jim
4,561
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
lolafuertes
145
Master Poster
Reverend Jim
4,561
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
iefilec
0
Newbie Poster
MartinPlatt
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.