public static Profile LoadFromDataBase(string username) { string connstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connstr); string SQLstr; SQLstr = "SELECT * FROM MemberProfiles WHERE Username='******'"; conn.Open(); SqlCommand myCmd = new SqlCommand(SQLstr, conn); myCmd.CommandType = CommandType.Text; SqlDataReader myReader = myCmd.ExecuteReader(); Profile retProfile = new Profile(); bool read = false; while (myReader.Read()) { read = true; retProfile.MemberID = myReader.GetInt32(0); retProfile.SetUserName(myReader.GetString(1)); retProfile.SetVisibleUserName(myReader.GetString(2)); retProfile.Password = myReader.GetString(3); retProfile.Salt = myReader.GetString(4); retProfile.FirstName = myReader.GetString(5); retProfile.MiddleInitial = myReader.GetString(6); retProfile.LastName = myReader.GetString(7); retProfile.Address = myReader.GetString(8); retProfile.City = myReader.GetString(9); retProfile.Region = myReader.GetString(10); retProfile.PostalCode = myReader.GetString(11); retProfile.Country = myReader.GetString(12); retProfile.HomePhone = myReader.GetString(13); retProfile.WorkPhone = myReader.GetString(14); retProfile.CellPhone = myReader.GetString(15); retProfile.Email = myReader.GetString(16); retProfile.Gender = (GenderType)myReader.GetInt32(17); retProfile.DateOfBirth = (DateTime)myReader[18]; retProfile.SetJoinDate((DateTime)myReader[19]); retProfile.ReceiveSpam = myReader.GetBoolean(20); retProfile.IsAdmin = myReader.GetBoolean(21); retProfile.MembershipLevel = (MembershipType)myReader.GetInt32(22); retProfile.OtherMemberships = null; // GetOtherNetworks(retProfile.MemberID); } conn.Close(); if (read) return retProfile; else return null; }