Sql Query to Search by matching Year Month and Day parts of Date

hi

I have House_p table that save user's product information

Now I have 3 dropdownlist and 1 button=BtnSearch and 1 Datalist=DLProduct

1-DDLYear that I bind it from database and show years

2-DDLMonth that I bind it from database and show Month

3-DDLDay I bind it from database and show Day

Now I want when I select year-month-day from 3 dropdownlist and click on BtnSearch it show product information in datalist

How I can do it?

below is SP that I bind Datalist

SP

alter procedure dbo.searchPic

AS
BEGIN
select * from House_p



END

ANd behindCOde

 BindDataList(DLProduct, "searchPic");

            BindDropDownList(DDLYear, "YearA", "Year", "id");
            BindDropDownList(DDLMonth, "MonthA", "Month", "id");
            BindDropDownList(DDLDay, "DayA", "Day", "id");

Thanks alot