Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TableAdapter and sql server generated xml

Status
Not open for further replies.

simonchristieis

Programmer
Jan 10, 2002
1,144
GB
I have a stored proc that returns xml data (for xml explicit), and I am tring to get to that data using the auto-generated table adapters through the gui (vs2k5).

Code:
   private void LoadData()
    {
        // _aadt = data table
        // _aata = table adapters 
        _aadt = _aata.GetInformation(2);


        foreach (Test.InfoRow r in _aadt)
        {

            // load xml from database
            XmlTextReader xml = new XmlTextReader(r._XML_F52E2B61_18A1_11d1_B105_00805F49916B);

         }


The only option that I have to access data is the _XML.... string and that errors with:

Exception Details: System.ArgumentException: Illegal characters in path.


Has anyone done this before, any pointers for me ?

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top