dear friends i want to filter data by date ... see the attach pictures, after using where clause i receicve 0 rows :(
saleem.mukhtiar
0
Newbie Poster
Recommended Answers
Jump to PostUse DataView class and RowFilter property of it, to specify the filter.
But before that fill the dataTable and use databinding (datatable has to be a binding source of datagridview control).
Jump to PostSince your check in date is actually a date+time you can't just go ahead and say
check_in = '3/11/2012'
because this translates to '3/11/2012 00:00:000'
You should make sure that either your filter gets into account only the date part or filter for check_in between '3/11/2012' and '3/12/2012'Please …
Jump to PostLike won't do the trick by itself. In order for like to work you need a wildcard character in your string ('%' or '_').
Since you are not using any your like is the same as =I am not sure what db you are using, so I'll use …
All 10 Replies
Mitja Bonca
557
Nearly a Posting Maven
adam_k
239
Master Poster
saleem.mukhtiar
0
Newbie Poster
adam_k
239
Master Poster
M.Waqas Aslam
67
Posting Pro in Training
Featured Poster
saleem.mukhtiar
0
Newbie Poster
saleem.mukhtiar
0
Newbie Poster
M.Waqas Aslam
67
Posting Pro in Training
Featured Poster
saleem.mukhtiar
0
Newbie Poster
adam_k
239
Master 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.