Date display in data bound grid

[James A Frisby(For EPS - Computer Software)]

I am using the db grid to display some info that contains date fields. The grid defaults to showing these dates with a "button" that activates a date picker. I''d like to supress the button and just have the date read-only
Jim Frisby
conocophillips.com

[Administrator]

You can just hide the button by setting style.ShowButtons = Hide for that GridBoundColumn. You can also set style.ReadOnly = true for the column.

Or, another option would be to set style.CellType = "Static" for the GridBoundColumn.

GridStyleInfo style = this.grid.Binder.InternalColumns["TheDateCol"].StyleInfo;
style.CellType = "Static";
style.CellValueType = typeof(DateTime);
style.Format = "MM/dd/yyyy";

This code assumes you have not explicitly added GridBoundColumns to teh grid. If you have, then use style = grid.GridBoundColumns["TheDateCol"].StyleInof to get the style object for the column.

[James A Frisby(For EPS - Computer Software)]

Clay,
I tried several of these options, I would like to set the whole grid (all the columns) to read only, as I''m editing and creating records on another form, however, when I try to access the "GridBoundColumn" collection, it''s empty.

I haven''t explicitly added any columns, just bound a dataset to the grid.

I also tried to iterate all the cells in the grid (with bound data) trying to set showbutton to "hide", and trying to set the cells to readonly. it doesn''t raise an error, but it doesn''t change the property either.

Jim
>You can just hide the button by setting style.ShowButtons = Hide for that GridBoundColumn. You can also set style.ReadOnly = true for the column.
>
>Or, another option would be to set style.CellType = "Static" for the GridBoundColumn.
>

>GridStyleInfo style = this.grid.Binder.InternalColumns["TheDateCol"].StyleInfo;
>style.CellType = "Static";
>style.CellValueType = typeof(DateTime);
>style.Format = "MM/dd/yyyy";
>

>This code assumes you have not explicitly added GridBoundColumns to teh grid. If you have, then use style = grid.GridBoundColumns["TheDateCol"].StyleInof to get the style object for the column.

[James A Frisby(For EPS - Computer Software)]

Clay,
After reading some other articles on your site, I tried

g1.Binder.InternalColumns(i).StyleInfo.ReadOnly = True

That seems to have worked
Jim
>
>Clay,
>I tried several of these options, I would like to set the whole grid (all the columns) to read only, as I''m editing and creating records on another form, however, when I try to access the "GridBoundColumn" collection, it''s empty.
>
>I haven''t explicitly added any columns, just bound a dataset to the grid.
>
>I also tried to iterate all the cells in the grid (with bound data) trying to set showbutton to "hide", and trying to set the cells to readonly. it doesn''t raise an error, but it doesn''t change the property either.
>
>Jim
>>You can just hide the button by setting style.ShowButtons = Hide for that GridBoundColumn. You can also set style.ReadOnly = true for the column.
>>
>>Or, another option would be to set style.CellType = "Static" for the GridBoundColumn.
>>

>>GridStyleInfo style = this.grid.Binder.InternalColumns["TheDateCol"].StyleInfo;
>>style.CellType = "Static";
>>style.CellValueType = typeof(DateTime);
>>style.Format = "MM/dd/yyyy";
>>

>>This code assumes you have not explicitly added GridBoundColumns to teh grid. If you have, then use style = grid.GridBoundColumns["TheDateCol"].StyleInof to get the style object for the column.

[Administrator]

Here is a minimal sample with aReadOnly grid and a DateColumn not showing the buttons. ReadOnlyDates_4890.zip