.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

Error by insert new item in dataview sharepoint designer

Posted By:      Posted Date: August 25, 2010    Points: 0   Category :SharePoint


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?

View Complete Post

More Related Resource Links

Error creating Read Item or Read List operation in Sharepoint Designer 2010

In terms of high-level requirements, I need to pull in lists from a couple of different web apps.  To do this, I’m using SPD 2010 to create an External Content Type for the list of interest.  I’m able to create a SOAP Service or WCF Service connection just fine.  However, when I try to create the external content type and create a Read Item Operation on one of the GetList or any other Get* (or other Update methods for that matter) methods, I get the following error:"The method that your operation is based on has parameters with complex types that do not have default parameterless constructor.  This kind of data source methods cannot be used in Business Data Catalog."I tried defining an operation on the “AddAttachment” method, and that worked just fine.  I also tried providing default values to the listName and viewName parameters when creating the SOAP Service connection, but still get the error.  Same issue with a WCF Service connection as well. Does anyone know if this is a 2010 issue, or am I approaching this requirement incorrectly?  What are other approaches for connecting to lists that reside in a different web app than yours? 

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?

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.

Error in SharePoint Designer when converting to XSL

While using SharePoint Designer, I attempt to convert a web part "list view"  to XSL and i get the error:  "The server returned a non-specific error when trying to get data from the data source.  Check the format and content of your query and try again.  If the problem persists, contact the server administrator."  Was able to convert this same web part a week ago, and now I am getting this error.  I have restarted all of the servers and still receive this error.  The only thing I can think of is that there might be an issue with having too much data in the list.  Any ideas?

Error customizing Approval Workflow in SharePoint Designer

When attempting to customize OOTB Approval Workflow, message "Workflow is read only?"  Request copy errors with "Server could not complete your request" Details button produces blank.  Any clue?  I am the site collection administrator for the site and the secondary farm administrator.

how to send an email using sharepoint designer workflow when an item equals to end time

hi, How to trigger the workflow when current time is equl to end time. I need to send an document when  current time is equl to end time. I am using designer workflows(sharepoint 2007).I have created a variable and i am able to get todays date but not able to get time by default i am getting 12:00:00 Am.i want to get current time. can u please tell me.

Access Denied/The workflow could not copy the item workflow error after Sharepoint 2010 upgrade

We have a sharepoint designer workflow that copies a document from one library to another on the same site.  Before the upgrade to 2007 it worked fine, but now with 2010 it gives an error and cancels the workflow when it gets to the copy list item step.   The error on the workflow page: The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings.  Access Denied   Specifically it is the "copy list item current item to documentlibrary" sharepoint designer workflow action.   I have given the system account full permissions to the library and double checked that all columns are the same in both libraries. These are the verbose trace logs:   09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72er Medium System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>Access denied. at Microsoft.SharePoint.SPFile.UpdateInternal(Boolean migrationSemantics, Boolean reGhost) at Microsoft.SharePoint.Workflow.SPWinOEWSSService.CommitCopyFile(Transaction txn, Object[] transData) 09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72fe High Error in commiting pending workflow batch items: Sys

Updating list item values in SharePoint Designer using code

Is it possible to programmatically modify the SharePoint objects using SharePoint Designer Object Model. By that I mean coding in SharePoint Designer (not Visual Studio). For example, can we access the list items of a list programmatically and change their values? I can do all this in Visual Studio using SharePoint Object Model but I don’t find a way of achieving this by using programming in SharePoint Designer. I searched through http://msdn.microsoft.com/en-us/library/bb208639(office.12).aspx but no success. If the answer is yes. Can someone please give example(s) or point to some articles etc? Thanks in advance.

SharePoint Designer Error - Unexpected error on server associating the workflow

I am creating a multistep workflow with multiple Approval steps.  When I get to step 7 or the 7th Approval step and try to publish it, it states that "Errors were found when compiling the workflow.  The workflow files were saved but cannot be run."  With "Unexpected error on server associating the workflow" in the advanced section.  This same error occurs at other stages of the approvals as well.  If I put another process/action in the step, the workflow runs without any problem.  Thanks for the help! JeremyJeremy

SharePoint Dataview Insert New Mode - Defaulting a Required Column to a Query String Parameter Valu

I've got a SharePoint DataView with an insert button. there is a required lookup column I want to default to the value of Querystring Value during new mode.  Can I do this in the generated code below? I tried replacing @ApplicantId with @QSApplicantID.. and  tried string(@QSApplicantID) too.. no luck gave me an error: The data source control failed to execute the insert command. Could it be that QSApplicantID (which I've used in my DataView Datasource filter with no problem) is not available during the insert? I think I can do what I want in Javascript but was hoping I could instead right in the XSL markup. *my query string parameter**     ParameterBinding Name="QSApplicantID" Location="QueryString(ID)" DefaultValue="2222222"/ **the new form** SharePoint:FormField runat="server" id="ff4{$Pos}" ControlMode="New" FieldName="ApplicantId" __designer:bind="{ddwrt:DataBind('i',concat('ff4',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@ApplicantId')}" / **the link** a href="javascript: {ddwrt:GenFireServerEvent('__cancel;dvt_1_form_insertmode={1}')}">Insert</a Thanks for any help or information!

Error - when creating externalContentType by SharePoint designer


Hello ,

- I have create a web Service by VisualStudio .

- Then I Publish it to IIS .Then I test it and eveything is fine .

-  I open SharePoint designer . Then Create ExternalContentType.

- I choose DataSourceType : wcf service .

- I set "ServiceMetaDataUrl" and "ServiceEndpointUrl"  :  http://serverIp:portNumber/service.asmx.

when Press ok  . I get the following error   "There was an error generationg xml document" .

How Can I solve this error .




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 2010 search crawl error: The SharePoint item being crawled returned an error when request

SharePoint 2010 search crawl error:
The SharePoint item being crawled returned an error when requesting data from the web service. ( Error from SharePoint site: Specified argument was out of the range of valid values. )

This error is for both document and folder. The document and folder were created/uploaded via SharePoint User Interface only. Later these doc/folder were deleted. And we found the search result showing the documents that were deleted from the doc library resulting in '404 page not found error' upon clicking. Ofcourse we did an incremental crawl after  deleting the file/folder. The error is same even after full crawl.

Environment details:
1 server - WFE role
1 server - App server role
1 server - index server role

Another information if helpful: We used some third party tool to migrate few sample data in the same server but on different site collection, different content database but on the same web application. The tool migrated the data and set unique permissions too for the migrated files. We tried deleting them via SharePoint interface and that files too gave a similar error!

Sharepoint Designer and Foundation version mismatch error


The company I am employed by has been running SharePoint 2010 successfully for several months now. Recently when anyone attempts to edit our main site using SharePoint designer they are prevented from doing so an given the following error message: "Server Error: The version of Microsoft SharePoint Foundation running on the server is more recent than the version of SharePoint Designer you are using. You need a more recent version of SharePoint Designer". We are running the most recent version that we can find available for download from Microsoft. The server administrator has attempted to roll back the most recent patches / updates to SP Foundation, rebooted the site collection, tried a fresh install of Designer and other obvious common solutions to no avail.

This is a massive impediment to our continued development of this product. How do we resolve this problem?


SharePoint Designer 2007 - Customize List View - Error when saving view ASPX page


We have a custom list definition that includes custom site columns.  When we try to open one of the list view aspx pages in SharePoint to update the view query we get an error when trying to save the page in SharePoint Designer 2007.  We receive a warning that the operation will customize the page from the site definition, which is fine.  And then get a general "Server error: ServiceRequestorID" alert.  ServiceRequestorID is a custom site column used by the list definition.

ServiceRequestorID field definition:

<Field ID="{FA39D24D-AB40-4b1d-BD80-94ABE34A7578}" Name="ServiceRequestorID" DisplayName="Service Requestor ID" StaticName="

SharePoint - Item - Edit Properties - Access Denied Error

I have a SharePoint 2007 EE Site  (with patches up to version running on Windows Server 2008 & SQL Server 2008.
I ported an existing site from a different domain to this server by backing up/restoring the content database. The site is running fine.

I added a new sub-site and here is where I have the issue. If I create a document library, add a document, and then use the drop-down on the item to pick "edit properties" I bounce to the SP Error: Access Denied screen. My account is a site admin and has full access to the sub-site.
I can view the properties fine.

When I try to upload a document I get the access denied error message if some of the meta data properties are marked "required". The document is still uploaded. I also get the same error when I try to edit an item in a list.

I can view/edit the properties in Data sheet view fine. The libraries on the existing sites work fine. It only seems to be an issue on new sub-sites.

It almost seems like a permission problem generating the property edit forms. There is nothing in the SP log files.

Access Denied Error While trying edit sharepoint list item


 I have a sharepoint site (2007) with two subsites . while I am trying to edit  list items in subsite its giving me Access denied error even though I have the Site collection Admin Rights. 

     Please help . 

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