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.
kmacsouris
Member
1 Points
7 Posts
Information on how to calculate a formula, save it to a database, and post result to a grid box
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.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Information on how to calculate a formula, save it to a database, and post result to a grid b...
Feb 04, 2013 12:27 AM|LINK
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?
TheHoboLord
Member
12 Points
6 Posts
Re: Information on how to calculate a formula, save it to a database, and post result to a grid b...
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.
LINK: http://www.c-sharpcorner.com/uploadfile/dhananjaycoder/Asp-Net-gridview-with-linqdatasource/
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!