asp.net howto to put wildcards in date rowfilter

[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

 

[Ken Tucker [MVP]]

Hi,

dv.RowFilter = "CategoryName Like '%'"

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data06142001.asp



Ken

 

[Guest]

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