Parameter for all values

microsoft.public.dotnet.framework.adonet

28 Nov 2007 3:45 PM

Jim McGivney

This is probably a Newbie question, but your response would be appreciated.

Using VWD I have a GridView on a page. The GridView is feed data by
accessdatasource1.

I can filter the data using:
            Parameter Param = new Parameter("Sex");
            Param.DefaultValue = Sex;
            AccessDataSource1.FilterParameters.Add(Param);

            AccessDataSource1.FilterExpression = "Sex LIKE '{0}'";
            AccessDataSource1.SelectCommand = "SELECT DataNum, CaseNum,
Disp, Type, Last, First, MI, SSN, Sex, Race, DOB, ID, AdditionalInfo,
FileName FROM DataAA";
            AccessDataSource1.DataFile =
System.Configuration.ConfigurationManager.AppSettings["ConnString"];
This works.

At times I want the filter to pass all Sex values (Male, Female, Unknown).
What do I use for the default value when I want all entries passed ?

Do I use:
            Parameter Param = new Parameter("Sex");
            Param.DefaultValue = "*";
            AccessDataSource1.FilterParameters.Add(Param);
Or
            Param.DefaultValue = "All";

Or do I use something else.
Sample code appreciated.

Thanks in advance for your help.
Jim