XML to Database

Question

0.00/5 (No votes)

See more:

I have the following XML file:

XML

<?xml version="1.0"?>
<company>
<companyname>
<group>Accenture BPO</group>
<group>Accenture IT </group>
<group>Accenture Infotech</group>
</companyname>
<companyname>HCL</companyname>
</company>

How would I store it in a database table ?

Posted 14-Dec-10 21:01pm

shikhar gilhotra

Updated 19-Oct-20 8:03am

Sandeep Mewara

v3

Add a Solution

Comments

OriginalGriff 15-Dec-10 4:08am

Answer updated

4 solutions

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)

Member 14969543 · Answer 1 · 2020-10-19T08:04:00

You can use

JJsonsoft/Newtonsoft

framework.
It helps you to migrate xml data into database.
This framework is used to move multiple type of collections
into multiple type of databases.

JXmlMySQLDataAdapter

It Provides you multiple type of data adapters.
For example,

MySqlDataAdapter.PM_MigrateInDBConnStr

Which is generic for any type,
And it will help you to put particular data in particular database.

For your reference[^]

Member 14969543 · Answer 2 · 2020-10-19T07:59:00

You can use

JJsonsoft/Newtonsoft

framework.
It helps you to migrate xml data into database.
This framework is used to move multiple type of collections
into multiple type of databases.

JXmlMySQLDataAdapter

It Provides you multiple type of data adapters.
For example,

MySqlDataAdapter.PM_MigrateInDBConnStr

Which is generic for any type,
And it will help you to put particular data in particular database.

For your reference[^]

Sandeep Mewara · Answer 3 · 2010-12-14T21:39:00

Solution 2

Well, another interview question of yours!
for head start, the question is asking you to design a table structure such that the above xml data can be saved easily.

Think of company table & Group table with Associated table if needed.

Posted 14-Dec-10 21:39pm

Sandeep Mewara

OriginalGriff · Answer 4 · 2010-12-14T21:30:00

Solution 1

We do not do your homework for you.
Try it yourself, and if you get stuck, ask us then.
But don't expect us to hand it to you on a plate!

"Is there any way i can ask all my queries BY PAYING YOU dear ?? - shikhar gilhotra 27 mins ago

No.
1) That would defeat the purpose of the exercise. It would become "Who has the most money" rather than "who actually knows something, and can do teh job".
2) You couldn't afford me.

Posted 14-Dec-10 21:30pm

OriginalGriff

Updated 14-Dec-10 22:08pm

v2

Comments

shikhar gilhotra 15-Dec-10 3:38am

Is there any way i can ask all my queries BY PAYING YOU dear ??

Hiren solanki 15-Dec-10 3:40am

@shikar : Yes send 1 million to my paypal acc for solving it.

My suggestion would be to not became rude in any case, People are doing their work in free time here, Just wait for answer or follow the suggestion.

shikhar gilhotra 15-Dec-10 4:18am

See I am new but i always try my best to resolve it , my friend . But when i failed then only i wrote the query here...and look at you..More than a RESOLUTION, i recieved NOTHING

fjdiewornncalwe 25-Dec-10 18:27pm

@shikhar... You receive nothing because you don't explain anything to us about what you try. I'll give you the benefit of the doubt here that you actually did try. Explain to us what you did try and where it went wrong for you. There are literally hundreds of experienced minds here who would be willing to help in that situation.

XML to Database

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0