By using the DnnGrid, I was able to create a very powerful solution for this in a matter of minutes. I added a new UserControl called UserSelector. In the ascx, I put the following:
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="UserSelector.ascx.vb" Inherits="DotNetNuke.Controls.UserSelector" %>
<%@ Register TagPrefix="dnnWebControls" Namespace="DotNetNuke.Web.UI.WebControls" Assembly="DotNetNuke.Web" %>
<dnnWebControls:DnnGrid ID="grdPlayer" DataSourceID="dsUsers" runat="Server" Width="100%" AutoGenerateColumns="true" PageSize="4"
AllowSorting="true" MasterTableView-AllowPaging="true" AllowFilteringByColumn="true" >
<MasterTableView AllowSorting="true">
<Columns>
<dnnWebControls:DnnGridTemplateColumn AllowFiltering="false" HeaderText="Details" >
<ItemTemplate>
<a href='<%# GetURL(DataBinder.Eval(Container.DataItem,"UserID")) %>'><%# "SELECT"%></a>
</ItemTemplate>
</dnnWebControls:DnnGridTemplateColumn>
</Columns>
</MasterTableView>
</dnnWebControls:DnnGrid>
<asp:SqlDataSource ID="dsUsers" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" runat="server"
SelectCommand="Select UserID,Username,FirstName,LastName,Email,DisplayName from Users">
</asp:SqlDataSource>
In the code behind:
Namespace DotNetNuke.Controls
Partial Class UserSelector
Inherits DotNetNuke.Entities.Modules.PortalModuleBase
Protected Function GetUrl(ByVal userid As String) As String
Return NavigateURL(TabId, "", "userid=" & userid)
End Function
End Class
End Namespace