for SQL:
SqlCommand cmd = new SqlCommand(select <column_1>,<column_2> from <table_name> where <any_condition>, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Label4.Text = dr[0].ToString();
Label5.Text = dr[1].ToString();
}
in your case:
MySqlCommand myCommand = new MySqlCommand("select <column_name> from users where user_name='" + Session["user"] + "'", con);
con.open();
Mysqldatareader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
TextBox4.Text = myReader[0].ToString();
}
conn.close();
enjoy! :)