<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm trying to filter my bindingsource but I get an error when the name contains an apostrophe &nbsp;'<br />
<br />
bindingsource.Filter = &quot;marketClientComp ='&quot; &amp;&nbsp;marketingList.marketingId &amp;&nbsp;&quot;'&quot;<br />
<br />
the error I get is: Exception thrown: 'System.Data.SyntaxErrorEx<wbr />ception' in System.Data.dll Additional information: Syntax error: Missing operand after 'Urfé' operator.<br />
<br />
I don't know beforehand what the filtered value will be because it comes from the user clicking another datagridview<br />
<br />
Thanks for the help!
</div>
</div>


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!

Filter

Hello,

I&#39;m trying to filter my bindingsource but I get an error when the name contains an apostrophe  &#39;

bindingsource.Filter = &quot;marketClientComp =&#39;&quot; &amp; marketingList.marketingId &amp; &quot;&#39;&quot;

the error I get is: Exception thrown: &#39;System.Data.SyntaxErrorException&#39; in System.Data.dll Additional information: Syntax error: Missing operand after &#39;Urfé&#39; operator.

I don&#39;t know beforehand what the filtered value will be because it comes from the user clicking another datagridview

Thanks for the help!

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.