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);
}
