Forget about it, i found the answer in my other tread about CursorToXML()

idbAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

This adds the complete schema to the XML string.


>I get this XML from a function created with ADO.NET:
>
>

><NewDataSet>
>  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
>    <xs:element name="NewDataSet" msdata:IsDataSet="true">
>      <xs:complexType>
>        <xs:choice maxOccurs="unbounded">
>          <xs:element name="Table">
>            <xs:complexType>
>              <xs:sequence>
>                <xs:element name="code" type="xs:string" minOccurs="0" />
>                <xs:element name="descr" type="xs:string" minOccurs="0" />
>              </xs:sequence>
>            </xs:complexType>
>          </xs:element>
>        </xs:choice>
>      </xs:complexType>
>    </xs:element>
>  </xs:schema>
>  <Table>
>    <code>S1</code>
>    <descr>TEST        </descr>
>    <descrf>TEST DESCR        </descrf>
>  </Table>
></NewDataSet>
>

>
>If i use XmlToCursor( xml, "testTable", 4), it create the cursor but the colums are created as char(1), and the data is truncated.
>
>What's up doc ?