.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

Unable to write to SQL using a DataView in SharePoint Designer

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

I am connecting to a SQL database using SSO and surfacing data in a DataView web part. However, when i try to write back to the database using the DataView web part, i'm getting an authentication error.


Here is what I'm doing:


  1. In SharePoint Designer I create a datasource that connects to a SQL database using Single Sign-On. The SSO account successfully connects as the correct user to the database SQL and retrieves the data, which i can view in the data source details.
  2. I create a DataView Web Part that uses the data source, and all goes fine-- the the DataView displays the data, and i can view it in a web browser.
  3. In the DataView web part's properties, I check the synchronize commands checkbox and enable the add/edit/delete controls for the DataView. The edit, insert, and delete controls appear in the web part.


Upon trying to insert data using the browser, i get the following error:


The data source control failed to execute the insert command..


i get a similar error for editing and deleting entries.


When looking at my

View Complete Post

More Related Resource Links

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?

Error by insert new item in dataview sharepoint designer



doesn't any1 know the answer of my question?

i'm trying to create a data view with the edit, delete and insert function.

the edit and delete works fine. only the insert gives me this error:

The data source control failed to execute the insert command.

plz help?

Filter and Sort on fields in a joined dataview in SharePoint Designer


I need to create a data view that joins and displays data from two lists, and to sort and group on all of the fields displayed, not just fields from the main list.

I created linked datasource from two of my lists, joined them on a common field, and first inserted fields from the main list. Then I inserted fields from the other list as a Joined Subview,  which worked just fine, but now I need to be able to sort and filter on fields in that joined list, for which there doesn't seem to be an option.

Does anybody know whether it's possible and/or any workarounds/solutions for this? Basically, Is there a way to create a joined view of two lists where all fields are displayed in separate columns, and not in a table within a cell as in a case with joined subview?

Any comments are highly appreciated.


SharePoint / Project Server 2010 Unable to edit a HTTPS site in SharePoint designer 32 bit



I posted this thread below under a different forum and was requested to move.  Below is our current problem and the feedback that was given.

We currently have a project server 2010 site with several workspaces associated with it.  When trying to edit the site (either from choosing edit is designer from the site actions or from trying to open from within the designer) a dialog appears asking to choose a certificate for the site.domain.com.

The certificate issued by the site is a GeoTrust certificate and checks ok when browsing the site in IE.  This Windows security dialog also appears when trying to export to excel on the same site.

Any thoughts to what we are missing?




Dear Partner,


Thank you for posting in our Partner Online Technical Community.



Unable to write webservice for sharepoint site


Hello all,

I want to write webservice for Autocomplete textbox in sharepoint webpart.

can you please tell me steps ?



Unable to resume Sharepoint Designer workflow after Pause For Duration action

Hello we are using SharePoint server 2007 and developing workflows using SharePoint Designer.
Workflow in unable to resume after the time, set in the "Pause For Duration" action.
is there any Hotfix for SharePoint server 2007 to be installed on the server?

Unable to open a site in Sharepoint Designer


I am trying to connect my SharePoint Designer 2007 to sharepoint sites on a remote Windows Server 2003 created on ports other than 80. But it throws an error "The folder ['http://servername:12345/'] isn't accessible. The folder may be located in an unavailable location, protected with a password, or the filename contains a / or \."


But when I try to connect the port 80, it successfully does.

Unable to create task using Custom task Process Action in Sharepoint Designer 2010 workflow

Problem : In Sharepoint Designer 2010, we are working on creating reusable workflow.
In workflow we are using "Start Custom task process" action. It has been observed that,all of the sudden it behaves weirdly. It creates task but without any number appending to taskform.for eg. when we create task it generally shows "Start Task(1) process on Current Item with these users" However now it does not provide any number with Task. It shows "Start Task process on Current Item with These users"
In task form , it does not allows to add task forms fields from existing fields nor allows to create outcomes.
Thus we are unable to create any new workflows or edit and enhance exisitng workflows in the site.This is showstoper for project. Client wants to use sharepoint designer exclusively to develop workflow.
When we tried to create workflow (Sharepoint designer) in a new site with new list it allows us to create custom tasks process. 
Resoultions approaches done so far.
1) Took backup of site on local box from Server and tried to create custom process task but not able to do it.
2) On Server removed all unwanted workflow status columns from the tasks list but still not able to create custom process task 
3) Took backup and t

Write Custom WebParts for SharePoint 2007

The popularity of SharePoint Portal Server 2003 led Microsoft to tightly integrate the next SharePoint version, Microsoft Office SharePoint Server (MOSS) 2007, with its ASP.NET 2.0 WebPart framework. This tight integration enables the ASP.NET and SharePoint developer to do a number of things that previously weren't possible

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

Unable to search Custom User Property Created in User Profiles in SharePoint 2010


Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise

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,


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.

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

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