C# sql query to add attributes for the elements in xml

Question

I want to display the XML file by taking tag from the XML_TAGS table, and attributes from theMAPPED_TAGS_ATTRIBUTES table - something like <element attributes></element>:

String sql = "SELECT Dtd_Tag,Dtd_Attribute_Name 
                FROM Xml_Tags,
                     Mapped_Tags_Attributes 
               WHERE Mapped_Tags_Attributes.Pdf_Tag = Xml_Tags.Pdf_Tag 
            ORDER BY Mapped_Tags_Attributes.Pdf_Tag 
             FOR XML AUTO";

i want to display xml file by taking tag from xml tags table and attributes from Mapped_tags Attributes table... something like <element attributes></element> — rachana
– rachana, Commented May 4, 2011 at 6:43
Please add the structure of the tables you want to use, some sample data and the expected output. — Mikael Eriksson
– Mikael Eriksson, Commented May 4, 2011 at 6:54

Alex Aza · Accepted Answer · 2011-05-04 06:48:54Z

1

Query:

select
    c.CustomerId as "@Id",
    c.AcountNumber as "@AcountNumber"
from Customer c
for xml path('Customer'), root('Customers')

Result:

<Customers>
   <Customer Id="1" AccountNumber="X120" />
   <Customer Id="2" AccountNumber="X121" />
</Customers>

answered May 4, 2011 at 6:48

Alex Aza

78.8k26 gold badges157 silver badges134 bronze badges

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

3 Comments

rachana Over a year ago

i want the query to take the elements and attributes from database..how can i do that...

rachana Over a year ago

1 <Image> mediaobject 1 title 1 <para id =0> para 1 pubdate 1 <para id =1> simpara 1 <para id =2> titleabbrev 1 <para id =3> section 1 <para id =4> sect1 1 <para id =5> sect2 1 <para id =6> sect3 1 <para id =7> glossdef NULL NULL NULL

rachana Over a year ago

<Image> xlink:actuate onLoad #IMPLIED null <Image> xml:lang CDATA #IMPLIED null <Image> xml:base CDATA #IMPLIED null <Image> remap CDATA #IMPLIED null xmlns CDATA #FIXED "docbook.org/ns/docbook" xlink:actuate none #IMPLIED null <para id =0> revision CDATA #IMPLIED null <para id =0> vendor CDATA #IMPLIED null <para id =0> wordsize CDATA #IMPLIED null <para id =0> xlink:actuate none #IMPLIED null xreflabel CDATA #IMPLIED null revisionflag added #IMPLIED null

Collectives™ on Stack Overflow

C# sql query to add attributes for the elements in xml

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related