.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to create a newsletter using 2 lists in SharePoint Foundation

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint


I have 2 lists

Letter and Articles.

They are linked based on LetterID.

Letter contains:

ID, Archived, PublishingStatus

Articles contains:

ID, Subject, Header, Article, Status

I want to create a layout like so:

Letter <Letter.ID>

    <General text>

    ForEach <Article.Subject>

         Print <Article.Subject>

    Foreach <artictle.Header

        Print Article text


So I want to display only 1 letter.

Hope thiss makes sence!

View Complete Post

More Related Resource Links

Sharepoint Foundation - Create and deploy custom edit/view forms for external lists


Firstly, we are using sharepoint foundation so Infopath forms are not an option for us.

We have a Visual Studio sharepoint project which deploys a complete sharepoint site. The site contains a number of external lists and we want to be able to create customised view/edit forms for these lists and add them to our Visual Studio project so they can be deployed as part of the new site. The idea is that we can deploy the solution to a fresh site with a default set of forms which can then be customised for different implementations of the site.

Here's the steps we have been using to try and do this:

1. Deploy the base project (BDC) to the sharepoint site

2. Create external lists based on the BDC content types

3. Use Sharepoint Designer to create new edit/view forms for the lists and set these as the default forms for the list

3. Save the site as a template

4. Import the template into a new Visual Studio project and select the lists we require. This gives us a List Definition, a pages module (with element file), an elements file and a schema file (both for the List Instance).

5. We then add the contents of the imported project to our main solution as follows:

  • Create a new List Definition (including List Instance)
  • Copy the contents of the imported Elements.xml to the Elements file for our List Instance.

Quick Note: Create Lists with Custom Content Types in SharePoint 2010

Learn how to create a list in SharePoint Server 2010 and associate it with a new content type. Next, you disassociate the list from the content type and then delete the list.

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

Sharepoint foundation and distribution lists

Hi, I have a contact list in outlook exchange which contains a list of contacts and distribution lists. I would like to move this data onto a sharepoint list. The individual contacts have copied across with no problems the distributions lists which have groups of users inside them did not copy across. Can anyone tell me if they are supported at all in sharepoint foundation 2010?

How to create a custom page layout in sharepoint foundation 2010



I need to create a custom page layout in sharepoint foundation 2010.

I am aware that wss 3.0 and sharepoint foundation do not have the publishing infrastructure.

I need to know if the same procedure that is used to create custom web part pages in WSS 3.0 is to be used in SharePoint foundation too or are there other ways.

I am relatively a fresher to sharepoint technology.Please help.

Thanks in advance:D.


Unable to create new web application in sharepoint foundation 2010


I installed and successfully setup development environment in win 7 ultimate through PowerShell. When I tried to create new web application in “Manage web application” option of central admin, I found “New” button greyed out. I applied all the solution while browsing internet:

1.       I run internet explorer as administrator

2.       I run central admin as administrator


Surface data in external lists in Sharepoint Foundation 2010



I have seen numerous articles for the above, but they all just gloss over the step I am having a problem with, assuming nobody will have an issue with it. 

I'm trying to create an External Content Type so I can use it to display external data (from SQL Server) in an External List.  When I get to the step to add the connection and the SQL Server connection dialog box appears, I enter the server and database names and click OK with the Connect with User's Identity radio button still selected and I get the error message: login failed for user ''. The user is not associated with a trusted SQL Server connection.  I've tried to read up on the different purposes of the radio buttons on offer on this dialog box but don't know which I should really be using and don't think I can create a target application ID anyway in Foundation (for the other two radio button options) as that has to be done in the secure store services.  Can anybody help with this?

SharePoint 2010 Foundation - How To create PressRelease functionality




I need to create means to create pressreleases. In SharePoint 2010 Standard/Enterprise that isn't such a big deal. I create a pagelayout et voila. Seems that Foundation does not provide this functionality.

My Questions:

  1. Is this correct?
  2. If not how can I create this functionality?

I already found this link but...



Error while accessing the Sharepoint Foundation http://sharepoint server:port/_vti_bin/lists.asmx



Error while accessing the Sharepoint Foundation http://sharepoint server:port/_vti_bin/lists.asmx. we got below error. please help us to sort this below error.

The top XML element 'string' from namespace 'http://schemas.microsoft.com/sharepoint/soap/' references distinct types Microsoft.SharePoint.SoapServer.SoapXml.SoapXmlElement and System.String. Use XML attributes to specify another XML name or namespace for the element or types.


Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: fe7f8707-44db-4744-8a78-337a5e8a80de

Date and Time: 10/25/2010 10:32:28 AM

Thanks & Regards,



Displaying SharePoint lists in Web Parts

When you create a built-in or custom list in Microsoft Windows SharePoint Services, Windows SharePoint Services creates a Web Part, a basic building block of a SharePoint site, to display that list. These Web Parts are called List View Web Parts. Windows SharePoint Services stores List View Web Parts in the site collection Web Part gallery. (The site collection Web Part gallery is the most central gallery of Web Parts for a work group. By default, the gallery name is the name of the site, such as "Our Team Site Web Part Gallery." )

SharePoint Tutorial - Lists

A list is a feature in SharePoint that stores a lists of information. For example, a list can be created to store web links in the human resources team site. A list is usually created for a specific type of information. Lists can contain metadata to describe the particular information in more detail and to make it easier to find.

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

Duplicate column names from forms in SharePoint lists



I'm in the process of migrating from a WSS 2 site to WSS 3/MOSS. On the old site I used an Infopath 2003 form for absence requests. During the migration I now use Infopath 2007. There wasn't any problem initially when the form was stored with the SharePoint form library. However, when I published the form as a content type from Infopath 2007 and then added that content type to the form library, there are two columns for each piece of data from the form. (One from the content type and one from the form list.) I relinked each old form (list content type) to the new AbsenceRequest content type and removed the original one from the list. However, the duplicate column names are still there. Since they came from the Infopath form, they are not editable or deletable from the SharePoint list management interface. The duplicate column names make it tough to build views since it isn't apparent which column to use in the form building UI. It can be determined form the overview display, but it is very cumbersome.


Does anyone know a way to get rid of the old, absolute, columns?

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

How to create scrolling table for columns in a SharePoint Designer Data View


I have a fairly complex SharePoint Designer 2007 Data View they have added two more requirements.

1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place.  This is only one list not two, and because of some other requirements I have it must remain to be just one list.

2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.

The first requirement is more important than the second, but preferrably I need to do both.

I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?

I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.

So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/  or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png

I failed to mention that 3/4 of the columns are HTML Calculated fields wh

What is the best way to Create Ageing Report in SharePoint 2007?


Hi Experts,

I need your point of view about this and please advise,

My client have made a request to generate Ageing Report thru their SharePoint 2007, FYI all invoice was scan and upload to sharepoint and save as PDF file under Document Library. During the scan, certain information will capture automatically and save it into field that we defined inside the Web Form.   

Below is the basic input we capture:

Vendor Code, Vendor Name, Invoice Number, Invoice Date, Currency, Invoice Amount

Report Requirement (display list and group of:)

- Vendor Code, Vendor Name, No. Of Invoice, Total Payable, Ageing 0-30, Ageing 30-60, Ageing 60-90, Ageing>90 

So my question is, what is the best platform to create this Ageing Report??

because when i try to design the report thru Visual Studio (Reporting Services), i can't identified which database should i connect and which table is store all the invoice information in SharePoint.

Any idea guys?? anybody have implemented it before??


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend