Search in Repeater

Posted by user2797643 on Stack Overflow See other posts from Stack Overflow or by user2797643
Published on 2013-10-18T03:52:29Z Indexed on 2013/10/18 3:53 UTC
Read the original article Hit count: 101

Filed under:

On pageload i want to show all fields in repeater control and on typing licenseid in the textbox i want to show that specific licenceid details

IF I place below code in the datasource of repeater,First one is not working.In the second one i placed a textbox and put its value to 0 on pageload.it is working.But i want both to be working.

 SELECT * FROM License WHERE (0 = @selectAll OR LicenseID=@LicenseID) -> Not working 

 SELECT * FROM License WHERE (0 = @selectAll ) ->working

 SELECT * FROM License WHERE (LicenseID=@LicenseID)-> working

Thanks in advance for the help

© Stack Overflow or respective owner

Related posts about vb.net