Posted on: 3/1/2015 10:12:39 AM | Views : 518

How to write SP Search  value from multi textbox and dropdownlist and some textboxes  value are empty:  like: search by title and or actor and or DirectorName

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>  
SELECT movies.movie_Id, movies.title, movies.image, Movie_Directors.DirectorName FROM movies INNER JOIN Movie_Directors ON movies.movie_Id = Movie_Directors.movie_Id CROSS WHERE (movies.title = "" or movies.title LIKE '%' + @title + '%') and (movie ...

Go to the complete details ...