Sort and sum up gridview(devexpress) column in vb.net

  • Thread starter Thread starter OneInch
  • Start date Start date
O

OneInch

Guest
Hello guys! I just wanna ask some help maybe someone here can help.

I'll gonna go straight to my query.

So I have a gridview that displays column 1, column 2, column 3

In column 1 contains random numbers like 1-100 every row

Also in column 2 and 3 that only contains 1 and 0(like true or false).

It looks like this in gridview,

column 1 | column 2 | column 3

15 | 1 | 0

19 | 1 | 0

26 | 0 | 1

75 | 1 | 0

so on and so forth. What I wanna do is to get the total value of column 2 that has a value of (15 to 19 in column 1, bracket).

In this example, (15-19,bracket) of column 1 has a total value of 2. And to display the total value in textbox separated every bracket. Sample of bracket I'm using is like this (15-19, 20-24, 25-29, so on and so forth.).


Hope someone can understand my explanation and help me.

Thanks in advance!

Continue reading...
 
Back
Top