Accessing DataGridview columns
I have a datagridview that i want to capture two of the columns and use in a calculation. When the datagridview is populated it has 4 columns. I want to
capture the contents of the 3rd and 4th columns.
When I try, I get errors. I seriously need help. Below is a copy of the code:
Dim R As Integer
Dim total As Decimal
For R = 0 To Details1.Tables(0).Rows.Count - 1
total = total + CDec(DataGrid.Item(R, 2)) * CDec(DataGrid.Item(R, 3))
Next
txtTotal.Text = total.ToString("$##.00")
capture the contents of the 3rd and 4th columns.
When I try, I get errors. I seriously need help. Below is a copy of the code:
Dim R As Integer
Dim total As Decimal
For R = 0 To Details1.Tables(0).Rows.Count - 1
total = total + CDec(DataGrid.Item(R, 2)) * CDec(DataGrid.Item(R, 3))
Next
txtTotal.Text = total.ToString("$##.00")
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- 140.8K All Categories
- 103.6K Programming Languages
- 6.4K Assembler Developer
- 401 Assembly Code Share
- 239 Getting started in assembly
- 4.6K x86 Assembly
- 1.9K Basic
- 97 Qbasic
- 39.9K C and C++
- 5.6K Beginner C/C++
- 330 C/C++ on Linux/Unix
- 450 C/C++ Windows API
- 522 C++ Builder
- 253 C++ Game Development
- 3.3K C++ MFC
- 103 C++.NET
- 404 Visual C++
- 2.9K C#
- 7.9K Delphi and Kylix
- 334 Advanced Delphi
- 360 Delphi beginners
- 4 Haskell
- 9.7K Java
- 56 Enterprise JavaBeans
- 1.3K Java Beginners
- 304 Java Server Pages
- 4.1K Pascal
- 1.3K Perl
- 11 Perl 6
- 2K PHP
- 546 Python
- 37 Ruby
- 4.4K VB.NET
- 258 Advanced VB.Net
- 1.6K VBA
- 20.8K Visual Basic
- 767 Access databases and VB
- 831 Advance Visual Basic
- 1.2K Beginner VB
- 2.6K Game programming
- 315 Console programming
- 90 DirectX Game dev
- 1 Minecraft
- 112 Newbie Game Programmers
- 2 Oculus Rift
- 9K Applications
- 1.8K Computer Graphics
- 279 3D Graphics
- 129 DirectX
- 125 OpenGL
- 740 Computer Hardware
- 9 Cooling & Overclocking
- 3.4K Database & SQL
- 1.1K Access
- 91 ADO Programming
- 288 MySQL
- 358 Oracle
- 440 SQL-Server
- 535 Electronics development
- 1.6K Matlab
- 628 Sound & Music
- 25 DirectSound
- 257 XML Development
- 3.3K Classifieds
- 199 Co-operative Projects
- 198 For sale
- 190 FreeLance Software City
- 1.9K Jobs Available
- 603 Jobs Wanted
- 209 Wanted
- 2.9K Microsoft .NET
- 1.8K ASP.NET
- 1.1K .NET General
- 22 .NET WEB-Services
- 129 .NET WinForms
- 14 .NET XML
- 50 ADO.NET
- 142 C# & VB.NET School Support
- 3.4K Miscellaneous
- 4 Join the Team
- 354 Comments on this site
- 69 Computer Emulators
- 2.1K General programming
- 187 New programming languages
- 621 Off topic board
- 200 Mobile & Wireless
- 72 Android
- 126 Palm Pilot
- 338 Multimedia
- 154 Demo programming
- 184 MP3 programming
- 0 Bash scripts
- 27 Cloud Computing
- 1 Witsbits Go Cloud
- 53 FreeBSD
- 1.7K LINUX programming
- 1 Awk scripting
- 332 Linux Support
- 0 Sed scripting
- 370 MS-DOS
- 0 Shell scripting
- 321 Windows CE & Pocket PC
- 4.1K Windows programming
- 177 COM/DCOM
- 61 Networking And Security
- 17 Windows 2003 Server
- 6 Windows Vista
- 176 Windows XP
- 939 Software Development
- 416 Algorithms
- 68 Object Orientation
- 24 RUP & UML
- 91 Project Management
- 95 Quality & Testing
- 268 Security
- 63 Evil Scripting
- 81 Hacking
- 7.7K WEB-Development
- 1.8K Active Server Pages
- 61 AJAX
- 4 Bootstrap Themes
- 55 CGI Development
- 28 ColdFusion
- 224 Flash development
- 1.4K HTML & WEB-Design
- 1.4K Internet Development
- 131 Mobile Internet & Messaging
- 211 Wireless development
- 2.2K JavaScript
- 37 JQuery
- 304 WEB Servers
- 153 Apache
- 79 IIS
- 150 WEB-Services / SOAP
Comments
: use in a calculation. When the datagridview is populated it has 4
: columns. I want to
: capture the contents of the 3rd and 4th columns.
:
: When I try, I get errors. I seriously need help. Below is a copy of
: the code:
:
: Dim R As Integer
: Dim total As Decimal
:
: For R = 0 To Details1.Tables(0).Rows.Count - 1
: total = total + CDec(DataGrid.Item(R, 2)) *
: CDec(DataGrid.Item(R, 3))
: Next
: txtTotal.Text = total.ToString("$##.00")
What kind of errors do you get? Compile or Runtime? Which error? On which line do the errors occur?
: use in a calculation. When the datagridview is populated it has 4
: columns. I want to
: capture the contents of the 3rd and 4th columns.
:
: When I try, I get errors. I seriously need help. Below is a copy of
: the code:
:
: Dim R As Integer
: Dim total As Decimal
:
: For R = 0 To Details1.Tables(0).Rows.Count - 1
: total = total + CDec(DataGrid.Item(R, 2)) *
: CDec(DataGrid.Item(R, 3))
: Next
: txtTotal.Text = total.ToString("$##.00")
One issue is that you're using a TableRow index to reference a DataGrid row. It's not apparent how you're binding the data, however these indices are not guaranteed to be the same at the same time.
: : use in a calculation. When the datagridview is populated it has 4
: : columns. I want to
: : capture the contents of the 3rd and 4th columns.
: :
: : When I try, I get errors. I seriously need help. Below is a copy of
: : the code:
: :
: : Dim R As Integer
: : Dim total As Decimal
: :
: : For R = 0 To Details1.Tables(0).Rows.Count - 1
: : total = total + CDec(DataGrid.Item(R, 2)) *
: : CDec(DataGrid.Item(R, 3))
: : Next
: : txtTotal.Text = total.ToString("$##.00")
:
: What kind of errors do you get? Compile or Runtime? Which error? On
: which line do the errors occur?
*************************************
I get compile error as it tells me the line:
total = total + CDec(DataGrid.Item(R, 2)) * CDec(DataGrid.Item(R, 3))
is not valid.
The exact msg is "Value of type System Windows.Forms.DataGridViewCell cannot be converted to Decimal"
: : use in a calculation. When the datagridview is populated it has 4
: : columns. I want to
: : capture the contents of the 3rd and 4th columns.
: :
: : When I try, I get errors. I seriously need help. Below is a copy of
: : the code:
: :
: : Dim R As Integer
: : Dim total As Decimal
: :
: : For R = 0 To Details1.Tables(0).Rows.Count - 1
: : total = total + CDec(DataGrid.Item(R, 2)) *
: : CDec(DataGrid.Item(R, 3))
: : Next
: : txtTotal.Text = total.ToString("$##.00")
:
: One issue is that you're using a TableRow index to reference a
: DataGrid row. It's not apparent how you're binding the data,
: however these indices are not guaranteed to be the same at the same
: time.
Somehow the error is about the conversion of the decimal. Is there any System class to import at the beginning of the program?
: : : use in a calculation. When the datagridview is populated it has 4
: : : columns. I want to
: : : capture the contents of the 3rd and 4th columns.
: : :
: : : When I try, I get errors. I seriously need help. Below is a copy of
: : : the code:
: : :
: : : Dim R As Integer
: : : Dim total As Decimal
: : :
: : : For R = 0 To Details1.Tables(0).Rows.Count - 1
: : : total = total + CDec(DataGrid.Item(R, 2)) *
: : : CDec(DataGrid.Item(R, 3))
: : : Next
: : : txtTotal.Text = total.ToString("$##.00")
: :
: : One issue is that you're using a TableRow index to reference a
: : DataGrid row. It's not apparent how you're binding the data,
: : however these indices are not guaranteed to be the same at the same
: : time.
:
: Somehow the error is about the conversion of the decimal. Is there
: any System class to import at the beginning of the program?
:
That makes sense. DataGridView.Item(int, int) returns a DataGridViewCell object: http://msdn.microsoft.com/en-us/library/ms158656(VS.80).aspx. You'll want to do the following to get the value of the cell: [code]DataGrid.Item(R, 2).Value[/code]
I have a datagridview (unbound) that i want to calculate percentages based in a total. I already done the total (in a label.text). So what i want for the second column is to find out the percentage for each quantity that varies every time i enter a new quantity value.
qty % OF Content
10 8.130
20 16.260
30 24.390
50 40.65
13 10.569
Total: 123
Please i honestly need help.
THANKS
I have a datagridview (unbound) that i want to calculate percentages based in a total. I already done the total (in a label.text). So what i want for the second column is to find out the percentage for each quantity that varies every time i enter a new quantity value.
qty % OF Content
10 8.130
20 16.260
30 24.390
50 40.65
13 10.569
Total: 123
Please i honestly need help.
THANKS
I have a datagridview (unbound) that i want to calculate percentages based in a total. I already done the total (in a label.text). So what i want for the second column is to find out the percentage for each quantity that varies every time i enter a new quantity value.
qty % OF Content
10 8.130
20 16.260
30 24.390
50 40.65
13 10.569
Total: 123
Please i honestly need help.
THANKS
I have a datagridview (unbound) that i want to calculate percentages based in a total. I already done the total (in a label.text). So what i want for the second column is to find out the percentage for each quantity that varies every time i enter a new quantity value.
qty % OF Content
10 8.130
20 16.260
30 24.390
50 40.65
13 10.569
Total: 123
Please i honestly need help.
THANKS
I have a datagridview (unbound) that i want to calculate percentages based in a total. I already done the total (in a label.text). So what i want for the second column is to find out the percentage for each quantity that varies every time i enter a new quantity value.
qty % OF Content
10 8.130
20 16.260
30 24.390
50 40.65
13 10.569
Total: 123
Please i honestly need help.
THANKS
I have a datagridview (unbound) that i want to calculate percentages based in a total. I already done the total (in a label.text). So what i want for the second column is to find out the percentage for each quantity that varies every time i enter a new quantity value.
qty % OF Content
10 8.130
20 16.260
30 24.390
50 40.65
13 10.569
Total: 123
Please i honestly need help.
THANKS
I have a datagridview (unbound) that i want to calculate percentages based in a total. I already done the total (in a label.text). So what i want for the second column is to find out the percentage for each quantity that varies every time i enter a new quantity value.
qty % OF Content
10 8.130
20 16.260
30 24.390
50 40.65
13 10.569
Total: 123
Please i honestly need help.
THANKS