Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
37 Points
63 Posts
Jun 12, 2009 12:11 AM|LINK
I'd like to know how I can use a session variable inside the SelectCommand of an asp:AccessDataSource control.
ASP code:
<asp:AccessDataSource ID="dSrcMarcacoes" runat="server" DataFile="~/App_Data/Clinica.mdb" SelectCommand="SELECT COLABORADORES.NOME_COLAB, MARCACOES.DATA, MARCACOES.HORA, MARCACOES.SALA FROM ((MARCACOES INNER JOIN COLABORADORES ON MARCACOES.ID_MEDICO = COLABORADORES.ID_COLABORADOR) INNER JOIN PACIENTES ON MARCACOES.ID_PACIENTE = PACIENTES.ID_PACIENTE) WHERE (MARCACOES.ID_PACIENTE = @SelectUser)"> <SelectParameters> <asp:SessionParameter Name="SelectUser" SessionField="Utilizador" /> </SelectParameters> </asp:AccessDataSource>
AccessDataSource SelectCommand GridView session variable
voliveira
Member
37 Points
63 Posts
Submitting session parameters into a select command on a asp.datasource
Jun 12, 2009 12:11 AM|LINK
I'd like to know how I can use a session variable inside the SelectCommand of an asp:AccessDataSource control.
ASP code:
<asp:AccessDataSource ID="dSrcMarcacoes" runat="server" DataFile="~/App_Data/Clinica.mdb" SelectCommand="SELECT COLABORADORES.NOME_COLAB, MARCACOES.DATA, MARCACOES.HORA, MARCACOES.SALA FROM ((MARCACOES INNER JOIN COLABORADORES ON MARCACOES.ID_MEDICO = COLABORADORES.ID_COLABORADOR) INNER JOIN PACIENTES ON MARCACOES.ID_PACIENTE = PACIENTES.ID_PACIENTE) WHERE (MARCACOES.ID_PACIENTE = @SelectUser)"> <SelectParameters> <asp:SessionParameter Name="SelectUser" SessionField="Utilizador" /> </SelectParameters> </asp:AccessDataSource>The above code does not work - I simply want the where clause to be defined by the Session Variable "Utilizador" - not using codebehind!AccessDataSource SelectCommand GridView session variable
Mark as answer if my reply is somewhat insightful. Or helped you in any way!