Multiple DataSets in one XML file

  • Thread starter Thread starter Sergio Rolanski
  • Start date Start date
S

Sergio Rolanski

It's very easy to DataSet.WriteXml() multiple dataset to a single xml
file, but when I want to DataSet.ReadXml() I don't know how to specify
whick dataset to read. Anybody knows if it's possible to have multiple
dataset in a single xml file?

Thanks,
Sergio V. R.
 
Unless you're taking some special care of XML structure, writing several
data sets into one XML would result in malformed XML document.
If you're fixing XML manually, look into ReadXml() overloads with
XmlReadMode argument and XmlReadMode.Fragment mode.
Again, it's up to you to find the right data set start and invoke ReadXml()
on it.

I don't see any advantages of that compared to normal file per data set
solution.
In fact, I do see a major disadvantage which is the need to overwrite the
entire file should you change even one record in one data set.
So I would suggest you don't do it.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
 
Thank you for the answer Ilya. Sorry I did not explained the
background of my problem. I need to send my local database(SqlCE) to a
remote server, my idea is to put every requested table in a xml file,
compress it and then send the compressed file(via http post). I going
to receive entrys to update my local database in the same way. Just
let me check if I got the right Fragment mode idea: there is a
ReadXml(XmlReader, XmlReadMode) overloaded method, using Read() from
XmlTextReader I may find the node with the dataset I want to read,
then pass the XmlTextReader(which is currently in the desired xml
dataset node) and XmlReadMode.Fragment to ReadXml() and then only that
dataset will be read?
 
Yes, that's the idea of a Fragment mode - to allow loading of XML fragment.

Anyway, this approach makes little sense to me. The obvious solution would
be to load all tables into the DataSet and save it all to the XML.
Yes, data for all tables would be loaded into memory at once.
However, that's most likely irrelevant as XML size containing data for all
tables would be several times bigger than in memory data anyway.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: (e-mail address removed) (Sergio Rolanski)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Re: Multiple DataSets in one XML file
Date: 15 Mar 2005 10:28:26 -0800
Organization: http://groups.google.com
Lines: 61
Message-ID: <[email protected]>
References: <[email protected]>
Click to expand...
NNTP-Posting-Host: 200.138.40.128
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1110911307 6060 127.0.0.1 (15 Mar 2005 18:28:27 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Tue, 15 Mar 2005 18:28:27 +0000 (UTC)
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!
newsread.com!news-xfer.newsread.com!postnews.google.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.compactframework:73280
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Thank you for the answer Ilya. Sorry I did not explained the
background of my problem. I need to send my local database(SqlCE) to a
remote server, my idea is to put every requested table in a xml file,
compress it and then send the compressed file(via http post). I going
to receive entrys to update my local database in the same way. Just
let me check if I got the right Fragment mode idea: there is a
ReadXml(XmlReader, XmlReadMode) overloaded method, using Read() from
XmlTextReader I may find the node with the dataset I want to read,
then pass the XmlTextReader(which is currently in the desired xml
dataset node) and XmlReadMode.Fragment to ReadXml() and then only that
dataset will be read?

(e-mail address removed) ("Ilya Tumanov [MS]") wrote in message
Click to expand...
 
Thank you for answering my questions :D
Ok, then I should load the tables to a single dataset and save that
dataset to XML, the resulting XML would be a valid XML(not malformed).
Using that, when I need to ReadXML(), would be necessary to do that
fragment mode implementation or I could just ReadXML() and then
dataadapter.Update() to update my database?

Yes, that's the idea of a Fragment mode - to allow loading of XML fragment.

Anyway, this approach makes little sense to me. The obvious solution would
be to load all tables into the DataSet and save it all to the XML.
Yes, data for all tables would be loaded into memory at once.
However, that's most likely irrelevant as XML size containing data for all
tables would be several times bigger than in memory data anyway.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: (e-mail address removed) (Sergio Rolanski)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Re: Multiple DataSets in one XML file
Date: 15 Mar 2005 10:28:26 -0800
Organization: http://groups.google.com
Lines: 61
Message-ID: <[email protected]>
References: <[email protected]>
Click to expand...
NNTP-Posting-Host: 200.138.40.128
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1110911307 6060 127.0.0.1 (15 Mar 2005 18:28:27 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Tue, 15 Mar 2005 18:28:27 +0000 (UTC)
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!
newsread.com!news-xfer.newsread.com!postnews.google.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.compactframework:73280
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Thank you for the answer Ilya. Sorry I did not explained the
background of my problem. I need to send my local database(SqlCE) to a
remote server, my idea is to put every requested table in a xml file,
compress it and then send the compressed file(via http post). I going
to receive entrys to update my local database in the same way. Just
let me check if I got the right Fragment mode idea: there is a
ReadXml(XmlReader, XmlReadMode) overloaded method, using Read() from
XmlTextReader I may find the node with the dataset I want to read,
then pass the XmlTextReader(which is currently in the desired xml
dataset node) and XmlReadMode.Fragment to ReadXml() and then only that
dataset will be read?

(e-mail address removed) ("Ilya Tumanov [MS]") wrote in message
Unless you're taking some special care of XML structure, writing several
data sets into one XML would result in malformed XML document.
If you're fixing XML manually, look into ReadXml() overloads with
XmlReadMode argument and XmlReadMode.Fragment mode.
Again, it's up to you to find the right data set start and invoke ReadXml()
on it.

I don't see any advantages of that compared to normal file per data set
solution.
In fact, I do see a major disadvantage which is the need to overwrite the
entire file should you change even one record in one data set.
So I would suggest you don't do it.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
From: (e-mail address removed) (Sergio Rolanski)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Multiple DataSets in one XML file
Date: 14 Mar 2005 13:23:55 -0800
Organization: http://groups.google.com
Lines: 7
Message-ID: <[email protected]>
NNTP-Posting-Host: 200.138.40.128
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1110835436 8429 127.0.0.1 (14 Mar 2005
21:23:56 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Mon, 14 Mar 2005 21:23:56 +0000 (UTC)
Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!news.glorb.com!postnews.google.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.compactframework:73213
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

It's very easy to DataSet.WriteXml() multiple dataset to a single xml
file, but when I want to DataSet.ReadXml() I don't know how to specify
whick dataset to read. Anybody knows if it's possible to have multiple
dataset in a single xml file?

Thanks,
Sergio V. R.
Click to expand...
Click to expand...
Click to expand...
 
Yes, it will be a valid XML. No need to do anything, just run ReadXml() on
the file and that's it.
If you want to preserve row states (which is a good idea if you're going to
update the data base), you can use diffgram format for XML.
Look into WriteXml() overload which takes XmlWriteMode argument which needs
to be set to XmlWriteMode.DiffGram.
Do not forget to load schema into the data set before loading data. Or, you
can include schema into the DiffGram.

Here's how:

http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compac
tframework/msg/036c4158cb9e6e3b

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: (e-mail address removed) (Sergio Rolanski)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Re: Multiple DataSets in one XML file
Date: 15 Mar 2005 14:52:46 -0800
Organization: http://groups.google.com
Lines: 116
Message-ID: <[email protected]>
References: <[email protected]>
Click to expand...
<[email protected]>
NNTP-Posting-Host: 200.138.40.128
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1110927167 27039 127.0.0.1 (15 Mar 2005 22:52:47 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Tue, 15 Mar 2005 22:52:47 +0000 (UTC)
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!news.glorb.com!postnews.google.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.compactframework:73303
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Thank you for answering my questions :D
Ok, then I should load the tables to a single dataset and save that
dataset to XML, the resulting XML would be a valid XML(not malformed).
Using that, when I need to ReadXML(), would be necessary to do that
fragment mode implementation or I could just ReadXML() and then
dataadapter.Update() to update my database?

(e-mail address removed) ("Ilya Tumanov [MS]") wrote in message
Yes, that's the idea of a Fragment mode - to allow loading of XML fragment.

Anyway, this approach makes little sense to me. The obvious solution would
be to load all tables into the DataSet and save it all to the XML.
Yes, data for all tables would be loaded into memory at once.
However, that's most likely irrelevant as XML size containing data for all
tables would be several times bigger than in memory data anyway.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: (e-mail address removed) (Sergio Rolanski)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Re: Multiple DataSets in one XML file
Date: 15 Mar 2005 10:28:26 -0800
Organization: http://groups.google.com
Lines: 61
Message-ID: <[email protected]>
References: <[email protected]>
Click to expand...
NNTP-Posting-Host: 200.138.40.128
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1110911307 6060 127.0.0.1 (15 Mar 2005 18:28:27 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Tue, 15 Mar 2005 18:28:27 +0000 (UTC)
Path:
Click to expand...
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!
newsread.com!news-xfer.newsread.com!postnews.google.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.compactframework:73280
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Thank you for the answer Ilya. Sorry I did not explained the
background of my problem. I need to send my local database(SqlCE) to a
remote server, my idea is to put every requested table in a xml file,
compress it and then send the compressed file(via http post). I going
to receive entrys to update my local database in the same way. Just
let me check if I got the right Fragment mode idea: there is a
ReadXml(XmlReader, XmlReadMode) overloaded method, using Read() from
XmlTextReader I may find the node with the dataset I want to read,
then pass the XmlTextReader(which is currently in the desired xml
dataset node) and XmlReadMode.Fragment to ReadXml() and then only that
dataset will be read?

(e-mail address removed) ("Ilya Tumanov [MS]") wrote in message
Click to expand...
Unless you're taking some special care of XML structure, writing several
data sets into one XML would result in malformed XML document.
If you're fixing XML manually, look into ReadXml() overloads with
XmlReadMode argument and XmlReadMode.Fragment mode.
Again, it's up to you to find the right data set start and invoke ReadXml()
on it.

I don't see any advantages of that compared to normal file per data set
solution.
In fact, I do see a major disadvantage which is the need to
Click to expand...
overwrite
the
entire file should you change even one record in one data set.
So I would suggest you don't do it.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
From: (e-mail address removed) (Sergio Rolanski)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Multiple DataSets in one XML file
Date: 14 Mar 2005 13:23:55 -0800
Organization: http://groups.google.com
Lines: 7
Message-ID: <[email protected]>
NNTP-Posting-Host: 200.138.40.128
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1110835436 8429 127.0.0.1 (14 Mar 2005
21:23:56 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Mon, 14 Mar 2005 21:23:56 +0000 (UTC)
Path:
Click to expand...
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00. sul.t-online.de!t-online.de!news.glorb.com!postnews.google.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.compactframework:73213
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

It's very easy to DataSet.WriteXml() multiple dataset to a single xml
file, but when I want to DataSet.ReadXml() I don't know how to specify
whick dataset to read. Anybody knows if it's possible to have multiple
dataset in a single xml file?

Thanks,
Sergio V. R.
Click to expand...
Click to expand...
Click to expand...
 
I write the dataset with mutiple tables with their schema(just like
the link to posted before). I wrote 3 tables to xml file, add an entry
in one of the tables, and change entrys in the others 2 tables. When I
read that file I get no error, but the database is no updated. The
commands are correctly generated, TableNames are ok,
dsResult.Tables.Rows.Count have the number of expected rows and also
the expected data.

public static string ReadXML(SqlCeConnection DbConn, XmlTextReader
xmlr)
{
string strResult="";
DataSet dsResult;

try
{
dsResult = new DataSet();
dsResult.ReadXml(xmlr, XmlReadMode.DiffGram);

SqlCeDataAdapter adapter;
SqlCeCommandBuilder bld;

foreach (DataTable table in dsResult.Tables)
{
adapter = new SqlCeDataAdapter("SELECT * FROM "+table.TableName,
DbConn);
bld = new SqlCeCommandBuilder(adapter);

adapter.UpdateCommand = bld.GetUpdateCommand();
adapter.DeleteCommand = bld.GetDeleteCommand();
adapter.InsertCommand = bld.GetInsertCommand();

adapter.Update(dsResult, table.TableName);
}
dsResult = null;
}
catch (SqlCeException ex)
{
strResult = MakeErrorMsg(ex);
}
catch (Exception ex)
{
strResult = ex.ToString();
}

return strResult;
}
 
Make sure you have changed/added/deleted rows in the data set (look at XML,
it has rowstate in it).
If not, update won't do anything. From your description you should not have
any changes as you add/change entries after file was written.
Also, make sure you have a primary key in data tables. Command builder
requires primary key in order to work.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: (e-mail address removed) (Sergio Rolanski)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Re: Multiple DataSets in one XML file
Date: 16 Mar 2005 12:38:47 -0800
Organization: http://groups.google.com
Lines: 68
Message-ID: <[email protected]>
References: <[email protected]>
Click to expand...
<[email protected]>
<[email protected]>
<[email protected]>
NNTP-Posting-Host: 200.138.42.69
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1111005528 29646 127.0.0.1 (16 Mar 2005 20:38:48 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Wed, 16 Mar 2005 20:38:48 +0000 (UTC)
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!
postnews.google.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.compactframework:73424
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I write the dataset with mutiple tables with their schema(just like
the link to posted before). I wrote 3 tables to xml file, add an entry
in one of the tables, and change entrys in the others 2 tables. When I
read that file I get no error, but the database is no updated. The
commands are correctly generated, TableNames are ok,
dsResult.Tables.Rows.Count have the number of expected rows and also
the expected data.

public static string ReadXML(SqlCeConnection DbConn, XmlTextReader
xmlr)
{
string strResult="";
DataSet dsResult;

try
{
dsResult = new DataSet();
dsResult.ReadXml(xmlr, XmlReadMode.DiffGram);

SqlCeDataAdapter adapter;
SqlCeCommandBuilder bld;

foreach (DataTable table in dsResult.Tables)
{
adapter = new SqlCeDataAdapter("SELECT * FROM "+table.TableName,
DbConn);
bld = new SqlCeCommandBuilder(adapter);

adapter.UpdateCommand = bld.GetUpdateCommand();
adapter.DeleteCommand = bld.GetDeleteCommand();
adapter.InsertCommand = bld.GetInsertCommand();

adapter.Update(dsResult, table.TableName);
}
dsResult = null;
}
catch (SqlCeException ex)
{
strResult = MakeErrorMsg(ex);
}
catch (Exception ex)
{
strResult = ex.ToString();
}

return strResult;
}

(e-mail address removed) ("Ilya Tumanov [MS]") wrote in message
Yes, it will be a valid XML. No need to do anything, just run ReadXml() on
the file and that's it.
If you want to preserve row states (which is a good idea if you're going to
update the data base), you can use diffgram format for XML.
Look into WriteXml() overload which takes XmlWriteMode argument which needs
to be set to XmlWriteMode.DiffGram.
Do not forget to load schema into the data set before loading data. Or, you
can include schema into the DiffGram.

Here's how:

http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compac
tframework/msg/036c4158cb9e6e3b

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no
Click to expand...
rights.
Click to expand...
 
I was changing the values in xmldata editor fo Visual Studio.NET, that
way the rowState were not set. Thanks for all the answer(and pacience)
Ilya.

Just for the records, the updated code is:

public static string ReadXML(SqlCeConnection DbConn, XmlTextReader
xmlr)
{
string strResult="";
DataSet dsResult;

try
{
dsResult = new DataSet();
dsResult.ReadXml(xmlr);

SqlCeDataAdapter adapter;
SqlCeCommandBuilder bld;
SqlCeTransaction trans=DbConn.BeginTransaction();
foreach (DataTable table in dsResult.Tables)
{
adapter = new SqlCeDataAdapter("SELECT * FROM "+table.TableName,
DbConn);
bld = new SqlCeCommandBuilder(adapter);

adapter.UpdateCommand = bld.GetUpdateCommand();
adapter.DeleteCommand = bld.GetDeleteCommand();
adapter.InsertCommand = bld.GetInsertCommand();

adapter.Update(dsResult, table.TableName);
}
trans.Commit();

dsResult = null;
}
catch (SqlCeException ex)
{
strResult = MakeErrorMsg(ex);
}
catch (Exception ex)
{
strResult = ex.ToString();
}

return strResult;
}

Make sure you have changed/added/deleted rows in the data set (look at XML,
it has rowstate in it).
If not, update won't do anything. From your description you should not have
any changes as you add/change entries after file was written.
Also, make sure you have a primary key in data tables. Command builder
requires primary key in order to work.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: (e-mail address removed) (Sergio Rolanski)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Re: Multiple DataSets in one XML file
Date: 16 Mar 2005 12:38:47 -0800
Organization: http://groups.google.com
Lines: 68
Message-ID: <[email protected]>
References: <[email protected]>
Click to expand...
<[email protected]>
<[email protected]>
<[email protected]>
NNTP-Posting-Host: 200.138.42.69
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1111005528 29646 127.0.0.1 (16 Mar 2005 20:38:48 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Wed, 16 Mar 2005 20:38:48 +0000 (UTC)
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!
postnews.google.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.compactframework:73424
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I write the dataset with mutiple tables with their schema(just like
the link to posted before). I wrote 3 tables to xml file, add an entry
in one of the tables, and change entrys in the others 2 tables. When I
read that file I get no error, but the database is no updated. The
commands are correctly generated, TableNames are ok,
dsResult.Tables.Rows.Count have the number of expected rows and also
the expected data.

public static string ReadXML(SqlCeConnection DbConn, XmlTextReader
xmlr)
{
string strResult="";
DataSet dsResult;

try
{
dsResult = new DataSet();
dsResult.ReadXml(xmlr, XmlReadMode.DiffGram);

SqlCeDataAdapter adapter;
SqlCeCommandBuilder bld;

foreach (DataTable table in dsResult.Tables)
{
adapter = new SqlCeDataAdapter("SELECT * FROM "+table.TableName,
DbConn);
bld = new SqlCeCommandBuilder(adapter);

adapter.UpdateCommand = bld.GetUpdateCommand();
adapter.DeleteCommand = bld.GetDeleteCommand();
adapter.InsertCommand = bld.GetInsertCommand();

adapter.Update(dsResult, table.TableName);
}
dsResult = null;
}
catch (SqlCeException ex)
{
strResult = MakeErrorMsg(ex);
}
catch (Exception ex)
{
strResult = ex.ToString();
}

return strResult;
}

(e-mail address removed) ("Ilya Tumanov [MS]") wrote in message
Yes, it will be a valid XML. No need to do anything, just run ReadXml() on
the file and that's it.
If you want to preserve row states (which is a good idea if you're going to
update the data base), you can use diffgram format for XML.
Look into WriteXml() overload which takes XmlWriteMode argument which needs
to be set to XmlWriteMode.DiffGram.
Do not forget to load schema into the data set before loading data. Or, you
can include schema into the DiffGram.

Here's how:

http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compac
tframework/msg/036c4158cb9e6e3b

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no
Click to expand...
rights.
Click to expand...
Click to expand...
 
Back
Top