Xml saved in database

Question

0.00/5 (No votes)

See more:

Hi there

I want to save data in Xml to a database as a string but am not familiar with Xml.

Basically, would like a simple C# example where an Xml document is created (the data doesn't matter), and the characters are saved in a string to be saved in a database.

Any ideas?

Posted 28-Jul-10 9:57am

Ryan Minor

Add a Solution

Comments

AspDotNetDev 28-Jul-10 18:42pm

I deleted your answer as it was not really an answer. Rather than post an answer, you can also post a comment on an existing answer (kind of like how I'm posting a comment to your question) or update your original question. However, for what you posted, I would say the more appropriate thing to do would be to Google for an answer and, if that failed, ask another question (as an entirely different question rather than adding to this one). Also, the best way to thank somebody for an answer is to rate it and mark it as an accepted solution (wink wink, nudge nudge).

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)

AspDotNetDev · Accepted Answer · 2010-07-28T10:11:00

Here is a very simple example.

C#

/* Create XML document. */
System.Xml.XmlDocument d = new System.Xml.XmlDocument();
d.LoadXml(@"<animals><dog name=""Ruff"" /><cat name=""Nip"" /></animals>");

/* Get XML as string. */
string str = d.OuterXml;

Save that string to the database as you would any other string. Make sure to use a data type that can hold a long string (if your XML has the potential to be large).