Storing XML data into SQL database

[KSR81]

Hi I am trying to store the xml data into the SQL database. The xml data that is am getting is through the xml file. I upload the xml file. When i click update, it should get updated into the database. Can anyone give me some ideas on how to do this. Thanks KSR

[Ashfield]

Use an xml datatype for the column and just do an insert, the same as any other data.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP