SQLDatasource Filterexpression

Hi

on my page: two sqldatasources one has the sqlexperession:

SELECT DISTINCT [Skil] FROM [UsersView]
UNION
SELECT 'Alles'

the other one :

SELECT [UserName], [Afdeling], [Skil], [RoepNaam] FROM [UsersView]

the first source is bound to a dropdown list. witch I want to use for filtering.

the second to a gridview.

the code for the dropdownlist selectedindexchanged is:protected void SkillDDL_SelectedIndexChanged(object sender, EventArgs e)
{
if (SkillDDL.SelectedValue.ToString() == "Alles")
{
SqlDataSource3.FilterExpression = "";
}
else
{
SqlDataSource3.FilterExpression = "Skil = '" + SkillDDL.SelectedValue + "'";
}
}

 The strange thing is that initially 'Alles' is selected in the dropdown list and I see all the records. then I select an other value in the dropdownlist. and I get the filtered records, like I would expect.

then when I select 'Alles' again I keep my last selected records in view. I would expect that the filter is now an empty string and I would get all the records again. what do I do wrong?

thanks

 

Rob Warning