Stored procedure
Create Procedure MyProcedure
(
@registrationdate datetime = NULL,
///some variables here
) AS BEGIN
If @registrationdate IS NOT NULL and Len(@registrationdate)=0 Set @registrationdate = NULL
//Some more for other variables
Select * From Tables
WHERE
//other columns here
AND
//Date column search query here
( @registrationdate is NULL or registrationdate IN (@registrationdate + '%'))
AND
//Code behind
cmd.Parameters.AddWithValue("@registrationdate", Convert.ToString(Session["RegDate"]));
//Ajax calendar control
<cc1:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtRegDate"
PopupButtonID="regcal" Format="yyyy-MM-dd" >
</c ...
Go to the complete details ...