ADO.NET writing XML file by schema using datasets

[Andrius]

Hello,

having some problems by writing XML file by XML schema.
using strongly typed datasets.

Schema:

<?xml version="1.0" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:include schemaLocation= "types.xsd" />
<xs:element name="CharactLi st">
<xs:complexType >
<xs:sequence>
<xs:elementname ="Charact"maxOc curs="unbounded ">
<xs:complexType > <xs:sequence>
<xs:element name="Id" type="Id" /> <xs:element
name="Did" type="Id" />
<xs:element name="Operation " type="Operation " />
<xs:element name="DateFrom" type="ISODate" />
<xs:element name="Character istics">
<xs:complexType >
<xs:sequence>
<xs:element name="RiskGroup " type="RiskGroup " minOccurs="0" />
<xs:element name="Interest" type="Interest" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

C# code:

// xml schema compiled to dll
CharactList charactDS = new CharactList();
SqlDataAdapter charactCMD = new SqlDataAdapter( q1, lizingConn);

int i = charactCMD.Fill (charactDS, "Charact");
richTextBox1.Te xt+= "Rows:" + i;

charactDS.Write Xml("Charact.xm l", XmlWriteMode.Wr iteSchema);
....

Everything is working, but generated new XML file isn't what i need:

<Charact>
<Id>4648</Id>
<Did>14252</Did>
<Operation>CO R</Operation>
<DateFrom>200 4-12-31</DateFrom>
</Charact>

It must be like this:

<Charact>
<Id>4648</Id>
<Did>14252</Did>
<Operation>CO R</Operation>
<DateFrom>200 4-12-31</DateFrom>
<Characteristic s>
<Interest>4.265 </Interest>
</Characteristics >
</Charact>

SQL statement is good, it returns Interest and RiskGroup values, how
to put those values to XML?

SQL:

SELECT
SutCSutId AS Id,
SutCIstId AS Did,
SutCOper AS Operation,
Convert(Char(10 ),SutCDate,126) AS DateFrom
Convert(Decimal (18,3),SutCVert e*100) AS Interest,
SutCRizika AS RiskGroup
FROM
SutCharacter AS chr
INNER JOIN Sutartys AS sut
ON chr.SutCSutId = sut.SutId
WHERE
SutCOper <> 'DEF' AND
SutTipas <> 'SV' AND
SutBusena IS NULL AND
SutCIstId IS NOT NULL
;

Sorry, I am new with XML.

thanks for help.