How to change gridview cell value on the basis of condition

Question

User-367318540 posted

I have gridview in which INTIME ,OUTTIME ,HOurs and Day column are available and i am directly inserting value from gridview into database.

INTIME	OUTTIME	Hours	Day
2018-05-26 09:22am	2018-05-26 10:22pm	11	1
2018-05-26 09:22am	0	0	0
	2018-05-26 10:22pm	0	0

Now i want on update button click Hours and Day value must be equal to 0, if INTIME or OUTIME does not excit in gridview cell .please guide

Answer 1

User475983607 posted

The current design breaks normalization rules. The Hours and Day values can be calculated from the IN and OUT column on request.  There is no need to have Hour and Day columns in the table.  This will simplify the code and there will be less chance of data bugs.

Answer 2

User-1716253493 posted

Like another said, you don't need to save the result manualy, use calculated field or direct query.

To replace null result for null in/out value use ISNULL() function

ISNULL(a-b,0) as total

Answer 3

User-1174608757 posted

Hi akhterr

 According to your description,I couldn't understand your requirements clearly.Is INTIME OUTTIME  from a table in database or else?

Do you want to change the value of cells or want to change data in Database?So,could  you please post more  details about your code?

It will help us  to solve your problem quickly.

Best Regards

Wei Zhang