Filter

Hello,

I'm trying to filter my bindingsource but I get an error when the name contains an apostrophe  '

bindingsource.Filter = "marketClientComp ='" & marketingList.marketingId & "'"

the error I get is: Exception thrown: 'System.Data.SyntaxErrorException' in System.Data.dll Additional information: Syntax error: Missing operand after 'Urfé' operator.

I don't know beforehand what the filtered value will be because it comes from the user clicking another datagridview

Thanks for the help!