XML Save and Load to SQL Server 2005 database.

[ashwath1979]

Hi All, Please tell me how to do the following: XML save and load of data to SQL Server 2005 database? Thanking you in advance, Regards, Ashwath Hegde.

[Henry Minute]

Look at the MSDN documentation for either DataSet or DataTable. Both of them have ReadXml and WriteXml methods.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[N a v a n e e t h]

You can have your column type as XML and SqlDbType[^] enum supports XML type. You can write something like,

using (SqlConnection conn = /* ... */)
using (SqlCommand cmd = new SqlCommand("insert into your_table VALUES(@xml_content)", conn))
{
cmd.Parameters.Add("@xml_content", SqlDbType.Xml).Value = new SqlXml(reader);
// other code
}

SqlXml can take a Stream or a XmlReader instance. For reading data, work with the SqlDataReader.GetSqlXml()[^] method. SqlXml.ReadOuterXml() will give you a string representation of the XML. :)

Navaneeth How to use google | Ask smart questions

[ashwath1979]

Can you please give the complete code snippet so that i can understand fully.

[N a v a n e e t h]

ashwath1979 wrote:

Can you please give the complete code snippet so that i can understand fully.

That is laziness. What have you tried and where you are stuck?

Navaneeth How to use google | Ask smart questions