smartDBforms.NET Demo

Category form has table layout, similar to the layout of the ASP.NET DetailsView server control. The table was auto generated in design time and then our web designer has added styles and a header.

This sample demonstrates how to extract the auto-increment id of newly inserted values. After a new record is inserted its id is displayed in a message.

The Picture column is of type 'image' which is represented as byte[] in ADO.NET. A FileUpload server control is automatically generated for this column when the form is displayed in edit mode.

The Description column is of type ntext, which means that its values are not limited in size. In this demo HTMLEditorTemplate is used and the text is edited with the built-in HTML Editor.

Default values for Insert mode are also demonstrated. The CategoriesDataSource SmartDataSource has three input parameters for the insert operation. The Description parameter has been given a default value. When the form is displayed in Insert mode the Description text field is prefilled with this default value.

In this example paging buttons are used for changing the currently selected record. The event handlers for this buttons have been easily implemented to invoke the navigation methods provided by SmartDBView. When the Next button is pressed the SetNextRowIndex method is called. This method takes care of incrementing the RowIndex and rebinding the form.

This form also uses the query parameter “CategoryID” which determines the currently displayed record. This mechanism is used by the Products form to open the details of the category of the displayed product.

When CategoryID query parameter is specified, the paging buttons are hidden. The Insert and Delete buttons are also hidden during databinding.

Open in new window


CREATE TABLE [dbo].[Categories](
	[CategoryID] [int] IDENTITY(1,1) NOT NULL,
	[CategoryName] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Picture] [image] NULL,
 CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED 
(
	[CategoryID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Start PageShort introduction to smartDBforms.NET Products FormProducts table form. Demonstrates: - Foreign key relation - SmartDBLabel - SmartDBLinkedLabel - custom error handling - navigation drop-down list - two-way databinding - linking to another form - ad hoc properties Employees FormDisplays and edits the Employees database table. Image upload, large text, foreign-key columns,date editing popup calendar. Demonstrates the Clone command button. Localization in Spanish. SuppliersInteracting with GridView. Placing SmartDBControl in TabStrip MultiView. EmptyDataTemplate template. Using MonitorParameters property. Region FormSimple example for the Region table. Shows the basic elements of smartDBforms.NET. Standard paging. Search ExampleDemonstrates: Search form for SelectParameters, wild character, EmptyDataTemplate property, DropDown pager style, hyperlinks as command buttons ASP.NET AJAXShows how to use smartDBforms.NET with ASP.NET AJAX. Category FormTable layout, image upload, large text, html editor,custom paging, custom error handling, disable edit insert, id of inserted items, default insert values	Table layout, image upload, large text, html editor,custom paging, custom error handling, disable edit insert, id of inserted items, default insert values Open in new window Category form has table layout, similar to the layout of the ASP.NET DetailsView server control. The table was auto generated in design time and then our web designer has added styles and a header. This sample demonstrates how to extract the auto-increment id of newly inserted values. After a new record is inserted its id is displayed in a message. The Picture column is of type 'image' which is represented as byte[] in ADO.NET. A FileUpload server control is automatically generated for this column when the form is displayed in edit mode. The Description column is of type ntext, which means that its values are not limited in size. In this demo HTMLEditorTemplate is used and the text is edited with the built-in HTML Editor. Default values for Insert mode are also demonstrated. The CategoriesDataSource SmartDataSource has three input parameters for the insert operation. The Description parameter has been given a default value. When the form is displayed in Insert mode the Description text field is prefilled with this default value. In this example paging buttons are used for changing the currently selected record. The event handlers for this buttons have been easily implemented to invoke the navigation methods provided by SmartDBView. When the Next button is pressed the SetNextRowIndex method is called. This method takes care of incrementing the RowIndex and rebinding the form. This form also uses the query parameter “CategoryID” which determines the currently displayed record. This mechanism is used by the Products form to open the details of the category of the displayed product. When CategoryID query parameter is specified, the paging buttons are hidden. The Insert and Delete buttons are also hidden during databinding. Open in new window Open in new window CREATE TABLE [dbo].[Categories]( [CategoryID] [int] IDENTITY(1,1) NOT NULL, [CategoryName] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Picture] [image] NULL, CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED ( [CategoryID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Copyright © 2006-2010 Adillis \| smartDBforms.NET Forum \| Send feedback