Start Building Professional
Web Apps Today

Grid data validation

I have imported a CSV file into the grid(5000 rows) using pagination.Each colums of a grid will be different data types like integer,number,string, date etc.Some times our client will give wrong datas in that CSV file.Could I validate the all data types are correct for the respective columns?

If it possible ,please explain with example.Do you have any other way to solve this problem! Please help me.

I tried to get the each cell data with "mygrid.cell2(i,j).getValues()" method using for loop(total column count and row count).But the cell values are available only for the first page(page size,exa:10 or 20).I am not getting the cell values of second page.getting script error ( _childIndexes is null not an object).I am expecting your reply soon.

Thanks in advance.

Grid doesn't have built in validators and using client side validation for such big datasets can cause big problems with performance.

>>But the cell values are available only for the first page
Yes, in case of paging the dataset is not fully available on client side, it become available when page visited first time. It is possible to parse all loaded data but it will decrease performance gained by using paging.