C# to manipulate SQL data and return XML, what an... itch :)

[cablesforless]

I'm tyring to get information from an SQL Server and save it as an XML. I don't know really where to begin but I would like to use c# as my programming choice output because thats what our new software uses. Now the problem is that I don't really know C#. Is there any good examples on how to do this? I need to gather information from a table, rename the nodes/tags, output the information, and in the middle of the output, do a loop from another table, and then go back and send the rest of the information.

Please help me guys.

[I.m.I]

try to search in google " fill dataset and save to xml c# "