troubleshooting Question

Problem in dataView.RowFilter

Avatar of alnahas1
alnahas1 asked on
.NET ProgrammingASP.NET
7 Comments1 Solution796 ViewsLast Modified:
I work on vs 2005 c#
Have dataview and I made  rowfilte

string Myaddress="alexandria";
Just like dataView1.RowFilter = "Columnaddress like '%" + Myaddress + "%' ";
And its work fine

Problem when I when to make operator or for more than one letter
string Myaddress="al[ea]xandria";
Just like dataView.RowFilter = "Columnaddress like '%" + Myaddress + "%' ";

Error >> Error in Like operator: the string pattern '%[ea]%' is invalid.

I want to make operator or in letters like sql server .
Whats is the slove ?????
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros