I'm having an issue when I add a checkbox column to my datagrid. I am adding the column during the InitializeLayout event. The problem is, when the form loads, all the checkboxes in the checkbox column are completely filled in. Am I doing something wroing? Here is the code I am currently using in the InitializeLayout Event and a picture to show what is going on. Thanks. -Ted
Dim checkColumn As UltraGridColumn = e.Layout.Bands(0).Columns.Add("Batch", "Batch") checkColumn.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CheckBox checkColumn.CellActivation = Activation.AllowEdit checkColumn.Header.VisiblePosition = 0
hi, sorry everyone but i'm going to keep this thread going. i have the same problem and nothing is working.
i've defined the schema in the designer. First column being a False just to generate the checkbox view.
Bind at runtime with Linq, when i perform that binding at runtime none of the check boxes are editable..at all.
i verified my AllowUpdate properties, CellClickAction, CellActivation. i added them to my debug watch list right before and after binding to the grid. they looked fine.
i've commented all of my DisplayLayout.override assignments.
One thing i notice, when i go back into the schema designer the first column (my check column) datatype goes back to String. if i try to change the datatype at run time it says i cannot change it because the column is bound.
Could that be the problem?
thank you!
Hi Mike,
Thanks for your reply.
But I've changed the database view to give yes for true and no for false.
So don't need to handle that on the grid now.
Regards,
Monica
Is the cell editable by the user?
If you simply set the Style of the cell to Edit, it will display as text with "true" or "false". Changing the text will require a DataFilter or possibly a CreationFilter.
Hello,
I'm populating the Ultragrid from an sql datasource. For the boolean column, its displaying check boxes. I want to display yes/no for these. How do I achieve that?
I tried
foreach(UltraGridRow row in ugrid.Rows)
{
foreach (UltraGridCell cell in row.Cells) { if (cell.Value.GetType().Name.Equals("Boolean")) {if (cell.Value.Equals("true")) { cell.Value = "Yes"; } else { cell.Value = "No"; } } }
}
But since, the datatype is boolean, i'm not able to assign a string value. How do I override the datatype ?
hi tkochi i add checkbox in ultra grid in this way
'/////////////////////////add checkbox in ultragrid/////////////////////////////////////////////////// Me.UltraGrid1.DisplayLayout.Bands(0).Columns.Add("checkbox", "checkbox") Me.UltraGrid1.DisplayLayout.Bands(0).Columns("checkbox").Header.CheckBoxVisibility = HeaderCheckBoxVisibility.WhenUsingCheckEditor
'Aligns the Header checkbox to the right of the Header caption Me.UltraGrid1.DisplayLayout.Bands(0).Columns("checkbox").Header.CheckBoxAlignment = HeaderCheckBoxAlignment.Right
'The checkbox and the cell values are kept in synch to affect only the RowsCollection Me.UltraGrid1.DisplayLayout.Bands(0).Columns("checkbox").Header.CheckBoxSynchronization = HeaderCheckBoxSynchronization.RowsCollection
Me.UltraGrid1.DisplayLayout.Bands(0).Columns("checkbox").Style = ColumnStyle.CheckBox '///////////////////////////////////////checkbox code is end there////////////////////////// End Sub
if u want more help please check my demo code
http://ahmadkhalid44.blogspot.com/2013/05/work-on-ultra-grid.html