Setting CheckBox Values too Slow

[Chris Wescott]

Hi, I have a parent Child GGC that has a checkbox in both the parent and child. The Checkbox is a mapped column to the datasource and I need to be able to switch the values in this column programatically. IE. Check mark all rows/ Uncheck all rows with this event being fired from a button. See Attachment for table visual Currently I loop through each row in the dv.tables.rows and I set the value to either 1 or 0. I have also tried add/removing the Checked column from the datasource and adding an expression but this makes the column readonly. Is there a way to change a column''s value in the grid. Ie using the grid''s power to change the underlying datasource. Here is a snippet of my current SLOW code. DV = MyDS.Tables(1).DefaultView DV.BeginInit() Dim mydt As DataRow() = DV.Table.Select(DV.RowFilter) Dim Curvedr As DataRow Dim J As Integer For J = 0 To mydt.Length - 1 mydt(J)("Checked") = 1 Next DV.EndInit() Regards, Chris Wescott

Table Structure.zip

[Administrator]

Hi Chris, Sorry for the very late response. This can be achieved by the following two ways. Approach 1: By using QueryCellStyleInfo event, you can check or uncheck the values. This approach will be faster because it draws only the displaying rows on the screen. Approach 2: The record value of each row is changed by iterating through a loop. But it’s a bit slower process. Thanks for the patience. Best regards, Madhan Sample : CheckBoxOnButtonClick_GGC