I have a gridview(editable).
It may have more than 1 row with columns startdate and enddate.
StartDate EndDate
4/4/09 6/6/09 (valid-existing row)
1/2/09 3/3/09 (valid-existing row)
7/7/09 9/9/09 (valid- edited row)
3/3/09 6/6/09 (Invalid - edited row )
When you see the above table/gridview, you will know what I want to validate.
I should be checking whether there is any row having start-end dates lying within the existing date range, if so I should invalidate them.
I shd have only distinct date range in my rows.
How do I do that.
May be Useful note: I will be able to check which column name I tried editing in that row.
Do any of you have some ideas how to create a logic to accomodate my validation issue in my webbased gridview control ?
thanks in advance
It may have more than 1 row with columns startdate and enddate.
StartDate EndDate
4/4/09 6/6/09 (valid-existing row)
1/2/09 3/3/09 (valid-existing row)
7/7/09 9/9/09 (valid- edited row)
3/3/09 6/6/09 (Invalid - edited row )
When you see the above table/gridview, you will know what I want to validate.
I should be checking whether there is any row having start-end dates lying within the existing date range, if so I should invalidate them.
I shd have only distinct date range in my rows.
How do I do that.
May be Useful note: I will be able to check which column name I tried editing in that row.
Do any of you have some ideas how to create a logic to accomodate my validation issue in my webbased gridview control ?
thanks in advance