Professional Web Applications Themes

ADO - Recordset - ASP Database

I was wondering if anyone can help me. I've converting an already existing system (designed in Access which produces reports for the accounts dept) over to a web based system. The Access atabase has been transfered to a SQL database and I've designed a number of stored procedures to extract information from the database for reports. I have created a web application with a logon page to gain access to the system and a main page with a form on it to pass in parameters and run the stored procedures. When I click on the submit buttons on the main ...

  1. #1

    Default ADO - Recordset

    I was wondering if anyone can help me. I've converting an already existing system (designed in Access which produces reports for the accounts dept) over to a web based system. The Access atabase has been transfered to a SQL database and I've designed a number of stored procedures to extract information from the database for reports. I have created a web application with a logon page to gain access to the system and a main page with a form on it to pass in parameters and run the stored procedures. When I click on the submit buttons on the main page it redirects to a seperate page for each report and the results are coming back in a html table

    I've had a lot of help from you guys and I've managed to get on well so far (thank you all so much). My final problems remaining are using the results-set to Sum the contents of certain fields, group by and order fields etc. I need to do things similar to what is done in Access when you go to design a report

    To give you an idea of how the results come back you can run this table in a browser:
    I need to be able to only select certain fields and sum them up, group them by Paper Name etc. Does anyone know how I can do this with my record set. Or should I try and group by, order by and make calculations as part of my stored procedure before I access it
    Thank you very much for any help you may be able to give me

    <table border=1 width="100%"><tr><td>Belfast Telegraph</td><td>0.375</td><td>75</td><td>7</td><td>64</td><td>1/4/2004</td><td>3</td><td>24</td><td>1</td><td>95506N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Belfast Telegraph</td><td>0.375</td><td>71</td><td>7</td><td>64</td><td>1/4/2004</td><td>3</td><td>24</td><td>1</td><td>95506N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Sunday Life</td><td>0.31</td><td>18</td><td>0</td><td>18</td><td>1/4/2004</td><td>7</td><td>5.58</td><td>1</td><td>96601N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>City</td></tr><tr><td>Belfast Telegraph</td><td>0.3313</td><td>325</td><td>116</td><td>209</td><td>1/4/2004</td><td>5</td><td>69.2417</td><td>1</td><td>96120N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>NorthWest</td></tr><tr><td>Adds for Free</td><td>0.375</td><td>100</td><td>63</td><td>37</td><td>1/4/2004</td><td>4</td><td>13.875</td><td>1</td><td>95105N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Belfast Telegraph</td><td>0.375</td><td>9</td><td>0</td><td>9</td><td>1/4/2004</td><td>4</td><td>3.375</td><td>1</td><td>94406N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr></table><table border=1 width="100%"><tr><td>Belfast Telegraph</td><td>0.375</td><td>75</td><td>7</td><td>64</td><td>1/4/2004</td><td>3</td><td>24</td><td>1</td><td>95506N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Belfast Telegraph</td><td>0.375</td><td>71</td><td>7</td><td>64</td><td>1/4/2004</td><td>3</td><td>24</td><td>1</td><td>95506N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Sunday Life</td><td>0.31</td><td>18</td><td>0</td><td>18</td><td>1/4/2004</td><td>7</td><td>5.58</td><td>1</td><td>96601N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>City</td></tr><tr><td>Belfast Telegraph</td><td>0.3313</td><td>325</td><td>116</td><td>209</td><td>1/4/2004</td><td>5</td><td>69.2417</td><td>1</td><td>96120N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>NorthWest</td></tr><tr><td>Adds for Free</td><td>0.375</td><td>100</td><td>63</td><td>37</td><td>1/4/2004</td><td>4</td><td>13.875</td><td>1</td><td>95105N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Belfast Telegraph</td><td>0.375</td><td>9</td><td>0</td><td>9</td><td>1/4/2004</td><td>4</td><td>3.375</td><td>1</td><td>94406N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr></table>
    Michael Guest

  2. #2

    Default Re: ADO - Recordset

    Michael wrote:
    > To give you an idea of how the results come back you can run this
    > table in a browser:
    > I need to be able to only select certain fields and sum them up,
    > group them by Paper Name etc. Does anyone know how I can do this
    > with my record set. Or should I try and group by, order by and make
    > calculations as part of my stored procedure before I access it.
    > Thank you very much for any help you may be able to give me.

    You may want to look into using Crystal Reports. if this is an option for
    you, I don't want to take a lot of time describing how to use asp to do what
    you want. So I await your reply.

    Bob Barrows

    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Barrows Guest

  3. #3

    Default Re: ADO - Recordset

    I'll not be able to use Crystal reports as its not an option for me here on my placement. Sorry its taken so long to reply but I finish work at 5pm UK time. I would really appreciate it if you could help him complete this task in ASP
    Stephen Cairns Guest

Similar Threads

  1. RECORDSET
    By NAIME ESTEVES in forum ASP.NET
    Replies: 10
    Last Post: February 21st, 03:52 PM
  2. ASP Recordset Help!
    By longsdale in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 31st, 09:37 PM
  3. Using a Recordset
    By John Cowen in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 17th, 12:16 AM
  4. Replies: 8
    Last Post: September 24th, 11:07 AM
  5. => Recordset value in ADO
    By Rhonda Fischer in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 11th, 01:44 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139