Parameter for all values

[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