Create two vb.net admin pages to interrogate SQL table
$30-250 USD
In Progress
Posted over 13 years ago
$30-250 USD
Paid on delivery
The task:
Create a two web pages to interrogate a simple sql table capturing analytics information for our websites. A script to create this table with sample data will be provided, along with queries
[login to view URL]
[login to view URL]
The pages must be coded in vb.net and will use a master page (any masterpage will do, we will change it for our own master page later).
Background: we have a mobile and a desk top version of our web sites. Information for these must be shown separately.
[login to view URL]
This page will show two summary calculations at the top of the page, then a table of records below.
The summary calculations are for the
- Mobile site page views
- Main site page views
The user can select date range (via buttons) and SiteID (via drop down)
The default will be to show records for the current day.
The page is to have tabs to contain two grids
- one for Mobile Site page views
- one for Main Site page views (see graphic)
The default will be to show the mobile site.
Use paging with 100 records on the page, sorted by RequestID descending.
The username field is to hyperlink to the [login to view URL] page.
[login to view URL]
This page is designed to show records for a single user.
The Date and SiteID settings are to persist from the previous page. (The user will have to back to change them)
Records are to be grouped by day (descending order)
A separate repeater or grid control is needed for each day where there are records.
The records are to be shown in RequestID ascending order