EmployeeId EmployeeName  WorkedHours
    1             ABC        04:00:25
    2             XYZ        07:23:01
    3             PQR        11:02:15

DATEDIFF(Hour, EmployeeTempAttendanceDetail.EmpInTime,EmployeeTempAttendanceDetail.EmpOutTime) as TotalHour,
					  DATEDIFF(Minute, EmployeeTempAttendanceDetail.EmpInTime,EmployeeTempAttendanceDetail.EmpOutTime) - (TotalHour * 60) as TotalMinute,
					  DATEDIFF(Second, EmployeeTempAttendanceDetail.EmpInTime,EmployeeTempAttendanceDetail.EmpOutTime) - ((TotalHour * 60)*60) - (TotalMinute

DECLARE @StartTime datetime
DECLARE @CurrentDate datetime
Declare @Days int
Declare @Hours int
Declare @Minutes int
declare @Second int
SET @StartTime = EmployeeTempAttendanceDetail.EmpInTime
SET @CurrentDate = EmployeeTempAttendanceDetail.EmpOutTime

SET @Days = DATEDIFF(Day, @StartTime, @CurrentDate)
SET @Hours = DATEDIFF(Hour,

function checkTemp(sender,args)
{
     for(var i=0;i<=document.getElementById("CheckBoxList1").firstChild.children.length-1;i++)
     {
          if(document.getElementById("CheckBoxList1").firstChild.children(i).cells(0).children(0).checked)=='true'

 <td id="content-containertable" class="override">
    <div>
    [lots of lines]...<br/>...
    </div>
    </td>

#content-containertable.override{
    width:150px;
    border-color:Silver;
    border-style:Double;
    background-color:Lime;
    }
    #content-containertable.override

While(CAST (@LeaveApprovalFromDate AS DATETIME) <= CAST (@LeaveApprovalToDate AS

ALTER PROCEDURE [dbo].[SpLeaveApprovalSaveNew]
	@LeaveApplicationId int,
	@LeaveId int,
	@EmployeeId int,
	@LeaveApprovalFromDate datetime,
	@LeaveApprovalToDate datetime,
	@LeaveApprovalHalfDay bit,
	@LeaveApprovalApplicaitonDate datetime,
	@LeaveApprovalDuration numeric(18,2),
	@LeaveApprovalDate datetime,
	@LeaveApprovalRemark nvarchar(15),
	@LeaveApprovalApplicationBy

protected void _grid_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow && (e.Row.RowState
& DataControlRowState.Edit) != 0)
{
Control c = e.Row.Cells[2].Controls[0];
this.SetFocus(c);
}
}