How to Read XML and create sql table using C#?

Question

1.00/5 (1 vote)

See more:

we get XML/XSD files from third party.
Based on the files we need to create tables in the database using C#.NET.
Could you help with this.

Thanks

Posted 28-Jun-14 9:06am

Sitaramaiah E

Add a Solution

Comments

[no name] 28-Jun-14 16:10pm

You have not said what you need help with.

George Jonsson 28-Jun-14 23:53pm

Do you need to create the tables from using XSD as a template or do you need to fill the tables with data from an XML file?

Sitaramaiah E 29-Jun-14 9:40am

Hi George,
I need to create the tables using XSD as template.

George Jonsson 29-Jun-14 11:13am

Well, that is kind of a tall order.
1. Parsing an XSD file is not exactly trivial.
XSLT is probably the best option.

2. How do you want to create the tables?
2.1 Via direct SQL from c# code?
If so the SQL flavor has to be known. (Oracle, MS SQL, MySQL)
2.2 Via a Stored Procedure?
This is the more generic approach.

3. How to treat tables in XSD without primary keys?
Assume that you add an auto-incremental ID as the primary key?

And probably some more questions I haven't considered yet.
// George

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

GrooverFromHolland · Answer 1 · 2014-06-29T10:44:00

Hi,

First make datatable from xml like this:

C#

DataTable table;

       private void createDatatableFromXML()
       {
           table = new DataTable();
           string dataFile = @"DatafileLocation\datafile.xml";
           if (File.Exists(dataFile))
           {
               table.ReadXml(dataFile);

           }
           else
           {
              //Do som messaging
               return;
           }
       }

If You want to create a sql database from the dataTable see this:http://stackoverflow.com/questions/1348712/creating-a-sql-server-table-from-a-c-sharp-datatable[^]

Hope this can help You,

Groover