MSHFlexGrid: Get Total for Rows and Columns
Dear VB Pros and Friends:
Questions about MSHFlexGrid:
adoRSAnalysis as ADODB.Recordset and it has 5 fields, each is assigned to
mshflexgrid from column 1 to 5.
Column 1 is the ItemName, Columns 2 to 5 are the numbers (US $ currency),
and Column 6 is the total for columns 2 to 5.
Question 1: how to polulate the adoRSAnalysis¡¯s result into the mshflexgrid?
Question 2: How to get the row total and show it on column 6?
Question 3: how to get the total for columns 2 to 5 on the last row (let¡¯s
say, there are 20 records).
Question 4: how to format ALL numbers in US currency like Format(.Text, ¡°$#,###,###.00¡±)
They results should look like this:
ItemName Column1 ... Column5 Total
ItemName1 $56.50 $220.52
Total $678.90 $2,555.83
Column 6 and the last row with ¡°Total¡± are the run-time results.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL