Comparing 3 Values in the same column of a datagrid

[ac11nyc]

Ok so i have a datagrid that brings back a few Values. I give the user the option to insert a record anywhere inside the datagrid just as long as the Values are in a correct ascending order. How can i compare the value of the previous row with the value of the selected row as well as comparing it with the row after it?? Any help will greatly be appreciated. Its a simple load of a datagrid so thats why there's no code.

 

[Veep]

To get the previous row and the following row you first need to know the selected row. You can get that in the SelectedIndexChanged event when a row is selected.

private void myGrid_SelectedIndexChanged(object sender,eventargs e)
{
  int myIndex = myGrid.SelectedIndex;
  // let's say that the values to compare are in cell2
  string myVal = myGrid.Items[myIndex].Cells[2].Text;
  // you can get the previous and next items by adding
  // or subtracting from the value of myIndex
  string myNextVal = myGrid.Items.[myIndex +1].Cells[2].Text;
  // need to check if the first item was selected
  // if so, there is no previous item
  if(myIndex != 0)
     string myPrevVal = myGrid.Items[myIndex -1].Cells[2].Text;
}

And so on...If you are using Template Columns and storing your values in controls (Label, TextBox etc) then you'll first need to cast to the control type and use FindControl:

Label myLabel = (Label)myGrid.Items[myIndex].Cells[2].FindControl("lblSomeLabel");
// then it's just 
string myVal = myLabel.Text;