Entity Framework Default Values

Question

I am using an EntityDataSource with a DetailsView.

How can I get one of the nullable boolean fields to default to 'checked' when inserting new items?

<asp:CheckBoxField DataField="MyBoolColumn" HeaderText="Bool" />

I have tried setting a default value in the DB, a default value in the properties of the entity and by setting a default value in the constructor of the Entity:

    public partial class MyEntity
    {
    public MyEntity()
    {
           this._MyBoolColumn= true;
    }

Ladislav Mrnka · Accepted Answer · 2011-05-31 14:31:14Z

1

If you want this field to be checked you must make it checked by default in your ASP.NET page or set it in the code behind (handle Inserting and Updating events in the data source) because any your change is overwritten by false from unchecked checkbox in the page. But setting any checkbox by default as true when it is not visible on the page is strange and very user unfriendly.

answered May 31, 2011 at 14:31

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

simon831 Over a year ago

But the CheckBoxField does not have a 'checked' or 'defaultvalue' property so I can't set it. There is also no ID property (so I can't use FindControl).

Ladislav Mrnka Over a year ago

You can indeed find the check box and set its value to checked. Controls offers event which can allow you modifying databound record where you can find a control and set anything you need. For example GridView provides RowDataBound. I remember that we used it quite often when we worked with web forms.

simon831 Over a year ago

This is a asp:CheckBoxField. It does not have an ID property. How can I use the FindControl method?

Ladislav Mrnka Over a year ago

You can iterate controls in the cell.

Collectives™ on Stack Overflow

Entity Framework Default Values

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related