DbNetEdit

Top Previous Next

The DbNetEdit control is a database aware form control that is designed to make it easy to maintain database records inside a browser.

Example code

<DNL:DbNetEdit id="DbNetEdit1" runat="server" ConnectionString="SamplesDatabase" FromPart="customers"> </DNL:DbNetEdit>

Basic Properties

The simplest edit control can be created by specifying just the ConnectionString and FromPart properties

ConnectionString

The ConnectionString property provides the information necessary to connect to the database. The connection string can either be an actual connection string or an alias which is resolved by finding a matching entry in the <connectionStrings> section of the web.config file. For details of specifying connection strings see the database connectivity section.

FromPart

The FromPart property specifies the name of the table against which the form will be applied.

<DNL:DbNetEdit id="DbNetEdit1" runat="server" ConnectionString="SamplesDatabase" FromPart="customers"> </DNL:DbNetEdit>

Run Sample

Columns

The Columns collection allows you to specify the columns that you require from the table(s) and or view(s) specified in the FromPart property

<DNL:DbNetEdit ID="DbNetGrid1" runat="server" ConnectionString="SamplesDatabase" FromPart="Products"> <Columns> <DNL:EditColumn ColumnExpression="ProductID" /> <DNL:EditColumn ColumnExpression="ProductName" /> <DNL:EditColumn ColumnExpression="CategoryId" /> </Columns> </DNL:DbNetEdit>

Run Sample

Additional Properties

FixedFilter

Specifies a filter to be applied to the selected edit fields.

<DNL:DbNetEdit ... FixedFilter="country = 'UK'"> </DNL:DbNetEdit>

FixedFilterParameters

Used in combination with the FixedFilter parameter to supply parameter values.

protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); DbNetEdit1.FixedFilter = "country = @country"; DbNetEdit1.FixedFilterParameters["@country"] = "USA"; }

Run Sample

Height

Set the height of the edit control where the edit fields are automatically generated.

<DNL:DbNetEdit ... Height="300px"> </DNL:DbNetEdit>

Run Sample

InitialOrderBy

Set the initial order by which rows are returned.

<DNL:DbNetEdit ... InitialOrderBy="Country,City"> </DNL:DbNetEdit>

Run Sample

ParentControlID

This property is assigned to a child control and specifies the ID of the parent DbNetGrid or DbNetEdit control

<DNL:DbNetEdit ... ParentControlID="DbNetGrid1"> </DNL:DbNetEdit>