Filter Expression to include NULL

[primagic]

I have the following FilterExpression to search for records in a gridview.

 FilterExpression="[FirstName] LIKE '{0}%' OR SURNAME LIKE '{1}%'"

This works if I enter information into both fields but wont work if I leave either field blank.

I have set the filter parameters to convertemptystringtonull = true

Thanks

 

[jmeckley]

null is different than an empty string so you need to check for null
if the value is null ignore the criteria altogether.

var filter = "";
if(firstname != null && lastname != null)
{
  filter = "[FirstName] LIKE '{0}%' OR SURNAME LIKE '{1}%'" ;
}
else if(firstname != null)
{
   filter = "[FirstName] LIKE '{0}%'" ;
}
else if(lastname != null)
{
  filter = "SURNAME LIKE '{1}%'" ;
}
return string.Format(filter, firstname, lastname);

Jason Meckley
Programmer

faq855-7190
faq732-7259

 

[primagic]

Will your allow for empty fields? I want the user to be able to leave fields empty and return records on the specified information

 

[jmeckley]

read the code the snippet above will only filter if the value is not null. this assumes the value will never be an empty string. otherwise replace [tt]!= null[/tt] with [tt]string.IsNullOrEmpty(value) == false[/tt]

Jason Meckley
Programmer

faq855-7190
faq732-7259