Hi all,

I want to search the word below from the mysql database. But that word has some special characters like '

So i've written a code for search it. but it doesn't work, because there are some special characters. this is the code.

da = New MySqlDataAdapter("Select * from fixedbasics where LType='" & Trim(ComboBox1.Text) & "'", con)


t,a'wd¾'iS - This is the word, i want to search by an combobox.

can you help me to correct this code.

Thanks

Can you just use a parametrized query??

that way, it doesn't matter the weird chars, since they are completely handled by the database.

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

No idea what you say. Can you explain it or give a sample?

Thanks

Well, you didn't say anything about the database you are using. But using an SP you can fill your adapter with a command object and pass the needed parameter to that command object. You can do it also supplying directly the SQL to the command object.

So, When you initialize the adapter, you are supplying the select command text. Instead of filling the data, just use a place holder (the appropriate according to your database) and then fill the adapter.selectcommand.parameters with the value you need.

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

Hi,

Finally i found the method, that i want. here is the code.

da = New MySqlDataAdapter("Select * from fixedbasics where LType='" & Trim(ComboBox1.Text..Replace("'", "''");) & "'", con)

Thanks.