Grid Challenge!!!

Discussion in 'ASP .Net Datagrid Control' started by Vai2000, Jun 20, 2006.

  1. Vai2000

    Vai2000 Guest

    Hi All, Here's my query

    SELECT type, price, advance
    FROM titles
    WHERE type LIKE '%cook'
    ORDER BY type
    COMPUTE SUM(price)

    I need to bind the recordset to a grid View and show the SUM on a label.

    How do I go with it ?

    I am not coding a single line (that's the main part)...using Wizard to
    accomplish each task in asp.net 2.0

    TIA
    Vai2000, Jun 20, 2006
    #1
    1. Advertising

  2. Vai2000

    John Prado Guest

    select type, price, advance, sum(prices) as total ...

    use the total column to get the sum of prices (it will be there for
    every row but i think that it dont will bother you :)


    Vai2000 wrote:
    > Hi All, Here's my query
    >
    > SELECT type, price, advance
    > FROM titles
    > WHERE type LIKE '%cook'
    > ORDER BY type
    > COMPUTE SUM(price)
    >
    > I need to bind the recordset to a grid View and show the SUM on a label.
    >
    > How do I go with it ?
    >
    > I am not coding a single line (that's the main part)...using Wizard to
    > accomplish each task in asp.net 2.0
    >
    > TIA
    >
    >
    John Prado, Jun 28, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Girish
    Replies:
    4
    Views:
    667
    Patrick.O.Ige
    Jul 19, 2005
  2. =?Utf-8?B?QXNzYW5LaGFuIElzbWFpbA==?=

    How to transfer a value from an Invisible Grid to an visible Grid

    =?Utf-8?B?QXNzYW5LaGFuIElzbWFpbA==?=, Oct 13, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    463
    =?Utf-8?B?QXNzYW5LaGFuIElzbWFpbA==?=
    Oct 17, 2005
  3. Danny Tuppeny

    Grouped grid? Or grid within datalist?

    Danny Tuppeny, Oct 27, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    494
    =?Utf-8?B?UGhpbGxpcCBXaWxsaWFtcw==?=
    Oct 27, 2005
  4. Vai2000

    Grid Challenge!!

    Vai2000, Jun 22, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    296
    Vai2000
    Jun 22, 2006
  5. Marc
    Replies:
    0
    Views:
    450
Loading...

Share This Page