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 ?

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.

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

I'm populating the Ultragrid from an sql datasource. For the boolean column, its displaying check boxes. I want to display check for ether unchecked (false )or checked (true) for these. How do I achieve that?

Hi Bill,

There are a number of ways you could acheive that. If the field is required in the data source then the grid will not let the user leave the cell until they fill it in. If you want to handle this on the grid instead of the data source, then you could use an event on the grid such as BeforeExitEditMode, BeforeCellDeactivate, or BeforeCellUpdate to validate the data. Just make sure you use the Text property of the cell in those events, as the Value property reads from the data source and won't reflect changes on the screen that have not yet been saved.

So how might that column be made a REQUIRED entry?

thanks Mike, that was it basically. i was adding the checkbox column to the dataschema, i then found an option to add an unbound column directly in the band/column settings and that did the trick.

thanks

Al

Hi Al,

This doesn't seem like the same issue being reported by others in this thread.

But anyway, if the cells are not editable, then my guess is that your data source doesn't allow editing. As a test, trying binding the DataGridView control to the same data source and see if you can edit in that control. If you can't, then that's a good sign that your data simply doesn't allow it. And if that's the case, nothing you do in the grid will allow you to edit.

If that's not the case, and the DataGridView doe allow editing, then there must be some setting the Wingrid that is preventing it. Perhaps some property on the grid is getting set after you checked it at run-time. Maybe you are loading a layout into the grid and that's turning off editing.