Need to Find the Best Way to Accomplish this task.
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Need to Find the Best Way to Accomplish this task.

Hybrid View

  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Post Need to Find the Best Way to Accomplish this task.

    I have a SQL database that has two tables, one is the employee table, and the other is the schedule table. The employee table has employee ID (key), Employee Name. The schedule table has Employee ID (linked to employee table), Date, StartTime (time that an employee starts), EndTime (time that an employee ends). I would like to display (and allow editing) of this table, based upon these two tables:

    Employee ID Date1 Date2 Date3 ... (one for each day of week)
    John Smith StartTime: StartTime: StartTime:
    EndTime: EndTime: EndTime:

    Michael Berg StartTime: StartTime: StartTime:
    EndTime: EndTime: EndTime:

    ... (for all employees)

    Each cell represents the starting time and ending time of the employee for that date (it varies daily).

    What is the best way to acomplish this? Is a nested gridview possible to implement this? Thank you in advance for your help.

  2. #2
    Join Date
    Jun 2010
    Location
    Cairo, Egypt
    Posts
    17

    Re: Need to Find the Best Way to Accomplish this task.

    hay,
    you just need to create a simple view into your database, to get your data, and read this view and add it to your GridView datasource
    and when you insert or update or delete you will actually reflect only the schedule table
    You Don't Have to Rate Me.
    I'm Not a Civilized Man I'm the Civilization it self
    White or Black, Living or Dieing and 0 or 1 that's MY life
    iam an Object in Object Oriented Life
    010011000111010101110110001000000100110101111001001000000101000001100011

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center