Why are these tables not adding

[Chris]

Hi,
I am trying to load 3 xml files into one dataset like

dsXML.ReadXml(Server.MapPath("file1.xml")
dsXML.ReadXml(Server.MapPath("file2.xml"))
dsXML.ReadXml(Server.MapPath("file3.xml"))

I am then trying to display each files in separate datagrid

datagrid1.datasource = dsXml.tables(0)
datagrid1.datasource = dsxml.databind

datagrid2.datasource = dsXml.tables(1).columns(1).toString
datagrid2.datasource = dsxml.databind

datagrid3.datasource = dsXml.tables(2).columns(1).toString
datagrid3.datasource = dsxml.databind

I am getting the error

Cannot find table 1.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Cannot find table 1.

Is this possible.

Thanks

[Lucas Tam]

"=?Utf-8?B?Q2hyaXM=?=" <Ch***@discussions.microsoft.com> wrote in
news:01**********************************@microsof t.com:

I am trying to load 3 xml files into one dataset like

dsXML.ReadXml(Server.MapPath("file1.xml")
dsXML.ReadXml(Server.MapPath("file2.xml"))
dsXML.ReadXml(Server.MapPath("file3.xml"))

I am then trying to display each files in separate datagrid

datagrid1.datasource = dsXml.tables(0)
datagrid1.datasource = dsxml.databind

datagrid2.datasource = dsXml.tables(1).columns(1).toString
datagrid2.datasource = dsxml.databind

datagrid3.datasource = dsXml.tables(2).columns(1).toString
datagrid3.datasource = dsxml.databind

I am getting the error

Cannot find table 1.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Cannot find table
1.

I think you're getting this error because ReadXML only creates 1 Dataset
based on one XML file. It won't create multiple tables for you. You'll
need to explicitly load each table.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Chris]

Hi,
Does that mean I need separate datasets?

"Lucas Tam" wrote:

"=?Utf-8?B?Q2hyaXM=?=" <Ch***@discussions.microsoft.com> wrote in
news:01**********************************@microsof t.com:

I am trying to load 3 xml files into one dataset like

dsXML.ReadXml(Server.MapPath("file1.xml")
dsXML.ReadXml(Server.MapPath("file2.xml"))
dsXML.ReadXml(Server.MapPath("file3.xml"))

I am then trying to display each files in separate datagrid

datagrid1.datasource = dsXml.tables(0)
datagrid1.datasource = dsxml.databind

datagrid2.datasource = dsXml.tables(1).columns(1).toString
datagrid2.datasource = dsxml.databind

datagrid3.datasource = dsXml.tables(2).columns(1).toString
datagrid3.datasource = dsxml.databind

I am getting the error

Cannot find table 1.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Cannot find table
1.

I think you're getting this error because ReadXML only creates 1 Dataset
based on one XML file. It won't create multiple tables for you. You'll
need to explicitly load each table.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"=?Utf-8?B?Q2hyaXM=?=" <Ch***@discussions.microsoft.com> wrote in
news:5A**********************************@microsof t.com:

Hi,
Does that mean I need separate datasets?

Yes, basically your xml only defines one dataset.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/