Reading XML Data using SqlDataReader

Question

I have a stored procedure that creates an XML document. I then have the following code:

using (SqlConnection con = new SqlConnection(_connectionString))
{
    con.Open();

    using (SqlCommand cmd = new SqlCommand("GetModuleInstallerManifestXML", con))
    {
        cmd.CommandType = System.Data.CommandType.StoredProcedure;

        cmd.Parameters.Add(new SqlParameter("@mod_name", SqlDbType.VarChar, 250)).Value = this.ModuleName;

        using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
        {
            while (reader.Read())
            {
                manifestXmlList.Add(reader[]);
            }
        }
    }
}

I need to add the xml data row by row into a list and then write that list to a file, how do I do this?

Community · Accepted Answer · 2017-05-23 12:10:15Z

2

check this answer https://stackoverflow.com/a/5424250/5358389

string xmlString = string.Empty;
using (XmlReader reader = cmd.ExecuteXmlReader())
{            
     XDocument xml = XDocument.Load(reader);
     x.Save("filePath");
}

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Mar 22, 2017 at 15:26

daniell89

2,34220 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mattaceten Over a year ago

Thanks for the help.

Collectives™ on Stack Overflow

Reading XML Data using SqlDataReader

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related