How to store XML into the sqlserver database

cockyang

Store the xml file in the sqlserver data, the data type of the field is xml

Xml xdItem = new Xml ();
xdItem.Document = GetTree ();

object [] obj = {null, xdItem};
Database.ExeProcNonQuery ("stored procedure", obj);

Prompt error "Failed to convert parameter value from xml to String"
Everyone help, how to save xml file into sqlserver data?

littlejack

There is a good way to open the XML file in Notepad and manually add it to the SQL SERVER. . . Haha

suncat10

Use Stream to read XML, the fields in SQL SERVER are defined as binary. Store the XML in a binary format

3521565

You can use the program to read into the DataSet, and then use the SQL statement to insert one by one. I only know this method and can't give you more help

crasis

3521565method I always do this

First read the xml into the DataSet, then update it back...

Hope that person tells me a good way.