display Dynamic sql in gridview
-
Hi, the following query
# DECLARE @MATIERE nvarchar(max) # SELECT @MATIERE = # STUFF( # ( # select distinct ',[' + LIBELLE_MATIERE + ']' # from MATIERE where CODE_MODULE =11 # for xml path('') # ), # 1,1,'') # # DECLARE @SQL nvarchar(max) # SELECT @SQL = N' # select # * # from ( # # SELECT ETUDIANT.NUM_INSCRIPTION, ETUDIANT.NOM_PRENOM_ETUDIANT_ARABE,EXAMEN.CODE, # EXAMEN.NOTE, # MATIERE.LIBELLE_MATIERE # FROM ETUDIANT INNER JOIN # EXAMEN ON ETUDIANT.NUM_INSCRIPTION = EXAMEN.NUM_INSCRIPTION INNER JOIN # CAPITALISE_MODULE ON # ETUDIANT.NUM_INSCRIPTION = CAPITALISE_MODULE.NUM_INSCRIPTION INNER JOIN # MATIERE ON EXAMEN.CODE_MATIERE = MATIERE.CODE_MATIERE INNER JOIN # MODULE ON CAPITALISE_MODULE.CODE_MODULE = MODULE.CODE_MODULE # AND MATIERE.CODE_MODULE = MODULE.CODE_MODULE # WHERE (CAPITALISE_MODULE.CODE_MODULE = 11) AND # (CAPITALISE_MODULE.CODE_TYPE_RELATION_MODULE = 1) # ) Data # PIVOT ( # SUM(NOTE) # FOR LIBELLE_MATIERE # IN ( # ' + @MATIERE + ' # ) # ) PivotTable # ' # # exec sp_executesql @SQLthis query shows this: num-inscription__NOM_PRENOM__subject1_____subject2_____ I want to display in a gridview with all columns are in edit mode except num_inscription and nom_prenom and then insert all in database . Help me please. Thanks -
Hi, the following query
# DECLARE @MATIERE nvarchar(max) # SELECT @MATIERE = # STUFF( # ( # select distinct ',[' + LIBELLE_MATIERE + ']' # from MATIERE where CODE_MODULE =11 # for xml path('') # ), # 1,1,'') # # DECLARE @SQL nvarchar(max) # SELECT @SQL = N' # select # * # from ( # # SELECT ETUDIANT.NUM_INSCRIPTION, ETUDIANT.NOM_PRENOM_ETUDIANT_ARABE,EXAMEN.CODE, # EXAMEN.NOTE, # MATIERE.LIBELLE_MATIERE # FROM ETUDIANT INNER JOIN # EXAMEN ON ETUDIANT.NUM_INSCRIPTION = EXAMEN.NUM_INSCRIPTION INNER JOIN # CAPITALISE_MODULE ON # ETUDIANT.NUM_INSCRIPTION = CAPITALISE_MODULE.NUM_INSCRIPTION INNER JOIN # MATIERE ON EXAMEN.CODE_MATIERE = MATIERE.CODE_MATIERE INNER JOIN # MODULE ON CAPITALISE_MODULE.CODE_MODULE = MODULE.CODE_MODULE # AND MATIERE.CODE_MODULE = MODULE.CODE_MODULE # WHERE (CAPITALISE_MODULE.CODE_MODULE = 11) AND # (CAPITALISE_MODULE.CODE_TYPE_RELATION_MODULE = 1) # ) Data # PIVOT ( # SUM(NOTE) # FOR LIBELLE_MATIERE # IN ( # ' + @MATIERE + ' # ) # ) PivotTable # ' # # exec sp_executesql @SQLthis query shows this: num-inscription__NOM_PRENOM__subject1_____subject2_____ I want to display in a gridview with all columns are in edit mode except num_inscription and nom_prenom and then insert all in database . Help me please. Thanksamina89 wrote:
I want to display in a gridview with all columns are in edit mode except num_inscription and nom_prenom
If by default you want to show grid id edit mode, then use textboxes for subject1 & subject2 in
ItemTemplate. Use labels for num_inscription & nom_prenom. Use standard way to insert the data. If you have an event to change normal gridview to edit mode then, use textboxes for the editable fields inEditTemplateand labels for non-editable in edittemplate. On update of row, insert the data in database. -
amina89 wrote:
I want to display in a gridview with all columns are in edit mode except num_inscription and nom_prenom
If by default you want to show grid id edit mode, then use textboxes for subject1 & subject2 in
ItemTemplate. Use labels for num_inscription & nom_prenom. Use standard way to insert the data. If you have an event to change normal gridview to edit mode then, use textboxes for the editable fields inEditTemplateand labels for non-editable in edittemplate. On update of row, insert the data in database.