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(); }