Grid Challenge!!! -- asp.net datagrid control

Vai2000
6/20/2006 8:04:01 AM

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
6/27/2006 11:59:52 PM

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 :)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about asp.net datagrid control

asp.net datagrid control : Grid Challenge!!!