Working with XML files

[Ferrari, Eduardo]

Hi all!

I have a XML file that is read by a C# program.
The file looks like this:

<EMailList>
<email>ed*************@misys.com</email>
</EMailList>
<EMailList>
<email>ro***********@misys.com</email>
</EMailList>

But I want that this file look like this:

<EMailList>
<email>ed*************@misys.com</email>
<email>ro***********@misys.com</email>
</EMailList>

But, when I do that my program blows up.

The code to read the file is that:

public class COpicsXMLOperations
{

#region XMLConfigFile
static public DataSet dsOpicsSystemBuilder;
static public DataSet dsOpicsSBUsers;
#endregion

static public DataSet DS_OpicsSystemBuilder
{
get
{
if (dsOpicsSystemBuilder==null)
{
dsOpicsSystemBuilder = new DataSet();

// Creating EMailList table
DataTable dtEMailList = new DataTable("EMailList");
DataColumn dcEMail = new DataColumn("email");
dtEMailList.Columns.Add(dcEMail);
dsOpicsSystemBuilder.Tables.Add(dtEMailList);
}
return dsOpicsSystemBuilder;
}
}

private void FrmProcParam_Load(object sender, System.EventArgs e)
{
// Clear the list to avoid duplicates
clb_EMails.Items.Clear();
this.txt_Emails.Focus();

// Read the e-mails against the XML file
COpicsXMLOperations.DS_OpicsSystemBuilder.Tables.C lear();
COpicsXMLOperations.DS_OpicsSystemBuilder.ReadXml( "OpicsSystemBuilder.xml");
This is the line that blows up.

The error is:

An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll

Additional information: Cannot remove a table that has existing relations.
Remove relations first.

The program '[2304] OpicsSystemBuilder.exe' has exited with code 0 (0x0).

Anybody can help me with this?

Thanks!

Eduardo

--
Eduardo de Morais Ferrari
Misys'' OPICS Project
Stefanini IT Solutions
White Plains, NY
Phone: [phone]
Cell: [phone]
ed*************@misys.com

[Tim_Mac]

hi Eduardo,
did you try clearing the relations as the error suggested?
somewhere along the way, a relation must be created between tables in the
dataset. the first version of your xml file includes multiple tables, this
could be the reason for a relation being inferred unless you created them
yourself. you could debug before the error happens and examine the
Dataset.Relations property to see what kind of relation exists.

hope this helps
tim
--------------------------
blog: http://tim.mackey.ie
"Ferrari, Eduardo" <ed*************@misys.com> wrote in message
news:72**********************************@microsof t.com...

Hi all!

I have a XML file that is read by a C# program.
The file looks like this:

<EMailList>
<email>ed*************@misys.com</email>
</EMailList>
<EMailList>
<email>ro***********@misys.com</email>
</EMailList>

But I want that this file look like this:

<EMailList>
<email>ed*************@misys.com</email>
<email>ro***********@misys.com</email>
</EMailList>

But, when I do that my program blows up.

The code to read the file is that:

public class COpicsXMLOperations
{

#region XMLConfigFile
static public DataSet dsOpicsSystemBuilder;
static public DataSet dsOpicsSBUsers;
#endregion

static public DataSet DS_OpicsSystemBuilder
{
get
{
if (dsOpicsSystemBuilder==null)
{
dsOpicsSystemBuilder = new DataSet();

// Creating EMailList table
DataTable dtEMailList = new DataTable("EMailList");
DataColumn dcEMail = new DataColumn("email");
dtEMailList.Columns.Add(dcEMail);
dsOpicsSystemBuilder.Tables.Add(dtEMailList);
}
return dsOpicsSystemBuilder;
}
}

private void FrmProcParam_Load(object sender, System.EventArgs e)
{
// Clear the list to avoid duplicates
clb_EMails.Items.Clear();
this.txt_Emails.Focus();

// Read the e-mails against the XML file
COpicsXMLOperations.DS_OpicsSystemBuilder.Tables.C lear();
COpicsXMLOperations.DS_OpicsSystemBuilder.ReadXml( "OpicsSystemBuilder.xml");
This is the line that blows up.

The error is:

An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll

Additional information: Cannot remove a table that has existing relations.
Remove relations first.

The program '[2304] OpicsSystemBuilder.exe' has exited with code 0 (0x0).

Anybody can help me with this?

Thanks!

Eduardo

--
Eduardo de Morais Ferrari
Misys'' OPICS Project
Stefanini IT Solutions
White Plains, NY
Phone: [phone]
Cell: [phone]
ed*************@misys.com

[Ferrari, Eduardo]

Hi Tim!

Yes, I did. And I did not set any relations on this table.

Eduardo
--
Eduardo de Morais Ferrari
Misys'''''''' OPICS Project
Stefanini IT Solutions
White Plains, NY
Phone: [phone]
Cell: [phone]
ed*************@misys.com
"Tim_Mac" wrote:

hi Eduardo,
did you try clearing the relations as the error suggested?
somewhere along the way, a relation must be created between tables in the
dataset. the first version of your xml file includes multiple tables, this
could be the reason for a relation being inferred unless you created them
yourself. you could debug before the error happens and examine the
Dataset.Relations property to see what kind of relation exists.

hope this helps
tim
--------------------------
blog: http://tim.mackey.ie
"Ferrari, Eduardo" <ed*************@misys.com> wrote in message
news:72**********************************@microsof t.com...

Hi all!

I have a XML file that is read by a C# program.
The file looks like this:

<EMailList>
<email>ed*************@misys.com</email>
</EMailList>
<EMailList>
<email>ro***********@misys.com</email>
</EMailList>

But I want that this file look like this:

<EMailList>
<email>ed*************@misys.com</email>
<email>ro***********@misys.com</email>
</EMailList>

But, when I do that my program blows up.

The code to read the file is that:

public class COpicsXMLOperations
{

#region XMLConfigFile
static public DataSet dsOpicsSystemBuilder;
static public DataSet dsOpicsSBUsers;
#endregion

static public DataSet DS_OpicsSystemBuilder
{
get
{
if (dsOpicsSystemBuilder==null)
{
dsOpicsSystemBuilder = new DataSet();

// Creating EMailList table
DataTable dtEMailList = new DataTable("EMailList");
DataColumn dcEMail = new DataColumn("email");
dtEMailList.Columns.Add(dcEMail);
dsOpicsSystemBuilder.Tables.Add(dtEMailList);
}
return dsOpicsSystemBuilder;
}
}

private void FrmProcParam_Load(object sender, System.EventArgs e)
{
// Clear the list to avoid duplicates
clb_EMails.Items.Clear();
this.txt_Emails.Focus();

// Read the e-mails against the XML file
COpicsXMLOperations.DS_OpicsSystemBuilder.Tables.C lear();
COpicsXMLOperations.DS_OpicsSystemBuilder.ReadXml( "OpicsSystemBuilder.xml");
This is the line that blows up.

The error is:

An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll

Additional information: Cannot remove a table that has existing relations.
Remove relations first.

The program '[2304] OpicsSystemBuilder.exe' has exited with code 0 (0x0).

Anybody can help me with this?

Thanks!

Eduardo

--
Eduardo de Morais Ferrari
Misys'' OPICS Project
Stefanini IT Solutions
White Plains, NY
Phone: [phone]
Cell: [phone]
ed*************@misys.com