Export result of a query made in a stored procedure to an excel file and use it for an asp


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Export result of a query made in a stored procedure to an excel file and use it for an asp

  1. #1
    Hamed Guest

    Export result of a query made in a stored procedure to an excel file and use it for an asp

    Hello

    I want to write a stored procedure in SQL Server that gets two parameters and
    makes a query based on the parameters, then exports the result to an Excel file,
    make a graph from it by automation techniques and use the image of graph in my
    asp result. Is this task possible in SQL Server 2000 ? How ?

    Is there any better/more simple solution to make the graph from the database?

    Thanks in advance

    Hamed...




  2. #2
    Q*bert Guest

    Re: Export result of a query made in a stored procedure to an excel file and use it for an asp



    You could consider using a third party charting tool and directly access
    the data in the database via ASP and write code to process the recordset
    results providing enough info to the tool so it could chart. An example
    of a third party tool would be like those found at www.objectplanet.com or
    those provided through crystal reports. But your probably after a no expense
    solution; if that's the case, I'd research through www.Google.com to see
    if there are any freeware charting javascripts out there that met my need.

    If your stuck with the Excel Option, You can use ASP to query the database,
    and make updates to the cells within Excel by instancing a version of Excel
    through ASP using automation to update it then saving the Excel file as an
    HTML document and redirecting to the document you created.

    Personally I like using www.objectplanet.com tools for charting. They are
    easy to use, pretty inexpensive and provide lots of cool functions.

    Cheers,
    Q*bert
    "Hamed" <hamedarab@hotmail.com> wrote:
    >Hello
    >
    >I want to write a stored procedure in SQL Server that gets two parameters

    and
    >makes a query based on the parameters, then exports the result to an Excel

    file,
    >make a graph from it by automation techniques and use the image of graph

    in my
    >asp result. Is this task possible in SQL Server 2000 ? How ?
    >
    >Is there any better/more simple solution to make the graph from the database?
    >
    >Thanks in advance
    >
    >Hamed...
    >
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center