Results 1 to 2 of 2

Thread: Query SQL Server (MSDE 2000), Results In Xml?

  1. Jan 8th, 2005, 12:02 AM #1
    <ABX
    <ABX is offline

    Thread Starter
    Frenzied Member <ABX's Avatar
    Join Date
    Jul 2002
    Location
    Canada eh...
    Posts
    1,622

    Query SQL Server (MSDE 2000), Results In Xml?

    Is it possible to execute Stored Procedures from vb .net and return xml?

    I cannot modifiy the sp's to add the "FOR XML..." statement. (not my call)

    I tried serializing the dataset but would not work because some of the content in the database contains formatting (x/html) and it is automatically escaped.

    Any ideas?
    Tips:
    • Google is your friend! Search before posting!
    • Name your thread appropriately... "I Need Help" doesn't cut it!
    • Always post your code!!!! We can't read your mind!!! (well, at least most of us!)
    • Allways Include the Name and Line of the Exception (if one is occuring!)
    • If it is relevant state the version of Visual Studio/.Net Framwork you are using (2002/2003/2005)


    If you think I was helpful, rate my post
    IRC Contact: Rizon/xous ChakraNET/xous Freenode/xous
    Reply With Quote Reply With Quote
  2. Jan 8th, 2005, 07:17 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Query SQL Server (MSDE 2000), Results In Xml?

    You mentioned serializing, but did you try dataset.WriteXml()?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width