473,387 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Summation of per Column in DBGrid

Hi Again,

I would like to know how to compute the sum of per Column on the DBGrid and place it on the textbox

DATABASE1
Table1
Column1 Column2
111 222
333 444
555 666
Feb 19 '11 #1
1 1930
DS.open "select sum(col1) as c1 , sum(col2) as c2 from tablename"
text1.text = DS!c1
text2.text = DS!c2
Feb 20 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Wilfried Mestdagh | last post by:
Hi, If you doubleclick on a dbgrid title separator the column automticly resize to his minumum width. How to do this in code ? -- rgds, Wilfried http://www.mestdagh.biz
0
by: basha | last post by:
hi friends, I am usieng Dbgrid in my asp.net project, my requirement is in dbgrid i am displaying 10 records per page and i place one button on a webform for each record i am generating one...
4
by: Doru Roman | last post by:
Hi, I write some code to retrieve information from Database. After I bind the DBGrid it shows the result somehow like a link to the Table. When I click on the Table link it displays the whole...
0
by: rowin | last post by:
Hi, How can I do the following? I have a DBGrid and I need to get values that grid. When I click on a cell in the grid, I need to get all values in the selected row. If for example there are 3...
3
by: nano9 | last post by:
Hola gente quisiera que alguien me pudiera ayudar con un problemilla que tengo, resulta que estoy programando en ASP con C# y estoy usando un cadbgrid que se comporta parecido a un datagrid o...
0
by: QBuildPete | last post by:
Hi, This is my first post. I hope someone can help. I have an app that uses DBGrid control (MS Data Bound Grid Control 5.0 (SP3)) with underlying data control. The problem is that the grid has...
0
by: Quadran | last post by:
Hello everybody, I am new here and therefore hope nothing doing wrong, I have a DBGrid in C++ Builder 6.0 containing 26 cells and 12 rows In each cell there is a number stored and this...
3
by: zorcetto | last post by:
hi.... plz help me i have table in database using access 2003 ,wanna make summation 2 column in it so 1-which type of data choose (microsoft data grid...or etc) 2- the code entering in sub...
25
by: Darsin | last post by:
Hi all I need to perform a summation on a column of a table based on a criteria given in another column in the same table. The catch is i need to perform different sums according to the number of...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.