protected void Page_Load(object sender, EventArgs e)
{
//stocker l'id de l'utilisateur connecté
IdUser = employeRep.GetByLogin(Session["user"].ToString());
if (!IsPostBack)
{
string connetionString = ConfigurationManager.ConnectionStrings["PPPConnectionString"].ConnectionString;
//charger les demandes de conges correspondantes à ce user
BindGrid();
//Specify the connectionString , insert, select cmd of the formView
SqlDSForm.SelectCommand = demandeCongeRep.Select();
SqlDSForm.ConnectionString = connetionString;
//configuration de la liste des types de conges
SqlDSList.ConnectionString = connetionString;
SqlDSList.SelectCommand = congeRep.Select();
//config de la list des colonnes de la gridView pour le filtrage
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM INFORMATION_SCHEMA.columns as name where table_name = 'DemandeConges'", connetionString);
DataTable dt = new DataTable();
da.Fill(dt);
DropDownListColumn.DataSource = dt;
DropDownListColumn.DataValueField = "COLUMN_NAME";
DropDownListColumn.DataTextField = "COLUMN_NAME";
DropDownListColumn.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//configiration de la datasource du FormView
string connetionString = ConfigurationManager.ConnectionStrings["PPPConnectionString"].ConnectionString;
SqlDSConge.ConnectionString = connetionString;
SqlDSConge.SelectCommand = CongeRepo.Select();
SqlDSConge.InsertCommand = CongeRepo.Inserer();
}
