Hi All:
How can I update a second column based on the value of the current cell in the AfterCellUpdate event of the UltraGrid?
Here's my code:
If e.Cell.Column.Key = "ZipCode" Then FoundZipRow = dtZips.Rows.Find(e.Cell.Text) If FoundZipRow IsNot Nothing Then 'Set the State column to FoundZipRow("State") Else 'Set the State Column to DBNull.value End If End If
You can set the cell like that:
e.Cell.Row.Cells("State").Value = FoundZipRow("State")
I would recommend using InitalizeRow for this, rather than AfterCellUpdate.