Any .Net Guru??

I am using FlexGrid control of ComponentOne on my form in vb.net having 3 cols.

I want to change the value of 3 col when 2nd col's value changes. I have written the following code:

VB Code:

Private Sub grdSHP_CellChanged(ByVal sender As Object, ByVal e As C1.Win.C1FlexGrid.RowColEventArgs) Handles grdSHP.CellChanged
        With grdSHP
            If e.Row = 0 Or e.Col = 0 Then
                Exit Sub
            End If
            If Val(.get_TextMatrix(15, 2)) = 0 Then
                .set_TextMatrix(e.Row, 2, "0") '***Here I get the error***
            Else
                .set_TextMatrix(e.Row, 2, Val(.get_TextMatrix(15, 2)) * Val(.get_TextMatrix(e.Row, 1)) / 100)
            End If
        End With
    End Sub

This is not working.

Pls guide me if there's any other way.

Regards,

Prakash

You need to ask this in the .Net forums.

I see that you already did, but, asking it here also, will not make it get responded to with an answer any faster.

Double Posted:eek:

I'd recommend posting this on Component ones Newsgroups

The other thing you could do is use the after edit event. Check if it was column 2 that was edited, and if so update column 3. Also the reason your getting an error is because your using 0 as a string, "0".

i tried replacing "0" with 0, but it isn't working.

well i will try the after edit event.