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 ...