Find And Get Data In Datagridview With Condition / Statement

[vher_way]

Hello Guys!

I have problem with my project, I dont know how to impelementation Search and Get data in datagrid view with statement, I mean with WHERE.

This is the ilustration :

Let's Say The Table Below A Datagridview, with 5 Columns and 5 Rows.



The example of my problem, in S1 :

1. Check Ranking A = Ranking B?

[NO]

2. Find Ranking B that have Value = Ranking A!

Row-2 [S2]

3. Take Nilai B in the Row-2!

[0.9]

4. Find the difference between Nilai B in S1 and S2

[0.9 and 0.6 = 0.3]

5. Add new Columns and Put 0.3 right there.

And The Result Will be like this :



I dont Understand about Step 2 and Step 3, Somebody please Help Me! I’m confuse because there is no WHERE in VB.Net to make Condition!