public void AddMember()
{
var newClientRow = ClientTable.NewRow();
newClientRow["RowGUID"] = Guid.NewGuid();
newClientRow["SponsorGUID"] = GUID == Guid.Empty.ToString() ? Fields["RowGUID"] : GUID;
newClientRow["IsSponsor"] = HouseMembers.Count == 0;
newClientRow["IsSpouse"] = false;
newClientRow["Active"] = true;
newClientRow["CCode"] = HouseMembers.Count > 0 ? HouseMembers[0]["CCode"] : "";
newClientRow.SetAllNonDBNullColumnsToEmptyString();
ClientTable.Rows.Add(newClientRow);
}