Need to create a user control on a [url removed, login to view] extranet. Please apply only if you are qualified to do this in VB.NET.
presently my ASPX website page has a fixed list of categories and I need it to dynamically read the list of Categories from the sql table.
The control should dynamically list entries from a MSSQL table - essentially list of pdf forms - grouped by category and sorted by name.
In tsql simplified terms, usercontrol should display the following contents
select Category, FormName, Edition
where Department = 'XXX'
group by Category, FormName, Edition
order by Category, FormName
compute count(FormName) by Category
The control will display only forms available for a specific department, depending on where the control was called from (see where condition)
Search capabilities should be available so a specific forms can be found.
A Column(s) to indicate form format, i.e. Word, PDF or DynamicPDF should be graphically presented. Clicking on the icon should launch the selected form in separate window.