SQL to XML - InfoPath Dev
in

InfoPath Dev

SQL to XML

Last post 05-05-2007 08:47 PM by Matt Faus. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-31-2006 06:21 PM

    SQL to XML

    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.
  • 05-05-2007 08:47 PM In reply to

    Hi gwk2bust,

    If you can get all of the projects to load, it looks like you have gotten everything. Can you please elaborate here?
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.