When i am converting a XML having the following elements in the body:
<ROOT>
...
<ITEMS>
<ITEM attr1="value" attr2="value"/>
<ITEM attr1="value2" attr2="value2"/>
</ITEMS>
...
</ROOT>
to dataset an artificiant key is created for the table ITEMS which connects it to the table ITEM.
However, when i continue working with the dataset it display an error than a constraint is missing.
What is a correct way to handle such XML in the dataset in the condition i want to be able to work with tables in the type-safe manner (.NET 2.0) and see them in the design time
XML scheme that causing crashing of the dataset
Hot Topic
- Blocking Method Call
- New to Web Services
- Reading Binary Format (QBasic) with C#
- how can i embed realplayer into asp.net 1.1
- CM_Request_Device_Eject() is not firing any wparam .... in win XP
- Unattended Soap SDK installation
- How to emit delegate call (System.Reflection.Emit)?
- How to check if an xml schema type is already present in an XmlSchemaSet?
- Static method in an Interface?
- .NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7A05E2B3) (80131506)
.NET Development
- _int64 and sprintf
- Finalizer
- Derived classes - how to find derived class' attributes from base class
- a question about dialog message in 64 bit machine
- scripting in applications (c# .net2.0 vbs etc)
- API RTC SIP Communications problem
- Caching
- Try refreshing the table adapter
- Two Quick Sockets Question
- What is the best way to insert 4000 records to database every 5 secs. in C#?
XML scheme that causing crashing of the dataset
John Blight
Hi Minherz,
Initially I think you should design your dataset visually. That means create the object and in the surface add a DataTable and then load the xml in that dataset as normal.
In the visual design, you should create the primary key -if you need it - and any other constraint that you need.
Best Regards
Videe
This idea is not working in the case of the above XML as an example. When you create a DataTable and starting defining columns the generated code sets up MappingType.Element enumeration value for a DataColumn constructor. I did not find where i can change this behavior. In the case this is happening the call to LoadXML fails to load the XML.
Do you know a solution for it I failed to find one but discovered that generating a DataSet from the XSL file solves it. And it has its own drawback defined in this thread.