Post reply

Output to a Web Page

  • April 20, 2006 at 3:57 am

    #152922

    Hi,

    I wish to export data using a query to present information to a web page. I would be grateful if someone could point me in the right direction on how I would go about doing this in the most efficient manner.

    Thankyou,

     

     

    Kindest Regards,

    Nick

  • April 20, 2006 at 6:41 am

    #633234

    That's a pretty huge topic. Entire books are written on getting information from a query to a web page, based on different scenarios.

    Most methods involve some use of ASP pages and ADO. Look for a good ASP.NET book, and that should get you started.

    Another tool to look into is SQL Reporting Services. This is like Crystal Reports, done by Microsoft. Last I checked, you can install a copy for free on the same server as your SQL Server. (Yes, running web services on your database server is not exactly brilliant, but it is free.) This will generate reports and display them as web pages. It has the advantage of doing a lot of the heavy lifting with wizards (and has a lot of nice reporting tools, but those are probably superfluous to your needs).

  • April 20, 2006 at 10:26 am

    #633317

    You can also take a look into using XML templates to present query results through the SQLXML IIS plugin.  Query + FOR XML + XSLT = web page

    Marshall's suggestion of Reporting Services is where I'd start, though.

    -Eddie

    Eddie Wuerch
    MCM: SQL

  • April 20, 2006 at 11:56 am

    #633335

    Also search Books Online for sp_makewebtask



    Michelle

  • April 20, 2006 at 12:09 pm

    #633343

    What language are you using for yor web development. I do this all the time with php/ado but like others have said it's a pretty broad subject.

     

     

  • April 21, 2006 at 5:10 am

    #633458

    QueryToDoc (http://www.schematodoc.com) will output a query result to a Word document. Word then has an export feature that will export the results to html.

  • April 21, 2006 at 5:44 am

    #633465

    Mate...if ur using asp.net...then you have the following options...

    aspataGrid

    asp:Repeater

    aspataList

    ... Well you ll have to use SqlDataReader or DataSet from your programming language...example C#

    hope this helps..

    Thanks

    Riyaz

  • April 21, 2006 at 5:45 am

    #633466

    hey i donno wat happ above..it was aspdatagrid...aspdatalist

    Cheers

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply