protected void Page_Load(object sender, EventArgs e)
{
AU_GRIDVIEW.Visible = false;
if (!IsPostBack)
{
string connection = instance.connection;
instance.con = new SqlConnection(connection);
instance.con.Open();
instance.cmd = new SqlCommand("select * from profile", instance.con);
dt.Load(instance.cmd.ExecuteReader());
type_utilisateur.DataSource = dt;
type_utilisateur.DataTextField = "libelle";
type_utilisateur.DataValueField = "code_profile";
type_utilisateur.DataBind();
instance.cmd = new SqlCommand("select * from utilisateur", instance.con);
dt3.Load(instance.cmd.ExecuteReader());
fillGridView();
AU_GRIDVIEW.DataBind();
fillFormsautoriseGridView();
MenueAutorise.DataBind();
fillListTitres();
dt5Count = dt5.Rows.Count;
}
else
{
AU_GRIDVIEW.Visible = true;
}
}
private void fillFormsautoriseGridView()
{
instance.cmd = new SqlCommand("SP_AfficherListMenu", instance.con);
instance.cmd.CommandType = CommandType.StoredProcedure;
instance.cmd.Parameters.AddWithValue("@code_profile", type_utilisateur.SelectedValue);
dt4.Load(instance.cmd.ExecuteReader());
MenueAutorise.DataSource = dt4;
MenueAutorise.DataBind();
}
