BindingSource.Filter problem

[Seishin]

Hi! my problem is that i try to input string containing ' char into filter statement which causes an System.Data.SyntaxErrorException is thrown.. string str1 = "aaaa"; string str1 = "aa'aa"; bs.Filter = string.Format("val1 like '{1}' and val2 like '{2}'", str1, str2); outcome would be: bs.Filter = "val1 like 'aaaa' and val2 like 'aa'aa'"; thanks for any help!!!

life is study!!!

[Anil Ch]

1. string.Format("val1 like '{1}' and val2 like '{2}'", str1, str2); Should be string.Format("val1 like '{0}' and val2 like '{1}'", str1, str2); 2. aa'aa should be aa''aa becuase filter behaves same way as a stored procedure would behave.