hi
I have House_p table that save user's product information
|
Id
|
Name
|
Model
|
Date
|
|
1
|
TV
|
LG
|
2012-08-13
|
|
2
|
Furniture
|
Sofa
|
2012-08-14
|
|
3
|
Furniture
|
Table
|
2012-08-13
|
|
4
|
Refrigerator
|
XX3
|
2012-08-15
|
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
