General Design Help

Heyas!

I've attached a jpg of a monthly schedule for work assignments. This is just a generic example I pulled off the web.

What is the best way to set something like this up in .NET?

Is a datagrid control robust enough to handle this? Can you set variable column widths, colors, etc. to look something like this?

How would you set up the database behind the scenes?

I did a very similar project in VB6 that worked pretty well. But, I used the "brute force" method with labels and textboxes, etc. Had something like 400 lables on the screen - real PITA to address in code.

Thanks!

Quote:

---

Originally posted by Dador
Heyas!

I've attached a jpg of a monthly schedule for work assignments. This is just a generic example I pulled off the web.

What is the best way to set something like this up in .NET?

Is a datagrid control robust enough to handle this? Can you set variable column widths, colors, etc. to look something like this?

How would you set up the database behind the scenes?


Thanks!

---

Yes, from what I've tested myself out with the datagrid, it can handle that.

Quote:

---

I did a very similar project in VB6 that worked pretty well. But, I used the "brute force" method with labels and textboxes, etc. Had something like 400 lables on the screen - real PITA to address in code.

---

Dude... you should have used the flexgrid!!

Quote:

---

Originally posted by Dador
I did a very similar project in VB6 that worked pretty well. But, I used the "brute force" method with labels and textboxes, etc. Had something like 400 lables on the screen - real PITA to address in code.

Thanks!

---

Oh how sweet :D

You could write your own grid control for this task. Probably perform better than the flexgrid too.

Thanks for the replies, fellas.

Well, the reason I didn't use a grid in the VB6 version was... I couldn't figure out how to do the database. Really, it wasn't too bad, as the labels and boxes were arrays. I fed the employees into an array as well and just looped through. It was a little (lot, haha) Rube Goldberg style, but it was rock solid at least. :)

Anyway, like I stated, I can't get my mind around how to set up the database to seamlessly integrate into something like this.

Right now I'm using a table with the employee info (name, id, etc.) and another table with 3 columns: id, workdate, workcode. So, for any given day with 60 employees, I have 60 records. Times the last two years...

What I really want to do is break each day down into 15 minute segments, so I can have multiple codes. Say a guy comes in normal for 3.5 hours, then goes home sick for the last 4.5 hours.

What way would you set up the database to handle all this? How would you codify all that to address it?

Again, I'm just looking for general design help, not the actual code. Seems I can't figure out the high level (design) stuff; the coding is just hard work, not perplexing though.