timetable layout in c#

Posted on 2008-11-10
Last Modified: 2012-05-05
Employee(EmployeeID, etc)

Hi Experts,
I want to show a timetable style information.Top row will have subjects(e.g. sub1,sub2,sub3,etc). with the left colum i will have employee names(e.g. employee1,employee2, etc). All these employees are trained on these courses. I need to add no of hours in each cell for any subject training by an employee. Then i have to add a hyperlink to each cell to drill down for employee. I can get this done using SQL but i cannot reference each cell  or make a hyperlink. For this reason i m thinking of sticking to to c#
I tried to work it out usind gridview, repeater, datalist, arrays etc but could not work out .Any ideas & exmaples will be highly appreciated.
I am using c# 2005 with sql server.
Question by:mmalik15
    LVL 96

    Expert Comment

    by:Bob Learned
    I don't understand what you hare looking for, and how I can help you.  Are you looking for a cross-tab?  Are you having problems creating the HTML for the GridView?

    Author Comment

    I want a layout like this.
          Subject1      Subject2
    Employee 1      15      12
    Employee 2      13      14
     All employees get trained on different subjects and a record of the training hours is kept along with additional notes of training. I want to create a form where we can see the hours in a timetable like layout as above and hours (e.g. 15,12,13 or 14) should be hyperlinked to another page where detailed notes can be seen for the subject trainig.
    The problem is getting this kind of layout. I can use gridview to display  records like below
    Subject1      Subject2
    15      12
    13      14
    but how to get employees across on the left hand side. If i use seperate gridview for employees it gets difficult to align employees and hours.  If i use SQL to get this kind of layout then i can not make hours hyperlink to the other page. So how can we use gridview or any other datacontrol to get this kind of layout and then can we make hours a hyperlink ?

    LVL 96

    Accepted Solution

    Yes, you are talking about a cross-tab.  What is the underlying data source for the GridView (Access, SQL Server, ...)?

    SQL Server example:

    Cross-Tab reports in SQL Server 2005

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
    Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now