Generate XML file from SQL server using ASP.NET

See more:

ASP.NET

Hi,

I want to generate a XML file from SQL table.

below is my code

protected void Button1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["mssp"].ConnectionString);
            string strSQL = "Select UserId, UserName from UserDetail";
            SqlDataAdapter dt = new SqlDataAdapter(strSQL, con);
            DataSet ds = new DataSet();
            dt.Fill (ds,"UserDetail");
            ds.WriteXml(Server.MapPath("emp_xml_file.xml"));
        }    
    }

It is generating the XML file like this

<NewDataSet>
<UserDetail>
<UserID>101</UserID>
<UserName>AAA</UserName>
</UserDetail>
<UserDetail>
<UserID>102</UserID>
<UserName>BBB</UserName>
</UserDetail>
</NewDataSet>

I need the XML file like this

<chart caption="sample" showlegent="1" decimalprecision="0">
<category>
<details id="101" name="AAA" />
<details id="102" name="BBB" />
</category>
</chart>

Please help. Thanks in advance