tablink = "t20002001"
            Dim adp As New OleDb.OleDbDataAdapter("select * from " & tablink & " WHERE name = '" & tbname.Text & "' and fhname = '" & tbfhname.Text & "'", con)

i am using above code line. my database is in hindi,so in hindi a character is translated as apostrophe in english keyboard. whenever i compare such word which contains apostrophe in tbname.text text box, it creates syntax error. how to solve this problem.



ramni

Replace ' with ''

Your database should handle that.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Why are you using single quotes in variable names? Variable names are part of the program code, and need not be linguistically accurate.

Though it might read better, changing the variable name to jai_jhkkl or jaíjhkkl or jaí_jhkkl would permit the program to run, and should be clear enough so as to understand the code for maintenance later.

You also can use comments to make code clearer when you have to corrupt a legitimate word so as to use it as a variable name: (Actually, what you posted as your code doesn't make sense. As far as I'm aware, .NET does not recognize ' as text delimiter, and databses do not recognize designations like tbname.text...)

You are quite right Brian, using an ' in a variable name declaration will cause a compiler error. While the code presented isn't syntactilly correct I inferred that the syntax was probably irrelevant since this individual probably replaced the actual variable name with jai'jhkkl to demonstrate their point. Of course this is just an assumption and you know what that can lead to!

As always your bring up some very good points as well.

-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

thanks for helping me. i must clear my query first my coding is as follows:

 Dim adp5 As New OleDb.OleDbDataAdapter("select * from " & tablink & " WHERE name = '" & tbname.Text & "' and fhname = '" & tbfhname.Text & "' ", con)

here in hindi database column name there is a value like "kjkjiuo'jkj"
this single code makes syntax error during execution of the program.
now my query is clear and any suggestion regarding it is most welcome.

ramni