protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Redirect("Login1.aspx");
}
using (MySqlConnection sqlcon = new MySqlConnection(ConnectionString))
{
sqlcon.Open();
MySqlDataAdapter sqlDa = new MySqlDataAdapter("SELECT * FROM staff", sqlcon);
DataTable dtb1 = new DataTable();
sqlDa.Fill(dtb1);
StaffID.DataSource = dtb1;
StaffID.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Redirect("Login1.aspx");
}
UserDetails.Text = "Username : "******"username"];
using (MySqlConnection sqlcon = new MySqlConnection(ConnectionString))
{
sqlcon.Open();
MySqlDataAdapter sqlDa = new MySqlDataAdapter("SELECT * FROM rota WHERE Hours =" + Session["hours"] + " AND StaffID != '" + Session["username"] + "'", sqlcon);
DataSet Choices = new DataSet();
sqlDa.Fill(Choices, "Choices");
StaffID.DataSource = Choices;
StaffID.DataBind();
}
}
