Re: SQL to XML

Matt Faus — Sun, 06 May 2007 03:47:16 GMT

Hi gwk2bust,

If you can get all of the projects to load, it looks like you have gotten everything. Can you please elaborate here?

SQL to XML

gw2kbust — Tue, 01 Aug 2006 01:21:27 GMT

I have an XML as a secondary datasource. It is populated like this:

<QueryProject>
<Projects>
<ResourceID></ResourceID>
<ActivityID></ActivityID>
<ProjectID></ProjectID>
<Comments></Comments>
<QueryDates>
<ActivityDate></ActivityDate>
<ActivityHours></ActivityHours>
</QueryDates>
<QueryDates>
<ActivityDate></ActivityDate>
<ActivityHours></ActivityHours>
</QueryDates>
</Projects>
<Projects>
<ResourceID></ResourceID>
<ActivityID></ActivityID>
<ProjectID></ProjectID>
<Comments></Comments>
<QueryDates>
<ActivityDate></ActivityDate>
<ActivityHours></ActivityHours>
</QueryDates>
<QueryDates>
<ActivityDate></ActivityDate>
<ActivityHours></ActivityHours>
</QueryDates>
</Projects>
</QueryProject>

I have a SELECT statement in my c# code which grabs the available information from the database. Now, I need to populate the correct fields. I'm not that good of a programmer but I do know the basics. Currently I have a dataset being made which is then filled and then written using an isolatedstoragefilestream. The XML is then loaded back into the DOM. I can only get the Projects to load though. How do I get all the information? Thanks for your help.

General

Re: SQL to XML

SQL to XML