dotnetnuke datagrid

Current Features: -Filter: in the admin page you can specify a field to act as a filter. A drop down will be populated with Distinct values from that Field. -Sorting: users can click on any column header to sort by that column. -Search: Allows users to search a specified field for a value. Basically this adds a "[fieldname] Like [value]" to the WHERE clause. -Paging- Admin can specify whether to use paging on the grid and how many records to show per page. -Export datagrid to an Excel file. -Parameter Substitution: SQL can include [dnn:UserID] or [dnn:PortalID] and the system will use the DNN values for the CurrentUserID or the PortalID. E.g. Select FirstName, LastName from Users where UserID = [dnn:UserID].