I have a listview in which i am binding data from database. i have one encrypted column to which we have encrypt while saving to database. now i want to display its decrypted value. but i dont know how to pass that's value to decrypt method while i am binding the list. My html code is as follow:
<asp:ListView ID="lsttest" runat="server" ItemPlaceholderID="trData" OnItemDataBound="lstRegOrg_ItemDataBound">
<LayoutTemplate>
<table cellspacing="0" border="0">
<tr class="hdrRowColor1">
<td width="35px" align="left">
S.No
</td>
<td width="175px" align="left">
<asp:LinkButton ID="lnkName" runat="server" CommandArgument="p.FirstName" OnClick="lnk_Sort">Name</asp:LinkButton>
<asp:Image ID="img_lnkName" Visible="false" runat="server" />
</td>
<td width="175px" align="left">
<asp:LinkButton ID="lnk_UserName" runat="server" CommandArgument="p.UserName" OnClick="lnk_Sort">User Name</asp:LinkButton>
<asp:Image ID="img_lnk_UserName" Visible="false" runat="server" />
</td>
<td width="175px" align="left">
<asp:LinkButton ID="lnkEmail" runat="server" CommandArgument="p.EmailAddress" OnClick="lnk_Sort">Email</asp:LinkButton>
<asp:Image ID="img_lnkEmail" Visible="false" runat="server" />
</td>
<td width="120px" align="left">
<asp:LinkButton ID="lnkRoleName" runat="server" CommandArgument="tblroles.RoleName"
OnClick="lnk_Sort">Role</asp:LinkButton>
<asp:Image ID="img_lnkRoleName" Visible="false" runat="server" />
</td>
<td width="150px" align="left">
<asp:LinkButton ID="lnk_CreatedBy" runat="server" CommandArgument="u.firstName" OnClick="lnk_Sort">Created By</asp:LinkButton>
<asp:Image ID="img_lnk_CreatedBy" Visible="false" runat="server" />
</td>
<td width="120px" align="left">
<asp:LinkButton ID="lnkCreatedDate" runat="server" CommandArgument="p.CreatedDate"
OnClick="lnk_Sort">Created Date</asp:LinkButton>
<asp:Image ID="img_lnkCreatedDate" Visible="false" runat="server" />
</td>
<td width="150px" align="left">
<asp:LinkButton ID="lnk_LastModifiedBy" runat="server" CommandArgument="u.firstName"
OnClick="lnk_Sort">Last Modified By</asp:LinkButton>
<asp:Image ID="img_lnk_LastModifiedBy" Visible="false" runat="server" />
</td>
<td width="125px" align="left">
<asp:LinkButton ID="lnk_LastModifiedDate" runat="server" CommandArgument="p.CreatedDate"
OnClick="lnk_Sort">Last Modified On</asp:LinkButton>
<asp:Image ID="img_lnk_LastModifiedDate" Visible="false" runat="server" />
</td>
<td align="center" width="60px">
<asp:LinkButton ID="lnkIsActive" runat="server" CommandArgument="p.IsActive" OnClick="lnk_Sort">IsActive</asp:LinkButton>
<asp:Image ID="img_lnkIsActive" Visible="false" runat="server" />
</td>
<td align="center" width="50px" style="border-right: 1px solid #6398cc">
Actions
</td>
</tr>
<tr id="trData" runat="server">
</tr>
</table>
</LayoutTemplate>
<ItemTemplate>
<tr class='<%# Convert.ToBoolean(Container.DataItemIndex % 2) ? "EvenRowColor" : "OddRowColor" %>'>
<td align="left" valign="middle">
<%# Container.DataItemIndex+1 %>.
</td>
<td align="left">
<asp:Label ID="lblFullName" runat="server" Text='<%# Eval("Name")%>'></asp:Label>
</td>
<td align="left">
<asp:Label ID="Label1" runat="server" Text='<%= CCMMUtility.Decryptdata(Eval("UserName")) %>' />
<%-- <asp:Label ID="Label1" runat="server" Text='<%# Eval("UserName")%>' />--%>
</td>
<td align="left">
<asp:Label ID="lblEmail" runat="server" Text='<%# Eval("EmailAddress")%>'></asp:Label>
</td>
<td align="left">
<asp:Label ID="lblRole" runat="server" Text='<%# Eval("RoleName") %>'></asp:Label>
</td>
<td align="left">
<asp:Label ID="Label2" runat="server" Text='<%# Eval("CreatedBy") %>'></asp:Label>
</td>
<td align="left">
<%# Convert.ToDateTime(Eval("CreatedDate")).ToString("MMM, dd yyyy") %>
</td>
<td align="left">
<asp:Label ID="Label3" runat="server" Text='<%# Eval("ModifiedBy") %>'></asp:Label>
</td>
<td align="left">
<%# Convert.ToDateTime(Eval("ModifyDate")).ToString("MMM, dd yyyy")%>
</td>
<td align="center">
<asp:Label ID="lblName" runat="server" Style="display: none;" Text='<%# Eval("Name")%>'></asp:Label>
<asp:Label ID="lbl_Status" runat="server" Style="display: none;" Text='<%# Eval("IsActive")%>'></asp:Label>
<asp:ImageButton ID="imgbtnStatus" runat="server" CommandArgument='<%# Eval("id") %>'
OnClick="imgbtnStatus_Onclick" />
</td>
<td align="center" class="last">
<asp:ImageButton ID="imgbtnEdit" runat="server" ImageUrl="~/App_Themes/ThemeNew/Images/edit.png"
ToolTip="Edit Details" CommandArgument='<%# Eval("Id") %>' OnClick="imgbtnEdit_OnClick" />
</td>
</tr>
</ItemTemplate>
</asp:ListView>
I want to do it for column Username. Please help me.
