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?

Hi,

1) You haven't mentioned anything on, if you are using ASP or ASP.Net.

2) You can always replace (') with double ('')s in that case to get that work.

You would better take a look at the OPENXML statement, that would be of some help in this.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Hey,

You talking about creating a table at the database level, or within the dataset?

Brian

Hi,

I meant creating a table at the database level FROM a table within a dataset.

There are lots of problem cause,when a table is written in XML format then read to a dataset from the xml document ,the Column Types of the dataset table and database table does not match,so there maybe some kinds of column types missed during the read and write to and from the xml document to the dataset table and database table...,so if there existed an predefined way ,these problem s could be solved,but I have not found this yet...

And Vijay ,I forgot to mention that I'm doing in ASP.NET.

Thanks

Hey,

I don't think you can just do it from a data set, you would have to create a dynamic create table script, which you would need major permissions.

Brian