FilterExpressio n - AccessDataSourc e

[mosscliffe]

I am trying to filter an accessdatsource by adding a FilterExpressio n

If I have Field = 2 It works fine
If I have Field IN (1,5,7) it works fine

So now I want it to reference a dropdownlist

so I try Field = ddlCats.Selecte dValue - Fails Miserably

So I read further and try

Field='@FieldID '
and then in FilterParameter s I have FieldID pointing at
ddlCats.Selecte dValue

SelectedValue and the field being tested are INTS

SourceCode Generated
<asp:AccessData Source ID="accGetMatch ed" runat="server"
DataFile="~/AppData/lists.mdb"
SelectCommand=" SELECT[ListID], [CatID], [Category],
[Title], [Details] FROM [PublicLists] WHERE (([Title] LIKE '%' + ? +
'%') OR ([Details] LIKE '%' + ? + '%'))" FilterExpressio n="CatID =
'@CatID'">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="tbxL ookup"
Name="Title" PropertyName="T ext" Type="String" />
<asp:ControlPar ameter ControlID="tbxL ookup"
Name="Details" PropertyName="T ext" Type="String" />
</SelectParameter s>
<FilterParamete rs>
<asp:ControlPar ameter ControlID="ddlC ats" Name="CatID"
PropertyName="S electedValue" />
</FilterParameter s>
</asp:AccessDataS ource>
-------------------------------------------------------------------------------------------------

I get the following error message:
Cannot perform '=' operation on System.Int32 and System.String

The Like tests based on the textboxes all work it is only when I try to
filter on the value of the dropdownlist do I get the error.

I may be completely wrong in how I am attempting to do this filter, but
I will always do the LIKE Filtering, but only occasionally the
FilterEpression . When I get it working I will attempt to fill the
properties programmaticall y.

If I do not have the quotes around 'FieldID' it gives the error: Can't
find Column FieldID

Any pointers or example syntax, would be gratefully received.

[mosscliffe]

On further research it may be because SelectedValue is a string, but
when I try my filter as

<asp:AccessData Source ID="accGetMatch ed" runat="server"
DataFile="~/AppData/lists.mdb"
SelectCommand=" SELECT[ListID], [CatID], [Category],
[Title], [Details] FROM [PublicLists] WHERE (([Title] LIKE '%' + ? +
'%') OR ([Details] LIKE '%' + ? + '%')) order by category,
title" FilterExpressio n="CatID ='@CatID'">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="tbxL ookup"
Name="Title" PropertyName="T ext" Type="String" />
<asp:ControlPar ameter ControlID="tbxL ookup"
Name="Details" PropertyName="T ext" Type="String" />
</SelectParameter s>
<FilterParamete rs>
<asp:Paramete r
DefaultValue="I nt32.Parse(ddlC ats.SelectedVal ue)" Name="CatID" />
</FilterParameter s>

Cannot perform '=' operation on System.Int32 and System.String

Please help, I am wasting so much time,