qns about dropdownlist and datalist

try like this

if(ddlItem.SelectedValue=="ALL")
{
//select all the data and bind to datalist
}
else
{
//select passing the dropdownselected value to database to select corresponding data bind to datalist.
}

ex:- 1st query : Select * form itemtable
2nd query: Select * from itemtable where item='"+ddlItem.SelectedValue+"'

I mean I have a dropdown list that have All, Dog, Cat


and a datalist

want the dropdownlist show All

I will show all the item from the database but want is show cat

It only show all the item that are cat only and not show all

I got nothing by your text. Please clear what you actually want?

Hi,
        Not clear about your query. Can you please provide more details?

Regards,
Iftikar