TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Janos
NA
1
0
Please help with reading tricky xml
Jun 3 2010 6:30 PM
The Xml:
Micfosoft(TM)'s modified Books.xml:
The price attribute of the last book item was modified by me, now it appears two times,
once as attribute of book and second time as a separate item inside the book item.
[code]<?xml version='1.0'?>
<!-- This file represents a fragment of a book store inventory database -->
<bookstore>
<book genre="autobiography">
<title>The Autobiography of Benjamin Franklin</title>
<author>
<first-name>Benjamin</first-name>
<last-name>Franklin</last-name>
</author>
<price>8.99</price>
</book>
<book genre="novel">
<title>The Confidence Man</title>
<author>
<first-name>Herman</first-name>
<last-name>Melville</last-name>
</author>
<price>11.99</price>
</book>
<book genre="philosophy" price="best">
<title>The Gorgias</title>
<author>
<name>Plato</name>
</author>
<price>9.99</price>
</book>
</bookstore>[/code]
My code:
[code]using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Books.Properties;
using System.Data.SqlClient;
using System.Configuration;
using System.Xml;
using System.Windows.Forms;
using System.Xml.Schema;
using System.IO;
namespace Books
{
public partial class Books : Form
{
XmlDataDocument myXmlDataDocument = new XmlDataDocument();
public Books()
{
InitializeComponent();
DataSet ds = new DataSet("Books DataSet");
ds.ReadXml(@"../../Books.xml", XmlReadMode.InferSchema);
dataGridView.DataSource = ds;
dataGridView.DataMember = "book";
}
}
}[/code]
The runtime error is of course:
[url]http://i50.tinypic.com/2hezh8w.png[/url]
Column name 'price' defined for different mapping types.
Please help me find out how to define/refer in the code to this prices,
to be possible to read the xml!
I've been searching thorough google, but the most people were able to come up is "Change the xml",
the problem is that the actual xml that I'm working with, has been written in the same unfortunate fashion,
and can not be changed.
_
Reply
Answers (
1
)
converting image file into text file
code to get info then open a webpage based on that info on click but opens it twice why?