I had a datagridview in my Winform application which fetch data from SQl Server database
using the query below and fill it to datatable swipedata
SELECT EmpSwipedataBank_tbl.Swipedataid AS [swipe id], EmpSwipedataBank_tbl.empid AS [Emp Id], EmpSwipedataBank_tbl.SwipeDate AS [Swipe Date], ShiftDayDetails_tbl.DayOFWeekname AS [Day of Week], ShiftDayDetails_tbl.DayStatus AS [Day Status], EmpSwipedataBank_tbl.Intime AS [Swipe In], EmpSwipedataBank_tbl.Outtime AS [Swipe Out], EmpSwipedataBank_tbl.ApprInstatus AS InStatus, EmpSwipedataBank_tbl.ApprOutStatus AS [Out Status], EmpSwipedataBank_tbl.Invalue AS [In Value], EmpSwipedataBank_tbl.Outvalue AS [Out Value], EmpSwipedataBank_tbl.IsAdjusted AS [Is Adjusted], DATEDIFF(MINUTE, EmpSwipedataBank_tbl.Intime, EmpSwipedataBank_tbl.Outtime) AS Duration, ShiftDayDetails_tbl.TotalDuration + ShiftDayDetails_tbl.BreakDuration AS [Total Shift Time], WorkLimitDetails_tbl.MaxWorkLimit AS [MAX WORK LIMIT],'0' as Difference , DATEDIFF(MINUTE, EmpSwipedataBank_tbl.Intime, EmpSwipedataBank_tbl.Outtime) - WorkLimitDetails_tbl.MaxWorkLimit AS Difference1 FROM EmpSwipedataBank_tbl INNER JOIN EmployeShift_tbl ON EmpSwipedataBank_tbl.empid = EmployeShift_tbl.Empid INNER JOIN ShiftDayDetails_tbl ON EmployeShift_tbl.Shiftpk = ShiftDayDetails_tbl.ShiftPK AND (SELECT DATENAME(dw, EmpSwipedataBank_tbl.SwipeDate) AS Expr1) = ShiftDayDetails_tbl.DayOFWeekname INNER JOIN WorkLimitMaster_tbl ON ShiftDayDetails_tbl.ShiftPK = WorkLimitMaster_tbl.ShiftPk INNER JOIN WorkLimitDetails_tbl ON WorkLimitMaster_tbl.WorkLimitPK = WorkLimitDetails_tbl.WorkLimitID AND ShiftDayDetails_tbl.DayOFWeekname = WorkLimitDetails_tbl.WeekDayName INNER JOIN EmployeeDesignation_tbl ON EmpSwipedataBank_tbl.empid = EmployeeDesignation_tbl.empid WHERE (EmpSwipedataBank_tbl.SwipeDate BETWEEN @Param1 AND @Param2) AND (EmployeeDesignation_tbl.BranchLocationPK = @Param3) ORDER BY [swipe id]
And I i databind the data using datasource property
tblNonAdjusterdata.DataSource = swipedata;
but the issue is Iam getting a readonly exception when trying to change the cellvalue of datagidview
tblNonAdjusterdata.Rows[i].Cells[12].Value = Math.Truncate(b.Subtract(a).TotalMinutes);
tblNonAdjusterdata.Rows[i].Cells[15].Value = Math.Truncate(float.Parse(tblNonAdjusterdata.Rows[i].Cells[12].Value.ToString()) - float.Parse(tblNonAdjusterdata.Rows[i].Cells[14].Value.ToString()));
Can anyone advice why my datagidview is not editable