public dsUsers FindUser(string Username) { dsUsers dsFoundUser = myDataLayer.findUser(Username); if (dsFoundUser.tblUsers.Rows.Count > 0) { System.Data.DataRow userRecord = dsFoundUser.tblUsers.Rows[0]; if (userRecord["Username"] == DBNull.Value) { userRecord["Username"] = string.Empty; } if (userRecord["City"] == DBNull.Value) { userRecord["City"] = string.Empty; } if (userRecord["State"] == DBNull.Value) { userRecord["State"] = string.Empty; } if (userRecord["FavoriteLanguage"] == DBNull.Value) { userRecord["FavoriteLanguage"] = string.Empty; } if (userRecord["LeastFavoriteLanguage"] == DBNull.Value) { userRecord["LeastFavoriteLanguage"] = string.Empty; } if (userRecord["LastProgramDate"] == DBNull.Value) { userRecord["LastProgramDate"] = string.Empty; } } return(dsFoundUser); }