Validation on Databound Event of Grid

[Michael]

My application consists of a couple of pages of data populating a grid.  This data is made up of dirty data that needs to be cleaned up.  The user wants to see if we can populate the data and when the page renders, show the cells with bad data in them -- basically run the validation code for every cell of every row in the grid. .  My guess is that this would be cpu intensive and would need to occur on the databound event of the grid.  Is this even possible? 

 

Error Type Col1     Col2     Col3   Col4    Col5

Out of Range

[Eyup]

Hi Michael,

You are correct, you can achieve this requirement using the dataBound event handler:

.Events(e => e.DataBound("gridDataBound"))

JavaScript:

<script>
    function gridDataBound(args) {
        var grid = this;
        var items = grid.items();

        for (var i = 0; i < items.length; i++) {
            var item = $(items[i]);
            var dataItem = grid.dataItem(item);
            if (dataItem.ID == "5" || dataItem.ProductName.indexOf("5") >= 0) {
                item.find("td")[0].style.backgroundColor = "lime";
            }
        }
    }
</script>

Alternatively, you can use a template to achieve this requirement:
https://docs.telerik.com/aspnet-mvc/helpers/grid/faq#how-to-apply-conditional-logic-to-client-column-templates

Similar to this:
https://dojo.telerik.com/@bubblemaster/EjoBAn

I hope this will prove helpful.

Regards,
Eyup
Progress Telerik

[Michael]

Thanks for the reply.  What's funny is I didn't even realize I had posted this.  I could have sworn my browser died and I never got a chance to go back to repost.  I think I am going to push back on this as this will require me to convert all my server side validation code to javascript validation code.