I am trying to return the username based on the user id.
Below are snippets of my code. The select command and the gridview.
1. SelectCommand="SELECT * FROM aspnet_Membership ORDER BY CreateDate Desc;"
2. <asp:GridView ID=GridView1 runat="server" AutoGenerateColumns=False DataSourceID=SqlDataSource1 AllowPaging=True DataKeyNames="UserID" AllowSorting=True CellPadding="4" HorizontalAlign="Center" PageSize="40">
<Columns>
<asp:TemplateField>
<EditItemTemplate>
<asp:Label ID="LblUsername" runat="server ...
Go to the complete details ...