DataSet loses tablenames

[wervis]

I have a created a dataset with several tables. When i do a dataset.dataSet.WriteXml tablenames get lost. For example:

<?xml version="1.0" standalone="yes"?>
<Root>
<person />
<person />
<person />
<company />
<company />

should be:

<?xml version="1.0" standalone="yes"?>
<Root>
<persons>
<person />
<person />
<person />
</persons>
<companys>
<company />
<company />
</companys>

Can anybody tell me what goes wrong?

[Ganon11]

Are you writing this in C++? Should this be moved to the XML forum?

If you are writing something in C++, post the relevant code and we can try to 'debug' it.

[wervis]

I am writing this in C#. The C# DataSet has different tables. But the undelying XML has no table names.

Here is the code:

DataSet dataSet = new DataSet();
 
OdbcConnection odbcConnection = new OdbcConnection();
odbcConnection.ConnectionString = ConfigurationManager.ConnectionStrings["database"].ConnectionString;
OdbcCommand odbcCommand = new OdbcCommand();
 
try
{
odbcConnection.Open();
 
                foreach (WorkSheet worksheet in worksheets)
                {
                    odbcCommand.CommandText = worksheet.Query;
                    odbcCommand.Connection = odbcConnection;
                    OdbcDataAdapter odbcDataAdapter = new OdbcDataAdapter(odbcCommand);
                    odbcDataAdapter.Fill(dataSet, worksheet.WorkSheetName);
                }
            }
            catch (Exception exception)
            {
                LoggingService.HandleWervisException(LogComponent.DuchenneHeroesBeheer, LogEvent.BeheerCreateParticipantWorkSheet, exception, false);
            }
            finally
            {
                odbcConnection.Close();
            }
 
string folder = Server.MapPath(@"Download");
dataSet.WriteXml(folder + @"\export.xml");