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


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

How to read a NULL value sharepoint list item

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

hi guys,

im having trouble pulling some specific information out from sharepoint list item. im doing a asp.net form and saved all user inputs into sharepoint list. if all information are there, my code works fine, if some colume is missing(the scenera requires to do that), it will return a  System.NullReferenceException: Object reference not set to an instance of an object exception. How can i read a null item, and maybe simply assign it to a string such as "NO VALUE", something like that?

i've tried all methods that i can think about, such as system.DBNull.value, or string.empty, or just null.

code is here: this is the save to list code:

private void SaveToTTCVIPList(SPWeb web)
    {
      try
      {
        TTCVIPList = web.Lists["TTCVIP"];
      }
      catch
      {
        TTCVIPList = AddList(web, "TTCVIP", "List for TTCVIP user's information", "Custom List", true);
        buildTTCVIPList(TTCVIPList);
      }
      SPListItem item = TTCVIPList.Items.Add();      
      ...      
if (this.txtJointHolderName.Text == System.DBNull.Value)
      {
        item["Joint Holder Name"] = string.Empty;


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? 

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.


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)

How to read a column of a sharepoint list to a text string field of infopath form?

  
My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

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/">'+         

Updating a List item field value in a SPD Workflow is setting Date fields to null

  
Hello everybody,I faced a very weird behavior while creating a workflow in SPD against a Document Library.Here is the case:1- Create a document library in sharepoint site.2- Add a custom column of type DATE.3- Upload any document to the library4- Edit the item metadata and set the custom date field to any date you want.5- Now using sharepoint designer, create a very simple Workflow with only one action that updates the current item "Title" field to any value. (Note: In my case I set the workflow to start manually and not automatically)6- Save the workflow and then start it on the uploaded item.7- Now check the value of the date column after the workflow is finished.8- You will see that the Date field is Empty... (very weird)Notes:   1-This behavior will not appear on a standard list. it is only appearing in a Document library.  2- I am using WSS 3.0 SP2 + MOSS 2007 SP2. Also SharePoint designer 2007 SP2Did anyone face this situation and does it have a fix, or am I doing something wrong here... Please help.Regards,Maheed

Read data from BLOB field and write to sharepoint list

  
Hi, I want to read the data from BLOB field and write it into sharepoint list item. Please provide some pointer to archive above objective.   Thanks in Advance.

how to in Insert database NULL if drop down list item is not selected ?

  
hi,   on my aspx I have the below DDL   <asp:DropDownList ID="ColorDDL" runat="server" DataSourceID="ColorObj"                                                 DataTextField="Size" DataValueField="BustId" Width="150px"                                                 AppendDataBoundItems="True">                                                    <asp:ListItem Value="-1">(Optional)</asp:ListItem>                             &n

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

Read list of a sharepoint site

  
I have to read a list of a sharepoint site from a client who does not has sharepoint installed. The problem is that when I try to use the SPSite tell me http://Sharepoint/sites/Sitio2/default.aspx could not be found. Tks!!!

Why List Item Attachments are read only?

  
I am programatically adding files to list item attachments. But when I open the file, and try to hit save, they throw a read only dialog box. int FileLength = File1.PostedFile.ContentLength; if (File1.PostedFile != null && File1.HasFile) { Stream fStream = File1.PostedFile.InputStream; byte[] contents = new byte[fStream.Length]; fStream.Read(contents, 0, (int)fStream.Length); fStream.Close(); fStream.Dispose(); myWeb.AllowUnsafeUpdates = true; SPAttachmentCollection attachments = enquiry.Attachments; attachments.Add(fileName, contents); enquiry.Update(); myWeb.AllowUnsafeUpdates = false; } What could I have missed?

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?

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

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

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