Rob Garrett - Blogs

Welcome to Rob Garrett - Blogs Sign in | Join | Help

in	Search
	Google

Home

Blogs

Gadgets

Software/Technology Discussion

Software and Technology Tid-bits

FOR XML and ADO.NET

My esteemed colleague Sahil Malik has blogged about using FOR XML in SQL server. The following C# example demonstrates how to retrieve XML data from a SQL Server 2K5 database as XML:

using (SqlConnection conn = new SqlConnection("..."))
{
    using (SqlCommand cmd = new SqlCommand(
        "select'Rob' as [Employee/@EmployeeName],'A cool dude' as [Employee] FOR XML PATH('Staff')", conn))
    {
        conn.Open();
        XmlReader reader = cmd.ExecuteXmlReader();
        while (reader.Read())
        {
            switch (reader.NodeType)
            {
                case XmlNodeType.Element:
                    if (reader.HasAttributes)
                    {
                        Console.Write("<{0} ", reader.Name);
                        reader.MoveToFirstAttribute();
                        do
                        {
                            Console.Write(reader.Name + "=\"" + reader.Value + "\"");
                        }
                        while (reader.MoveToNextAttribute());
                        reader.MoveToContent();
                        Console.Write(">");
                    }
                    else
                        Console.Write("<{0}>", reader.Name);
                    break;
                case XmlNodeType.Text:
                    Console.Write(reader.Value);
                    break;
            }                               
        }
    }
}

Share this post: Email it! | bookmark it! | digg it! | reddit!

Published Monday, August 01, 2005 10:23 AM by Rob Garrett

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

Sahil Malik said:

Very cool !!! :-)

August 1, 2005 10:27 AM

Name (required)
Your URL (optional)
Comments (required)
Remember Me?
Submit

Blurb

Rob Garrett is a British Expat living in Maryland USA. Rob is a trained software engineer and experienced in Windows .NET development.

Rob enjoys listening to Rock music, posting to blogs, driving in the country with the sunroof open, beer (not in conjunction with country driving) and spending time with his family.

Rob Garrett - Blogs

Software/Technology Discussion

FOR XML and ADO.NET

Comment Notification

Comments

Sahil Malik said:

Leave a Comment

Blurb

This Blog

Recent Posts

Syndication

Archives