Getting started with a blog post table

This work will be similar to the work done on a digital content table. We will apply the recent concepts to build a blog post table and the supporting pages.

There are three web form examples planned for this blog post task. You must first create a database table to hold your “blog posts”.

Then, you must create new table adapters and methods in your “myAssignment” data access layer (i.e. a dataset).

.

A note about SQL Server data types

We intend to store blog posts, which is typically character-oriented data, in a SQL Server database table. What data type must we use for the column? varchar(max)

The following note is from the SQL Server 2008 Books Online (November 2009):

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

.

Our first job – enable blog post creation

Our first example today simply enables us to create a new blog post. We’ll use a no-code DetailsView, and configure it for insert and edit (in addition to its default “display” functionality).

.

A viewer page with a ListView

Here, we will introduce the ListView data display control. It enables the presentation of multiple objects/rows, using your own format and layout.

.

A viewer page with a FormView

Here, we will introduce the FormView data display control. It enables the presentation of a single object/row, using your own format and layout.