Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 15, 2013 07:35 PM by TheHoboLord
Feb 02, 2013 10:43 PM|LINK
I am new to ASP -VB. I've been asked by my employer to build a database driven site in vb that will do interval reporting. For the most part I've been successful. I've run into an issue and it is completely due to my lack of SQL/VB knowledge.
I need to calculate schedule adherence and how many employees are scheduled for the day.
Scheduled adherence is calculated--> hours-lost hours/hours.
FTE employees is calculated--> hours/8
The table that I created has the following: FTE, Hours, LostHours, AuthorizedHours, SA. Our HR department would enter in hours, lost hours, and authorized hours. On the webform, HR clicks on a drop down list, chooses whatever department, and a grid gets
populated with the above entered data. How do I get it to add the results automatically for FTE employees and SA?
If there is an example that would point me into the right direction, I'd appreciate it.
Feb 04, 2013 12:27 AM|LINK
How do I get it to add the results automatically for FTE employees and SA?
Add what results?
I'm not clear about what you mean.
Do you wanna let HR add these time columns?
Can you elebrate it more?
Mar 15, 2013 07:35 PM|LINK
Using LinqDataSource really helped me.
This allows for easy database access.
The only thing you need to do is control the events.
This will get you started.
LINK : http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx
This guy has alot of helpful tutors too.
Have a Great Day!