Click here to Skip to main content
16,016,557 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
PkgContent     Total_Freight
  ASDFAF           3
  ASDFASF          3
  sssss            2
  ssss             7
  asfasdasdf       5
  afdssdf          5
  
  sum
  ---------------- 
  25 

this is the out put of Query:
=========================
SELECT  Content1, Total1
FROM       xyz
ORDER BY IDx DESC
COMPUTE SUM(Total1)

=========================

Problem: I am not able to Read the value of Sum that is '25' through ado.net

Help me....



thanks in advance...
Posted
Updated 1-Jul-10 21:47pm
v4
Comments
DaveAuld 27-Jun-10 6:32am    
Where do you want to store the value of the SUM operation to? back into the database, or pass is back to the application that executed the query?

1 solution

You will find the data in In the Second table of the datatable collection

VB
ds.Tables(1).Rows(0)(0)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900