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

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

SharePoint Designer solution linking two lists the right one?

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

Hello my name is John,

I'm a newbie SharePoint professional with a MCTS config trying to learn the vast world of SharePoint, any

help will be greatly appreciated :)

ok, so here's the project i'm working on:

we are trying to migrate this web application that uses ASP.NET front-end and MS SQL 7.0 as the backend

to SharePoint..... the web app is pretty much a RFP (Request for Proposals) management sytem with files

attached to each RFPs. I did some research and talked to some other people, I know I have a couple of

solutions depending on my requirements (BDC, custom coding, SharePoint Designer, etc). The problem I've

come across is with these attached files. 

This web app is pretty old and I believe MS SQL 7.0 does not have the capability to store files in the DB it

self... so the attached files are not in the DB, and the links of the documents

are not in the DB also.....basically, the app uses the .NET File System Object Model and the ASPs uploader

mechanism to upload files and view them, there's a key (an ID number) in the DB for each item(RFPs) and

whenever there's files to upload these web folders with matching ID numbers are created as the folder path

name,...and the front-end page just inserts a html href link to

View Complete Post

More Related Resource Links

How to connect 2 Lists Sharepoint site through Designer

Hello to all I am siddiqali new to sharepoint 2010,I want to know how can i connect 2 lists in sharepoint 2010 without using code ,look ups and visual webpart. I am guessing that it can be posibble through designer,but as i am new to sharepoint i am not able to do it  Example If in 1 list student number,name,class,section is existed ,In other list if we enter student number in text box we should get the student information   Thank You, MD.SIDDIQALI

Sharepoint Designer 2010 - How to add custom columns to lists



When creating a new view - I would like to add an extra column which I could use as a custom hyperlink to fire up the EditForm.aspx or my on custom ediform.  I would like it.  Is there a step by step that shows hwo to do wthis with SP 2010 and SPD 2010?

Thanks in advance



problem in applying SharePoint Designer Workflows to Lists in my Web application


Hi Mark,

I am so happy finding your forum.

I have installed MOSS 2007 with SP2 on a Windows Server 2008. I had no problem in configuring and creating Web Applications and Sites. However, there seems to be a problem in applying SharePoint Designer Workflows to Lists in my Web application. The problem is that the workflow I create to start automatically when an item in the List is changed doesn't work. The workflows works fine if it's started manually from an item in the list, but it's doesn’t work when it's started automatically with an item change in the list. I have checked the workflow on another MOSS 2007 installation on Server 2003 and it works fine. Have I missed something in the configurations?

Thanks for y

how to open custom lists schema via SharePoint Designer


Hi everybody,

I have a custom list, lets call it MyList (http://myserver/Lists/MyList/) with several fields in it.
I would like to open this lists schema (http://msdn.microsoft.com/en-us/library/aa543477.aspx).
I do not mean the the unghosted version in ...\14\TEMPLATE\FEATURES\CustomList folder, but to open the the schema for this particular list via SharePoint Designer. I do not see such a file when I open MyList folder with SPD...
Can anyone advice on this?

Thanks in advance!


Lists and Libraries are not populated in Sharepoint 2010 Designer in server 2008



We have installed SharePoint Foundation 2010 in Windows server 2008 R2 machine. Also having SharePoint Designer 2010 in the same machine. While opening any sites in the Designer, it does not populating the lists and libraries in the same site.

Is there need to apply any fix for Windows server 2008 to solve this?If then which fix..

Thanks in Advance,


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).

SharePoint Designer

This video series shows you how to quickly and easily build complex business solutions on the SharePoint platform. Microsoft Office SharePoint Designer 2007 Business Administrator Training is a one-and-a-half hour, 300-400 level training series, produced in collaboration with the SharePoint Product Team and Total Training

Office Space: Solution Deployment with SharePoint 2007


WSS 3.0 introduces a new deployment mechanism that lets you move your development efforts into a staging or production environment.

Ted Pattison

MSDN Magazine August 2007

Trying to send email using Sharepoint Designer 2007 workflow and email enabled list


I have a a list that recieves email. I have few fields that shows me the originator: "E-Mail From" and "E-Mail Sender".

I am trying to create a workflow that will generate an auto reply to the originator but the SPD fails to recognize the email address in these two fields. It's either truncating part of it or uses the html ( href=mailto:Demo@DemoSomething.com) in the To field.

Thank you,


How can I implement this workflow scenario with SharePoint Designer?



I have a document content type and a library which contains this content type. here is what I want to do:

- when user creates a new document in this library, he will enter some user  names with people picker and then a message including some columns of the content type will be sent to that users. And then, at a certain date (lets say 1 day before a date that is one of the site columns) another email, a reminder will be sent.

I havent been able to find :

1- how can I replace a people picker field on workflow initiation form and how can I make it sent email to the user.

2- How can I make it sent a reminder email 1 day before the date that is stored in one of the columns of the content type(current item)

any help would be welcome,


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?

How to tie a dropdown list from a nother table to a dataview in sharepoint designer



i created a dataview for a user table to insert new records. now i have to use a dropdown list that get data from another table. to insert in my user table. in the user table only the code is stored. but i need to get that code description that is in another table in my dropdownlist to choose from in my dataview.

how can i do this in sharepiont designer2007?

create current user filter in sharepoint designer or wss3

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

How to Establish a Remote Web Site Connection in SharePoint Designer 2007


I am modifying a SharePoint site and so far so good.  Some of the objects were created using Visual Studio 2008 (C#).  I was able to modify these objects and implement them on the targete machine without issue.  The final step is to implement the ASPX pages that were modified using SharePoint Designer 2007.  These are aspx pages that are used to modify items in lists.  All the pages involved in this upgrade are customized.  I need to upgrade the target site with the modified version of these pages.  My intent is to copy the code from the page in the source site and past it into the same page on the target site.  I tried using the Remote Web Site connection tool in SharePoint Designer 2007 but received the following error message:

"Unable to open 'https://(site address)'.  Server Error:  Could not find a Web server at 'website'.  Please check to make sure that the Web server name is valid and your proxy settings are set correctly.  If you are sure that everything is correct, the Web server may be temporarily out of service."

I am not sure how to first check to see if the Web Server is temporarily out of service.  I would appreciate your input on how to verify this.

Background information of target machine:  WinServer 2008, IIS 7, Sharepoint (MOSS2007), site on port 80

SharePoint Designer: insert custom list not working anymore



Suddenly sharepoint designer decided today that it doesn't want to insert a custom list form anymore...
To be more specific, it doesn't work anymore in a site that uses the Microsoft budgeting and tracking template. In a website that uses an out of the box template, it still works.

It did work before, because I did it in other websites using the same template (it's broken there as well now).

Why oh why does SharePoint refuse to do this now?
I searched google and here on the forums, but all I could find was some issues after installing SP1, but we did that already long time ago and it was still working after that. I checked with our infrastructure guys and they didn't install new updates they say.

I also tried the solutions listed here: http://blogs.msdn.com/spdsupport/archive/2008/07/03/how-to-fix-custom-list-forms-will-not-insert-or-show-up-on-the-design-surface-of-sharepoint-designer.aspx
But they don't fix the problem.

So my problem is, I can go to Insert > SharePoint Controls > Custom List Form
I pick my list, content type and form type, I hit OK and... nothing happens.

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