0

Hi all,

Iam using vb.net and WPF
In a wpf window im showing a datagrid in the load event
while in the load event itself,i need to count grand total
amount from a single datagrid column and add it to a
textbox in same page .

My page looks like this

MY DATAGRID

Item Quantity Total
`````` ```````` `````
Shirt 2 200
Pant 1 500
Tie - -
Belt 2 100


MY TEXTBOX ---> Grand Total amount : - 800


How do i do tat if iam counting from a ((Total Column )) DTG
and adding it and showing it in my (( GRAND TOTAL AMOUNT)) TEXTBOX

Thanks in advance

Naveen.....

7
Contributors
7
Replies
59
Views
7 Years
Discussion Span
Last Post by 123mahesh
0

Wouldn't it be easier to look at the underlying datasource?
For example, if the DataGrid is bound to a DataSet you can loop that to find the values you are looking for.

Dim totalSum As Integer

For i As Integer = 0 To DataSet.Tables(0).Rows.Count - 1
   totalSum += DataSet.Tables(0).Rows(i).Item("Total")
Next

TextBox.Text = totalSum.ToString()
0

I just posted a new tread about this but after seeing this one my problem is solved thanks :) Thanks @Oxiegen

0

What if, "I would like to create a query statement that would give me the sum of the column(total_bill)?"
like this:

("Select SUM(total_bill)FROM tbl_estimates WHERE estimation_date = '"& Textbox1.Text & "'",2)

I would like to Display it in my listview.

My, Query statement is absolutely right, but then there is still an error that doesnt have a suggestion.

Maybe you guys could help me..... :)

0

hey man i was wondering for the solution of this since long time >>>>>>>> i really got pleased thnks man

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.