How to convert XML Datatype in SQL to C#

[srivatsan24]

Hi, How will i convert a XML datatype in SQL to a C# datatype. Can we use XMLDocument datatype in C#? If yes how can it be used? Thanks in advance Srivatsan

[originSH]

If it's sql server then use the ADO.Net classes .Net provides. Google: ado.net xml sql server[^]

[srivatsan24]

I want to create a XML document in the filesystem out of the XML that is coming from the table column. The column is of type Xml. So how will i do it. I understand that we can use the ADO classes when oing an updation into the column. How to get it into the code from the database table column? Srivatsan

[kubben]

If your sql server is sql 2005 then there is an xml type in sql 2005 that you can use. If you are using sql 2000 then you have to convert your xml type in .net to a string and save it in a text column. Hope that helps. Ben

[originSH]

You start off by learning the C# syntax, then you get used to using the BCL (Base Class Libarys) and then you read up on the specifics of using ADO.Net. You'll see that I gave a link to google with the appropriate keywords to help you find what you want. If that's no good there are plenty of books out there on how to do this.