i'm trying display current logged in user , record in gridview. if user logged in can view of records , tables associated him. here's simple code of mine.
<%@ page title="" language="c#" masterpagefile="~/site1.master" autoeventwireup="true" codebehind="account.aspx.cs" inherits="librarysystem.member.myaccount" %> <asp:content id="content1" contentplaceholderid="head" runat="server"> </asp:content> <asp:content id="content2" contentplaceholderid="contentplaceholder1" runat="server"> <h3> account</h3> <p> </p> <p> <asp:gridview id="gridview1" runat="server" autogeneratecolumns="false" cellpadding="4" datakeynames="lenid" datasourceid="useraccountdatasource" forecolor="#333333" gridlines="none"> <rowstyle backcolor="#eff3fb" /> <columns> <asp:boundfield datafield="lenid" headertext="lend id" insertvisible="false" readonly="true" sortexpression="lenid" /> <asp:boundfield datafield="bookid" headertext="book id/isbn" sortexpression="bookid" /> <asp:boundfield datafield="employeeid" headertext="employee id" sortexpression="employeeid" /> <asp:boundfield datafield="department" headertext="department" sortexpression="department" /> <asp:boundfield datafield="dateborrowed" headertext="date borrowed" sortexpression="dateborrowed" /> <asp:boundfield datafield="datereturned" headertext="date returned" sortexpression="datereturned" /> </columns> <footerstyle backcolor="#507cd1" font-bold="true" forecolor="white" /> <pagerstyle backcolor="#2461bf" forecolor="white" horizontalalign="center" /> <selectedrowstyle backcolor="#d1ddf1" font-bold="true" forecolor="#333333" /> <headerstyle backcolor="#507cd1" font-bold="true" forecolor="white" /> <editrowstyle backcolor="#2461bf" /> <alternatingrowstyle backcolor="white" /> </asp:gridview> <asp:sqldatasource id="useraccountdatasource" runat="server" connectionstring="<%$ connectionstrings:librarysystemconnectionstring %>" selectcommand="select [lenid], [bookid], [employeeid], [department], [dateborrowed], [datereturned] [lendtable] ([employeeid] = @employeeid)"> <selectparameters> <asp:controlparameter controlid="gridview1" name="employeeid" propertyname="selectedvalue" type="int32" /> </selectparameters> </asp:sqldatasource> </p> <p> </p> </asp:content> employeeid same username (i've pointed aspnet user database own database). wanted display logged in user's record current logged in user.
any appreciated ;) in advance.
since said in question employeeid username, can access logged in username follows:
httpcontext.current.user.identity.name 
Comments
Post a Comment