logo
down
shadow

add SPListItem to a SPListItemCollection


add SPListItem to a SPListItemCollection

By : Sean Conklin
Date : November 19 2020, 03:54 PM
With these it helps You are trying to add an item into null because your ITEM is null. I don't know what error you are getting ( your don't write it) but you must initialize your collection:
code :
    if (items.Count > 0)
    {
          DataRow dr=null;
          SPListItemCollection ITEM = ... //
          foreach(SPListItem item in items)
          {
              string A = item["Approval Status"].ToString();
              if(A== "2")
              {
                 SPListItem myItem = ITEM.Add();
                 // set your item's fields here 
                 // Use indexers on this object for each field to assign specific values, and then call the Update method on the item to effect changes in the database.
                 myItem["Approval Status"] = item["Approval Status"];
                 ...
                 myItem.Update();
              }
          }
          if(dt.Rows.Count==0)
             lbldata.Text = "No data to show";

             //  dt = items.GetDataTable();

    }


Share : facebook icon twitter icon
Accessing a SPListItem from SPListItemCollection directly

Accessing a SPListItem from SPListItemCollection directly


By : user1431860
Date : March 29 2020, 07:55 AM
will help you Not out of the box - see the question How to access List Items in a list for the options. Retrieving the information with SPQuery is recommended to avoid placing too much load on the database. There is more information on how to use that in my answer to SharePoint : Check if item exists in a list, minimum overhead:
A good alternative is to use LINQ. This option has been provided by the community (Keith Dahlby and Wictor Wilén) and is available in the SharePoint Extensions Lib.
Converting SPListItemCollection into DataTable

Converting SPListItemCollection into DataTable


By : ramesh
Date : March 29 2020, 07:55 AM
help you fix your problem there is no reason for LINQ to be more efficient. However, it is more readable. If you care much about performance do not use LINQ. If on the other hand performance is not an issue then it is more readable. Here is some more on readabilty.
Sharepoint -- Get the difference between two SPListItemCollection

Sharepoint -- Get the difference between two SPListItemCollection


By : Vicky Garcia
Date : March 29 2020, 07:55 AM
seems to work fine You can use Cast to use all IEnumerable LINQ methods like Contains(). Using try-catch for this is not too pretty solution, imho. You can do it in one simple line:
code :
var noAccessListItems = regularListItems.Cast<SPListItem>().Where(x => !superListItems.Cast<SPListItem>().Select(y => y.ID).Contains(x.ID));
var noAccessListItems = regularListItems.Cast<SPListItem>().Except(superListItems.Cast<SPListItem>());
class SPListItemEqualityComparer : IEqualityComparer<SPListItem>
{
    public bool Equals(SPListItem i1, SPListItem i2)
    {
        return i1.ID == i2.ID;
    }

    public int GetHashCode(SPListItem item)
    {
        int hCode = item.ID;
        return hCode.GetHashCode();
    }
}
var noAccessListItems = superListItems.Except(regularListItems, new SPListItemEqualityComparer());
add multiple SPList to SPListItemCollection

add multiple SPList to SPListItemCollection


By : Vince Vitali
Date : March 29 2020, 07:55 AM
I wish this help you I always like to use List<> to handle these. To do that, make sure you add
code :
using System.Linq;
List<SPListItem> allItems = new List<SPListItem>();
allItems.AddRange(list.GetItems(spQuery).Cast<SPListItem>().ToList());
allItems.AddRange(list2.GetItems(spQuery).Cast<SPListItem>().ToList());

//Do something to the "allItems"
c# sharepoint how to set a FIELD Value of SPListItem with FIELD Value from other SPListItem?

c# sharepoint how to set a FIELD Value of SPListItem with FIELD Value from other SPListItem?


By : Rafael Padilha
Date : March 29 2020, 07:55 AM
Does that help this is useful case, and I always try it source from Get And Set Value By Field Internal Name
Related Posts Related Posts :
  • Why do I get a COMException when I try to initialize an Interop.Word.Application?
  • Finding subtotal for column in repeater control
  • dropdownlist item selected throw exception (stack empty)
  • How can I list IIS working processes programmatically?
  • How to access nested object from JSON with Json.NET in C#
  • OpenXml DataValidation set predefined List for columns
  • How to find recurring word groups in text with C#?
  • layout conrols to developp universal apps in windows 8.1 pro
  • Adding strings to a list via for loop xna
  • Using Vertex Arrays with OpenTK
  • Optimizing List<string>
  • C# Local variables
  • How can I merge the results of a group by Linq-to-XML query?
  • How to add Report in ASP.NET Project
  • C# How to display all instances of a loop in a label?
  • C# subscribe a function to System.Action that is subscribed to another System.Action: why does order matter?
  • Is there any negative effect to setting SqlCommand's CommandTimeout to a high value?
  • C# - TreeView Context Menu Out of Place when using keyboard
  • How to read stored procedure output and return it as list
  • How do you maintain changes made by VisualState triggers after setting another VisualState?
  • Should I be unit testing my bootstrapper and if so how?
  • using .SingleOrDefault() inside .Where() will raise the following exception:- System.NotSupportedException was unhandled
  • C# How would I fill a Form1 Parameter in the same seperate class
  • Access gridview row's data from LinkButton inside that row
  • Translating excel function to c# Math.pow not resulting in same values
  • Arranging Ten Inputted Numbers into Ascending and Descending order
  • AsEnumerable and Query Syntax
  • How can I defensively code against randomly referencing "Table 0" and null values?
  • Changing xaml code position based on screen size
  • Castle Windsor resolve ienumerable and name
  • Drawing multiple sprites with a for loop xna 4.0
  • For loop to Populate Textblocks
  • Visual Studio 2015: Create an Empty Project
  • What are .NET classes to replace the old MSXML2.ServerXMLHTTP?
  • Handle leak in .Net threads
  • Excel add-in ribbon click events bubbling
  • validation rule needed for only numbers to be entered
  • Parsing complex XML, no descendent elements exists when selecting a named element
  • Web Api - IEnumerable with complex type as param is null
  • Email address input validation
  • .Net AND operator Regular Expression using strings in a document
  • Windows phone 8.1 POST x-www-form-urlencoded not working
  • Is there any way to make my C# XMLManager work?
  • ASP.NET 5 Console Application (package) - How to create DBContext from connection string?
  • How to use form's function in other class C#
  • WPF Zebra EPL2 Printing issue
  • C# use reflection to capture exception throw
  • Convert strings in DataRow to double
  • Xml-Serialization is not working
  • HTML Agility Pack can't find classes with trailing spaces
  • ComputeHash Calls Inexplicably Differ
  • Creating an array that holds both integers and datetime C#
  • GroupBy multiple columns in Linq with Take()
  • Rename multiple symbols at once? (using Roslyn)
  • Cast lambda in delegate
  • DataContractSerializer using default properties
  • LINQ Query Sum in recordset
  • change left-hand boolean value to be opposite of the right hand value
  • Get node from XmlDocument using xpath
  • Why does a Control's BeginInvoke() target delegate never occur after Dispose() is called on the Control?
  • shadow
    Privacy Policy - Terms - Contact Us © animezone.co