Hello,When I have to filter BO, this code works fine until First Name has a single quote (For example o'reilly)CustomerBO.Filter = "FirstName = '" & First_Name & "'"What is the alternative?
Hello,
When I have to filter BO, this code works fine until First Name has a single quote (For example o'reilly)
CustomerBO.Filter = "FirstName = '" & First_Name & "'"
What is the alternative?
First_Name.Trim.Replace("'", "''")
replace single quote with two single quote.
CustomerBO.Filter = String.Format("First_Name = {0}", First_Name)