Lightning Tools Blog

SharePoint Tools, Web Parts and Discussions

Create, Update BDC Data in a SharePoint List Style Web Part

We are currently developing a new web part that will enable users to manipulate data through a SharePoint Style List. You will be able to input new data, and change data via a grid view web part. We feel that many users don’t just want a read only list of data presented to them in SharePoint, but a more flexible way of updating data also. In some respects this is going to be very similar to that of a SharePoint List, using the same style toolbar to create new rows, and using the same Settings button on the toolbar to change the look and feel of the Grid such as Adding/Removing Columns, changing the sort criteria, add grouping levels, and so on. Users can expect to get their hands on the new web part around mid to late June. Take a look below at how this web part is coming along:
This view is the default view, and you can see that users will find it seamless to use after getting used to SharePoint Lists. It has a similar toolbar, and an easy way to edit data inside the grid.
Via the easy to use toolbar, you can choose which sort order you would like to apply, similar to that of switching views in a SharePoint List:
The Web Part is also very simple to configure. Once you have a BDC Application Definition File uploaded, all you need to do, is configure the LobSystem, LobSystem Instance, and the Entity within the Shared Properties of the Web Part.
We will keep you updated with the Web Parts progression. In the meantime, feel free to email us with any suggestions that you may like to see in the Web Part. Also, if you have five minutes spare! Help us name the web part.
 <Brett />
Print | posted on Friday, May 09, 2008 3:13 PM

Feedback

# re: Create, Update BDC Data in a SharePoint List Style Web Part

left by Fatimah Lioe at 5/12/2008 6:08 PM Gravatar
I am interested to know how this webpart handle the foreign key in the table? Would we able to configure this foreign key to look up the parent table and display the value?

BTW, when is this webpart going to be release?

Thanks!

# re: Create, Update BDC Data in a SharePoint List Style Web Part

left by Brett Lonsdale at 5/12/2008 8:40 PM Gravatar
Hi, Thank you for your comment.

For Display purposes, this web part is going to allow Web Part Connections, and therefore yes, you will be able to display Parent or Child tables with a link from any column including the ID itself.

As far as validation is concerned, the Web Part will handle any validation that is enforced on the database table(s). So deletion of a record may or may not allow the deletion if a related record appears in another table. If Cascade Deletion is allowed, then the Web Part will allow the deletion of the record. Likewise with ammendments made to the record.

We will be looking at middle to late June for the first trial release of this web part.

I hope this answers your question.

<Brett/>
Title  
Name
Email (never displayed)
Url
Comments   
Please add 5 and 7 and type the answer here: