>Are you using datasets? If so, check out the DataRow.RowState property.
>
>Sorry, that works for Added, but not Update. Why not allow NULLs?
No, we're not using datasets, we're using SQLDataSource directly (with SPs). However, I think I figured my dilemma. I only need to insert information if IsMember is 1. I'm not sure though what to do with updating when switching from Member to no member.
If it's not broken, fix it until it is.
My Blog