Hello ASPeeps,
Sequel to my first question. I used the QueryString Value for my Select Parameters. However the previous page encrypted the values and i cannot use them in my query as follows
About?id=43u75sDXlT1zmC4ieZCJiNr2Ck69Up2S0DSDE0GhqQU%3d&RetainCode=D%2f7JpmGuVCNWzM3fY4gCug%3d%3d
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>" SelectCommand="SELECT [cDate], [Date], [Time], [consultID], [Fullname], [policyType], [empNo], [complaints], [investigate], [result], [diagnosis], [treatPlan], [treatedBy], [retainName], [AmountBilled], [AmountPaid] FROM [qryhConsultingDiagnosisHMO] WITH (NOLOCK) WHERE ([RetainCode] = @RetainCode) AND ([cDate] > DATEADD(year, -1, GETDATE())) ORDER BY [cDate]DESC, [cTime]DESC, [Fullname]" FilterExpression="cDate >= '#{0}#' AND cDate <= '#{1}#'">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="#" Name="RetainCode" QueryStringField="RetainCode" Type="String" />
</SelectParameters>
So i was wondering if there was a way to use the variable created after decrypting in the SqlDataSource Select Command. And how to do it?