I am trying to select some row from a datatable & store in Array of datarows where the datatable column contains a particular string. I am using the following code for this:
Datarow = Datatable.Select(“Columnname = '”+Stringinput+"’")
This code is working fine until the Stringinput has some Apostrophe in it. For example if The stringinput is like : " This is John’s pen" then it is throwing error Assign: Syntax error: Missing operand after ‘s’ operator.
Please suggest me what can be an workaround here.