Hi, I have the following code which I want to get the current username of the user logged in and use it as the @username parameter:
aspx file:
<asp:SqlDataSource ID="SqlDataRegionalUserAreas" runat="server" ConnectionString="<%$ ConnectionStrings:DevCPSdocshare %>"
SelectCommand="SELECT d.doc_area_name
FROM document_area d,document_area_user_access a
WHERE a.doc_area = d.doc_area_id
AND and a.username=@username">
<SelectParameters>
<asp:Parameter Name="username" Go to the complete details ...