View Single Post
 
Old September 19th, 2004, 11:38 PM
vb_developer vb_developer is offline
Authorized User
 
Join Date: Aug 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating a new table from a dataset...

How can I create a new table from dataset which has been filled from a xml file...?

In fact I found no way ,so I did it manually,I mean retrieved name of dataset table columns one by one and created then filled the SQL table,but I has two main problems:
  1.The code is not that much beautiful!!
  2.When there exists a string cell in table where contain ('),the query string will be unacceptable for SQL cause it contains a useless (') in the query like:

INSERT INTO tablename VALUES ('La maison d'Asie');
How can i fix the problem?