How to Populate DataSet With XML Derived Schema?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FerrisUML - 28 Sep 2007 02:58 GMT

Im trying to populate a dataset that has a loaded xml schema
(dataset.readxmlschema("file.xsd")) with data from a sql query. I've
tried to map the columns of my result set to the tables of my dataset,
but got an error that tables cannot share a source table. Anyone have
any ideas how to best approach this problem?

Reply to this Message

John Saunders [MVP] - 28 Sep 2007 04:50 GMT

> Im trying to populate a dataset that has a loaded xml schema
> (dataset.readxmlschema("file.xsd")) with data from a sql query. I've
> tried to map the columns of my result set to the tables of my dataset,
> but got an error that tables cannot share a source table. Anyone have
> any ideas how to best approach this problem?

Please post the entire exception, including any InnerException values. One
way to do this is:

try
{
// do something here
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}

Signature

--------------------------------------------------------------------------------
John Saunders | MVP - Windows Server System - Connected System Developer

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...