How to insert a xml file in sql server database using asp.net?

[sanghamitra das]

hii,

i want to insert a xml file into the sql server using asp.net.can sm1 help me wth d coding part?

[iburyak]

What server version you use?

In 2005 - there is XML datatype and almost unlimited size of XML.

In 2000 - for character datatype you limited to 8000 characters unless you are going to use text datatype.