asp.net howto to put wildcards in date rowfilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
i have a dropdown where i have put dates in mm/dd/yy format and want to filter the date from the database(format mm/dd/yy time) based on these dates ie if i select 01/06/02 from the dropdown ,it shud show all the items wth this date and diff time, i cannot use like as it is not supported with datetime,"=" is not supporting wildcards and converting it to string throws an exception
ny ideas??
thnx in advance
 
h
i m sending the code if dat helps
//*****************************************************************
_tempstr = CType(Session("filterexp"), String) & " ='" & CType(Session("filterval"), String) & "%'
*******************************************/

but it throws the exception cannot use like with system.string and system.datetme :
ny suggestio
amrita
 
Back
Top