Elczar Adame's Shared Points on SharePoint


Incorporating CRUD Facility in WSS 3.0 List

In my previous piece, with the aid of Microsoft Office SharePoint Designer 2007, we have tried to customize the New Item page of a Discussion Board. Now in this paper, we will try to customize the All Item page of a Custom List by incorporating add, edit, and delete buttons on the list. This may provide us a response to some customization requirements of our portal.

At the end of this paper, we are expected to have the crop below:


1.       We will start by creating a Custom List with the following columns: Personnel Code, Last Name, First Name, Middle Name, and Birth Date. We will name it Personnel Information. And for our purpose, let us add an item/entry to our list.

2.       Let us open our Personnel Information in Microsoft Office SharePoint Designer 2007.

3.       To start the customization, let us add an aspx page through File > New > ASPX. For our purpose, we may name it as CustomAllItems. Below is the illustration.


4.       In the design panel, let us add a single-row/single-column table on the page.

5.       In the Data Source Library pane, click Personnel Information, then Show Data. The Data Source Details pane will be displayed.

6.       At the bottom of the Data Source Details pane, uncheck the Show Data Values checkbox. Below is the expected status of the Data Source Details pane.

Data Source

7.       From the Data Source Details pane, select Personnel Code, Last Name, First Name, Middle Name, and Birth Date, and drag them into the table we have created. We can directly edit the header text of our data view by pointing directly to a corresponding column header.


8.       To arrange the columns, click the Property Arrow at the upper-right side of the data view, the Common Data View Task dialog box will be displayed. Below is the illustration:

Data View

9.       In the Common Data View Task dialog box, click Edit Columns link. As illustrated below, the Edit Column dialog box will be displayed to arrange the columns of our data view.

Edit Columns

     10.   To format our Date Birth column, click the Property Arrow of the column, and then DateTime formatting options, then uncheck the Show Time checkbox, and then click OK. Below is the illustration:


11.   Moreover, to add a formulated column, right-click a specific column, the click Insert Formula. Below is the illustration:


12.   Now it time for us to incorporate the CRUD facility in our data view. Click the Property Arrow at the upper-right of our data view, then click Data View Properties. The Data View Properties dialog will be displayed.

13.   As illustrated below, select the Editing tab of the Data View Properties dialog, then check the Show Edit Item Links, Show Delete Item Links, and Show Insert Item Link checkboxes.


14.   Finally, we are going to attach a master page to our CustomAllItems page. As illustrated below, click Format > Master Page > Attach Master Page. The Select a Master Page dialog box will be prompted. Let us select the Default Master Page option, and then click OK. In the Match Content Region dialog box, let us click OK.




15.   As brief as that, without writing a single line of code, we have already created a WSS 3.0 Custom List with CRUD facility.

Hoping to share you something, I am.


Comments on: "Incorporating CRUD Facility in WSS 3.0 List" (5)

  1. I have added edit link in my customized List. But when I try to edit the item in the list the item gets edited but one more blank record is getting added in the list. Can u help me how on this issue?

  2. Hi!
    Sir thanks for the inquiry. I will try to replicate your problem and get back to you as soon as possible.

  3. I found out that in Mozilla firefox it works perfectly but not in IE7. I dont know about IE6

  4. Hi Ashwin,
    Thanks for the feeback. However, the demonstration I have presented was tested in both IE7 and IE6. I have my time this weekend to explore it. Agin, thanks for the feedback.

  5. One more thing I found out if we are modifying the existing AllItems.aspx of a given list then this happens. If we have our own page to handle the list then it works perfectly

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Tag Cloud

%d bloggers like this: