grid view filters
<p>net application with gridview.Am using filters to filter only one column.Now i want to filter two or more than two columns.How to i set the filters for that..if i give &amp;&amp; or|| operators it is showing syntax error..</p>

<p>i given the code as;
"
            ProviderName="&lt;%$ ConnectionStrings:booksConnectionString.ProviderName %>" 
            SelectCommand="SELECT * FROM [book]"
            <strong>FilterExpression="UserName Like '{0}%' || Password Like '{0}%'" ></strong>
            
                
            
        </p>
