473,373 Members | 1,394 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,373 software developers and data experts.

Calculating the total of a column in a data grid: Master/detail

Help - Calculating the total of a column in a data grid --
when data grid is part of Master-Detail set-up

I have setup a Master-Detail form using Visual
Studio.Net. A ListBox is the (Master) and contains a list
of dates. The data grid (Details portion) contains the
details for a selected date (namely, a list of work codes
and hours spent).

I am trying to total the number of hours in the datagrid
(for the selected date (master)).

I tried looping through the data grid using 0 to
the 'VisibleRowCount' of the data grid. It worked fine,
until I discovered that it truly is counting only the rows
that the user sees in the data grid. (I guess that is
what they meant by 'VisibleRowCount').
Anyway, how do I go about summing up the total number of
hours (in my detail data grid), when the user clicks on
a particular date in my list box (Master).?
Thanks Much --- New to Visual Studio.Net
Nov 20 '05 #1
0 1983

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: The Bit Bandit | last post by:
Hopefully someone can help me create a query that I'm having some trouble with. I have three tables: invoices, invoicedetails, invoicepayments The fields are: invoices -------- InvoiceNo
1
by: Megan | last post by:
quick summary: i'm having problems trying to group fields in a report in order to calculate percentages. to calculate percentages, i'm comparing the results from my grouped fields to the totals....
5
by: keith | last post by:
This may seem simple, but I'm having a bit of trouble figuring out exactly how to do it. I'm accessing a database through an ODBC link, and I have a query that returns only jobs completed that day...
2
by: Christopher Weaver | last post by:
I have a DataSet with two tables and a DataRelation. When I populate the DataSet and define a master detail relationship through the DataRelation, the grid bound to the master table shows both...
1
by: TENZEEL. | last post by:
Hello All. I want to reperesent the Master and Child data in Data Grid in Asp.net. In Master Data row it only shows the key value. and in detail after the master row it shows the value againt...
0
by: HS1 | last post by:
Hello I created a master and a detail table using 2 dataGrids for Client and Jobs tables with a relationship With the detail grid, I create some textboxes to present a record of Jobs table...
1
by: HS1 | last post by:
Hello all - I have a master and a details table presented in two datagrid - I also have some text boxes that present the values from any record in the master table. This also helps to enter new...
8
by: Doug Bell | last post by:
Hi, I need to create a function that will return the number of columns in a passed reference to a DataView. I can find the number of columns in its underlying Data table but have not been...
4
by: =?Utf-8?B?QW1pciBUb2hpZGk=?= | last post by:
Hi I have a GridView that is displaying master records. Some of these records have child records. I would like to a column to my master GridView such that for each master record that has...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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: 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?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.