<![CDATA[<% Response.Write(System.Environment.UserName)%>]]>
'<% Response.Write(System.Environment.UserName)%>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" EnableCaching="True" FilterExpression="genacc_user_adacc = '<% Response.Write(System.Environment.UserName)%>'" ConnectionString="<%$ ConnectionStrings:LabAccManConnectionString %>" SelectCommand="with cteDataList as ( SELECT account_user.genacc_user_adacc, genacc_machines.hostname, genacc_account.SPE, genacc_account.adacc, genacc_account.department, genacc_machines.software, genacc_machines.location, genacc_pw.pass, genacc_pw.key_index, row_number() over (PARTITION by account_user.genacc_user_adacc, genacc_machines.hostname order by genacc_pw.id desc) as Rown FROM genacc_pw INNER JOIN genacc_account ON genacc_pw.genacc_account_id = genacc_account.id INNER JOIN account_user ON genacc_account.id = account_user.genacc_account_id INNER JOIN genacc_machines ON genacc_account.id = genacc_machines.genacc_account_id ) Select * from cteDataList where RowN = 1 "ConflictDetection="CompareAllValues"></asp:SqlDataSource>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)