K
konsu
hello,
would xml/ado.net experts please help me:
i have two sql tables (to store RSS feeds, but it is not important):
create table channels (id uniqueidentifier not null default newid() primary
key,
title nchar(256) null,
url ntext null)
create table items (id uniqueidentifier not null default newid() primary
key,
cid uniqueidentifier not null references channels(id),
title ntext null,
url ntext null,
descr ntext null)
RSS feeds usually come in XML like this:
<?xml version="1.0" ?>
<rss version="0.91">
<channel>
<title>...</title>
<link>...</link>
<description>...</description>
<item>
<title>...</title>
<link>...</link>
<description>...</description>
</item>
<item>
<title>...</title>
<link>...</link>
<description>...</description>
</item>
</channel>
</rss>
so, a channel can contain zero or more items.
i would like to read xml data into a DataSet object using DataSet.ReadXml(),
and save it into the above database tables using DataAdapter.Update().
the problem that i am trying to solve currently is that the schema of the
above xml does not match the schema of a dataset containing these two
tables, so nothing gets saved to the database. is there a way to tell
DataSet to read the given xml and convert the data to conform to another
schema?
would appreciate any input
konst
would xml/ado.net experts please help me:
i have two sql tables (to store RSS feeds, but it is not important):
create table channels (id uniqueidentifier not null default newid() primary
key,
title nchar(256) null,
url ntext null)
create table items (id uniqueidentifier not null default newid() primary
key,
cid uniqueidentifier not null references channels(id),
title ntext null,
url ntext null,
descr ntext null)
RSS feeds usually come in XML like this:
<?xml version="1.0" ?>
<rss version="0.91">
<channel>
<title>...</title>
<link>...</link>
<description>...</description>
<item>
<title>...</title>
<link>...</link>
<description>...</description>
</item>
<item>
<title>...</title>
<link>...</link>
<description>...</description>
</item>
</channel>
</rss>
so, a channel can contain zero or more items.
i would like to read xml data into a DataSet object using DataSet.ReadXml(),
and save it into the above database tables using DataAdapter.Update().
the problem that i am trying to solve currently is that the schema of the
above xml does not match the schema of a dataset containing these two
tables, so nothing gets saved to the database. is there a way to tell
DataSet to read the given xml and convert the data to conform to another
schema?
would appreciate any input
konst