public EditUserProfile()
{
InitializeComponent();
try
{
MySqlConnection connection = new MySqlConnection(static_connectionString);
connection.Open();
MySqlCommand command = new MySqlCommand("select username,firstname,lastname,email from users where userid=@id", connection);
string id = Login_page.GetUserID();
command.Parameters.AddWithValue("id", id);
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
username_textbox.Text = reader["username"].ToString();
firstname_textbox.Text = reader["firstname"].ToString();
lastname_textbox.Text = reader["lastname"].ToString();
email_textbox.Text = reader["email"].ToString();
}
else
{
username_textbox.Text = "You must Login to Continue to this page";
}
}
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public UserProfile()
{
InitializeComponent();
ShowsNavigationUI = false;
try
{
MySqlConnection connection = new MySqlConnection(static_connectionString);
connection.Open();
MySqlCommand command = new MySqlCommand("select username,firstname,lastname,birthday,email from users where userid=@id", connection);
string id = Login_page.GetUserID();
command.Parameters.AddWithValue("id", id);
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
Username_label.Content = reader["username"].ToString();
Firstname_label.Content = reader["firstname"].ToString();
Lastname_label.Content = reader["lastname"].ToString();
Birthday_label.Content = reader["birthday"].ToString();
Email_label.Content = reader["email"].ToString();
}
else
{
Username_label.Content = "You must Login to Continue to this page";
}
}
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}