public dsUser fillAccountDetails() { //create dataset dsUser dsUserDetails; try { //pass lastname text to findcustomer method and return results to dataset dsUserDetails = myDataLayer.UserDetails(HttpContext.Current.Session["username"].ToString()); if (dsUserDetails.tblUsers.Rows.Count > 0) { foreach (DataRow row in dsUserDetails.tblUsers.Rows) { if (DBNull.Value.Equals(row["City"])) { row["City"] = ""; } if (DBNull.Value.Equals(row["State"])) { row["State"] = ""; } if (DBNull.Value.Equals(row["Favorite_Language"])) { row["Favorite_Language"] = ""; } if (DBNull.Value.Equals(row["Least_Favorite_Language"])) { row["Least_Favorite_Language"] = ""; } if (DBNull.Value.Equals(row["Last_Program_Date"])) { row["Last_Program_Date"] = DateTime.MinValue; } } return(dsUserDetails); } else { //Set feedback text to no records found HttpContext.Current.Response.Redirect("Account Details Confirmation.aspx"); return(null); } } catch (Exception error) { //feedback text displays catch error string message = "Something went wrong - "; HttpContext.Current.Session["feedback"] = message + error.Message; return(null); } }