when i am using a data array and taking the character one by one in each array and inserting in to a table using codes but when i am getting inverted comma it is giving an error massage ' is any other method to convert text in database

Do you need the inverted comma in your database record ? Since " ' " is a comment in VB, it will give errors if you are not careful about it. If you don't need it, u can simply replace it from the text by using Replace. If you need it, you have to check for it's existence and take appropriate measures.

no i need inverted commas because in address coloumn some body enters the house name in inverted commas so i need this , so pls suggest me the method