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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

how to update sharepoint list item instead of creating a new one

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

hi guys,

i was working on a webform on asp.net, it has a list to save users information. the system has a "profile manager", it has user's loggin name. so i made a query to check if it already exists in the list, and then prepopulated the information on the form(in page load).

what i want is that if this item already exists, it can update the item. if it is not in the list, it will then create a new one.

i was searching around, and changed my code accordingly. but it always create a new item, even though all information is the same.

here is my pageload code:

public class TTCVIP : System.Web.UI.UserControl

	{

  protected GenericWebPart webpart;

  StringBuilder _exceptionMsg;

  bool _hasException;

  #region member controls

   ............  

  #endregion



  //rendering the page

  private void Page_Load(object sender, System.EventArgs e)

  {

   

   SPSite mySite = SPControl.GetContextSite(Context);

   SPWeb myWeb = SPControl.GetContextWeb(Context);

   ServerContext context = ServerContext.GetContext(mySite);

   UserProfileManager myProfileManager = new UserProfileManager(context);

   string CurrentUser = Context.User.Identity.Name;

   UserProfile myProfile = myProfileManager.GetUserProfile(CurrentUser);         

   

   //check if list exist and create new list 

   try

   {

    if (!IsPostBack)

    {

     s


View Complete Post


More Related Resource Links

Concurrent update in sharepoint list item

  

Hi,

How the concurrent for sharepoint list item are are handled.

if two or more users are working on same item. Then how sharepoint process multiple update request for particular list item.


Update SharePoint List item using UpdateListItem web service with javascript

  
I'm using the Custom_AddListMenuItems function in a CEWP to add a menu item to each list item to Archive that item. This is achieved by updating a choice field in the item to 'Archived'. I'm trying to do this using the web service UpdateListItem web service to update the item using Javascript, but I can not find the correct code that updates the list item. I'm using this code:     var ctx=currentCtx;     var ciid=currentItemID;     var xmlHttp=null;     if (confirm("Are you sure you want to Archive this item?"))     {         var soapRequest = '<?xml version="1.0" encoding="utf-8"?>'+             '<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">'+             '    <soap:Body>'+             '        <UpdateListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">'+         

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? 

Invalid data has been used to update the list item in sharepoint 2010.

  
I have created a custom list definition with one lookup field <      Field ID="{865CD714-7DF6-4F65-9DBC-5FE910B10BC5}" Name="CompanyName" DisplayName="Company Name" Group="Custom contents" Description="Select Company" Type="Lookup" ShowField="CompanyName" Required="FALSE" FieldRef="CompanyName" List="Lists/LookupListDefinition-ListInstance1" ReadOnly="FALSE"></Field>   <nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. My solution is perfectly get deployed on site. I can see the list instance created on site its also appears on quicklaunch. When i am trying to add the item into the custom list using UI then i am getting the input form correctly i can see the lookup values in dropdown list but when i click on save button then its give me an error as mention above. For debugging purpose i have created the event reciver class for list item adding event. In that i have check the column status and

Item update in the sharepoint list using web service with javascript

  

HI 

I am using below code for web services with javascript

<script>

function CreateListItem(Title)

 {  

 

    var soap1 = createEnvelope(Title);

 

    var ws = new ActiveXObject("Microsoft.XMLHTTP");    

      if(ws == null) 

       return null;

 

    ws.open("POST", 

         "http://dca-app-200:44444/sites/corpmarketing/_vti_bin/lists.asmx",

         false);

    ws.setRequestHeader("Content-Type", "text/xml; charset=utf-8");            

    ws.setRequestHeader("SOAPAction", 

        "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");

    ws.send(soap1);  

       alert("success");

 

}     

  function createEnvelope(Title)

{               

     var batch;

var xmldoc;    

var ListName = 'S

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

Assigning users when creating a list item in a workflow

  

I'm using a workflow to assign tasks to users.  When I try to assign the task to a group (set in the workflow designer), the workflow gives me an error.  When I change the assign to property to a single user, the workflow works perfectly.  How do I get the workflow to assign the task to the group?  Or if that's not possible, can I get it to assign it to more than one user?

Kenn


Creating List Definitions with Custom List Columns for SharePoint Server 2007

  
Learn to use Visual Studio 2008 Extensions for Windows SharePoint Services to create a SharePoint list definition that implements custom list columns.

Video: Field and List Item Validation in SharePoint 2010

  
SharePoint supports the ability to create Excel-like field validation formulas to validate field data in a list, which greatly reduces the amount of custom code that a developer must create and deploy. (Length: 1:44)

Invalid data has been used to update the list Item.(List definition)

  
<nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only. I have created a list definition and into that i have created lookup column when i am trying to add any item into the list then it gives me an error as above. Can anyone help me.? I made the readonly attributes to false for lookup columns.  

SSRS 2008 R2 - Sharepoint list item hyperlink bug?

  
I have created a report based on a sharepoint list and I am using a subscription in WSS 3.0 to email the report to the users once a week. I want one column in the report to act as a hyperlink to the sharepoint list item but in the email version of the report, the URL has the list item ID repeated twice, which renders the link invalid. Initially, I tried using the 'Encoded Absolute URL' from the sharepoint list query to populate the hyperlink but this just gives a 404 NOT FOUND error and I have found documented in several places on the web that this link only works with document libraries. So instead, I decided to create the URL for the action using an expression, like this: ="http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=" & ListItemID.Value This works perfectly in the development environment and when people run the report for themselves in the sharepoint document library where it is deployed but, for some reason, if I send the report on a schedule then I get the ID parameter repeated at the end twice. Like this: http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=999&ID=999 I have tried rendering the report in several different formats (Word, PDF, MHTML, HTML) and they all seem to work fine in the development and when run within SharePoint but not when they are rendered and emailed using the scheduler. Is this a bug or am I missing so

How to update selected item state in the list box by clicking a button?

  
I created a listbox menu to browse through content by clicking items in the listbox. I also created ‘back’ and ‘forward’ type of navigation to browse through the same content based on the browsing history. I load content into frame and accessing the browsing history with NavigationCommands.BrowseBack and BrowseForward Properties. It is working great. However, I need to indicate a selected state of the listbox item related to the content shown in the frame while browsing with Back/Forward buttons. I have a hard time binding that property. What is the correct way to bind selected state of the listitem in this case? Thank you in advance. XAML: Button <Button x:Name="NavBack" Content="" HorizontalAlignment="Left" Margin="20,0,0,0" Style="{DynamicResource BackButtonStyle}" VerticalAlignment="Top" CommandTarget="{Binding ElementName=ContentFrame}" Command="{x:Static NavigationCommands.BrowseBack}" SnapsToDevicePixels="True" IsEnabled="{Binding CanGoBack, ElementName=ContentFrame, Mode=OneWay}" > XAML: Listsbox <ListBox x:Name="Nav_ListBox" Margin="0,18,0,0" ScrollViewer.HorizontalScrollBarVisibility="Hidden" Background="#FFF2F2F2" ItemsSource="

How to prevent automatic update from sharepoint list on Infopath 2007 form

  
Hi there, I've got an Infopath 2007 form on MOSS 2007. I have a custom list in sharepoint and the infopath form has a data connection to that list to receive data. Is there any way to prevent automatic update on the values in the form that is received from the list. I'd like the new form to have updated info received from the list. However, the old/existing forms that were created should have the data that were available at the time when the form was created. Let me know if this is not clear and I'll try to explain more. Thanks,Pman http://www.pmansLab.com/

Emailing Calendar Item to SharePoint List

  
I have followed the various instructions around the net (specifically the TechNet article) on configuring MOSS2007 and Exchange for mail enabling your lists. I have also read and applied the changes specified by the Microsoft KB regarding the two forgotten Active Directory entries. At this point I am able to send an email to a list and have the email post. Some of my users want to make use of the Email enabled Calendar List. They create a standard Calendar list and mail enable it. They give the list a unique name for Active Directory. They then goto Outlook and try "inviting an attendee" to an event and wait to see the event get posted on the SharePoint list. I have applied the KB edits to the new Active Directory user and I can watch the emails come into the dropbox and then disappear, but nothing ever happens. I have permissions setup correctly as well as far as giving "Authenticated Users" contribute access.... I don't see any errors specifically.... I do notice all my emails come in as .eml attachments... Any ideas of where to look?

get sharepoint list item column choices using caml

  
basicallly the title says it all, is there a way to get a sharepoint list's column's choices using CAML query? i'm trying to get the choices using the sharepoint web service

Emailing Calendar Item to SharePoint List

  
I have followed the various instructions around the net (specifically the TechNet article) on configuring MOSS2007 and Exchange for mail enabling your lists. I have also read and applied the changes specified by the Microsoft KB regarding the two forgotten Active Directory entries. At this point I am able to send an email to a list and have the email post. Some of my users want to make use of the Email enabled Calendar List. They create a standard Calendar list and mail enable it. They give the list a unique name for Active Directory. They then goto Outlook and try "inviting an attendee" to an event and wait to see the event get posted on the SharePoint list. I have applied the KB edits to the new Active Directory user and I can watch the emails come into the dropbox and then disappear, but nothing ever happens. I have permissions setup correctly as well as far as giving "Authenticated Users" contribute access.... I don't see any errors specifically.... I do notice all my emails come in as .eml attachments... Any ideas of where to look?

How to stop the mail trigger while editing a task list item in sharepoint 2007

  
I have a requirement to stop the mail trigger while editing a task list item in SharePoint 2007. When I am creating a task the mail is sending to the “Assigned to” Properly. But when I am editing the same task item again a mail is sent to the Assigned to user which I want to stop. Is there any out of box feature / settings to stop this mail trigger while editing. Early response is much appreciated.Deeptyranjan
Categories: 
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