[RESOLVED] VB2005 Sum column in datagridview

[sparrow1]

Hellowww again my friends...

I have a datagridview that contains the column "Amount".

I also have a textbox

I want the sum of the column "amount" to appear in the textbox

I have tried the following:

dim total as Integer
 
For Each row As DataGridViewRow In  TblBetalingAanMedewerkerDataGridView.Rows
Total += row.Cells("Bedrag").Value
Next
 
txtTotaalBedrag.Text = Total

I get the message "Cant find column "amount".
Parametername: ColumnName

Do you guys have an idea what i am doing wrong????

Thanks in advance

Hi,

You can try something like this;

TextBox1.Text = clumnName.Text ' put here your columnName

Hope it helps,

sparrow1