Access FilterExpression problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"where" clause works where FilterExpression fails. 2
MS Access DB, XP Pro and IIS 5.1... 3
Custom Class with oledbcommand problem 5
schema compare problem 4
Visual Web developer 2005 and 2008 cannot open local web server 1
Selecting @@Identity from an Access Database 3
Windows XP Pro and Active Directory 2
Localhost server doesn't work after April 2009 MS Updates 7

Top