Hello,

There is a space(as a data) in one of the columns. And i save my DataTable
as a xml file using DataSet. I used DataSet.WriteXml method to save as a xml
file. Now if I read that .xml file using DataSet.ReadXml method,it removes
space in that DataTable. Any idea...?


This does not work in Visual Studio .NET 2003. If I execute this in VS .Net
2005, it works. I must make it work in VS 2003.

Here there is a sample that does not work in VS NET 2003:
__________________________________________________ ______________________________

DataTable dbTable = new DataTable();
dbTable.Columns.Add(new DataColumn("MyColumn1",
Type.GetType("System.String")));

DataRow dbRow = dbTable.NewRow();
dbRow["MyColumn1"] = " ";
dbTable.Rows.Add(dbRow);

Console.WriteLine("Value = " + dbTable.Rows[0][0]);

DataSet dbSet = new DataSet();
dbSet.Tables.Add(dbTable);
dbSet.WriteXml("C:\\MyFile.xml", XmlWriteMode.WriteSchema);

dbRow = null;
dbTable = null;
dbSet = null;

DataSet dbReadSet = new DataSet();
dbReadSet.ReadXml("C:\\MyFile.xml", XmlReadMode.Auto);

Console.WriteLine("Value = " + dbReadSet.Tables[0].Rows[0][0]);

dbReadSet = null;
--------------------------------------