HELP in comparing strSQL with string having ' in it

[NewComer]

The following code having error because the name having a ' in it:

Dim str_Name As String
Dim strSQL As String

str_Name = "Marie D'Emma"

strSQL = "SELECT * FROM Employee WHERE Name = '" & str_Name & "'"
da = New OleDbDataAdapter(strSQL, dbConn)

How can I fix it? Considering I must search for that French name?

 

[MattP]

Use a parameter. Already an excellent thread about them on these boards.

The Ins and OUTs of Parameterized Queries... - Visual Basic .NET Forums

 

[NewComer]

I am working on your link

I am working on your link, thanks