private void UpdateProfile_Load(object sender, EventArgs e) { Member updateMember = new Member(); updateMember = memberDAO.getMemberById(LoginPage.memId); tbFirstname.Text = updateMember.Firstname; tbLastname.Text = updateMember.Lastname; tbAddress1.Text = updateMember.Address; tbCity.Text = updateMember.City; tbUser.Text = updateMember.Username; tbPass.Text = updateMember.Password; tbEmail.Text = updateMember.Email; tbPicture.Text = updateMember.Picture; pictureBox.Image = new Bitmap(updateMember.Picture); }
public Member getMemberById(int id) { String oradb = "Data Source= cp3dbinstance.c4pxnpz4ojk8.us-east-1.rds.amazonaws.com:1521/cp3db;User Id=sw1;Password=CampBand4;"; OracleConnection conn = new OracleConnection(oradb); Member thisMem = null; try { OracleCommand cmd = new OracleCommand("SELECT * FROM MEMBERS WHERE MEMID = " + id + "", conn); conn.Open(); OracleDataReader dr = cmd.ExecuteReader(); dr.Read(); String firstName = dr.GetString(1); String lastName = dr.GetString(2); String address = dr.GetString(3); String city = dr.GetString(4); String username = dr.GetString(5); String password = dr.GetString(6); String picture = dr.GetString(7); String email = dr.GetString(8); DateTime regdate = dr.GetDateTime(9); thisMem = new Member( id, firstName, lastName, address, city, username, password, email, regdate.ToString("dd-MMM-yyyy"), picture); conn.Close(); return thisMem; } catch (OracleException ex) { MessageBox.Show("Something went wrong when accessing the database."); MessageBox.Show("sql error"); MessageBox.Show(ex.Message); } finally { conn.Close(); } return null; }