Db allows null in the table.. Thank for your help... hope to post in the right place..



Protected Sub ASPxGridView1_CustomUnboundColumnData(ByVal sender As Object, ByVal e As DevExpress.Web.ASPxGridView.ASPxGridViewColumnDataEventArgs) Handles ASPxGridView1.CustomUnboundColumnData
If (e.Column.FieldName = "total1") Then
apples = Convert.ToInt32(e.GetListSourceFieldValue("apples"))<<---Object cannot be cast from DBNull to other types.
peach = Convert.ToInt32(e.GetListSourceFieldValue("peach"))
e.Value = apples + peach

End If
End Sub