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: 130
        
vb.net
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