ASP.NET

Public Class BasePage 
Inherits System.Web.UI.Page   

    public Dim acon As New SqlConnection

    Protected Overridable Sub  Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
        acon= new SqlConnection(ConfigurationManager.ConnectionStrings("DOCDBDWHConnectionString").ConnectionString)
        acon.open()
    End Sub

Partial Class Site
    Inherits System.web.UI.MasterPage 

# 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