ASP.NET

netJP12L wrote:

yes, that's right it convert to %26 but path couldn't be accessed

such as ../../A&R/data.txt

Knock out 't' from can't,
You can if you think you can

protected void mBtnAssignWhatever_Click(object sender, EventArgs e){
    ...Assign Session Variables
    PopulateForm();
}

protected void PageLoad(...){
    LoadDataFromDatabase();
    if(!IsPostBack){
       //Populate your list boxes here
    }
    PopulateForm();
}

private void PopulateForm(){
    if(AreMySessionVariablesAvaiable()){
        ...
    }
    else{
        ...
    }
}

if(SessionDataIsLoaded()){
   LoadData(sessionValue, ...);
}
else{
   LoadData(defaultValue, ...);
   //Or don't even load data, it doesn't really matter
}

TextBox tb = (TextBox)Master.FindControl("txtPolicyNumber");

public String MyTextBox
{
    get
    {
        return txtPolicyNumber.Text;
    }
    set
    {
        txtPolicyNumber.Text = value;
    }
}

DECLARE @MATIERE nvarchar(max)   <br />
SELECT @MATIERE =   <br />
  STUFF(   <br />
  (   <br />
  select distinct ',[' + LIBELLE_MATIERE + ']'  <br />
  from MATIERE where CODE_MODULE =11   <br />
  for xml path('')   <br />
 ),   <br />
 1,1,'')   <br />
  <br />
DECLARE @SQL nvarchar(max)   <br />
SELECT @SQL = N'   <br />
select  <br />
 *   <br />
from (   <br />
  <br />
  SELECT     ETUDIANT.NUM_INSCRIPTION, ETUDIANT.NOM_PRENOM_ETUDIANT_ARABE,EXAMEN.CODE,    <br />
 EXAMEN.NOTE,    <br />
                     MATIERE.LIBELLE_MATIERE   <br />
FROM         ETUDIANT INNER JOIN  <br />
                      EXAMEN ON ETUDIANT.NUM_INSCRIPTION = EXAMEN.NUM_INSCRIPTION INNER JOIN  <br />
                      CAPITALISE_MODULE ON    <br />
                      ETUDIANT.NUM_INSCRIPTION = CAPITALISE_MODULE.NUM_INSCRIPTION INNER JOIN  <br />
                      MATIERE ON EXAMEN.CODE_MATIERE = MATIERE.CODE_MATIERE INNER JOIN  <br />
                      MODULE ON CAPITALISE_MODULE.CODE_MODULE = MODULE.CODE_MODULE    <br />
                      AND MATIERE.CODE_MODULE = MODULE.CODE_MODULE   <br />
WHERE      (CAPITALISE_MODULE.CODE_MODULE = 11) AND    <br />
                      (CAPITALISE_MODULE.CODE_TYPE_RELATION_MODULE = 1)   <br />
) Data   <br />
PIVOT (   <br />
 SUM(NOTE)   <br />
 FOR LIBELLE_MATIERE   <br />
 IN (   <br />
  ' + @MATIERE + '  <br />
 )   <br />
) PivotTable   <br />
'   <br />
  <br />
exec sp_executesql @SQL  <br />