Access FilterExpression problem

  • Thread starter Thread starter Scott Starker
  • Start date Start date
S

Scott Starker

I am using MS Visual Web Developer 2005 Express Edition, MS Access DB, XP
Pro and IIS 5.1 on my local XP Pro.

What I want to know is how to set the FilterExpression which the parameter
is an integer (not ControlParameter). Right now I have:

AccessDataSource1.FilterParameters.Clear()
Dim prViewState As Parameter = New Parameter()
prViewState.Name = strFilterLangID
prViewState.Type = TypeCode.Int32
prViewState.Direction = ParameterDirection.InputOutput
AccessDataSource1.FilterExpression = "Languages.LanguageID={0}"
AccessDataSource1.FilterParameters.Add(prViewState)

and it wont work. Any help would be appreciated.

Scott
 
Back
Top