in list add list item 50000 items . how can do it?

still, your question is not clear. but see below code it may help you.

Note: to add only 5000 objects into your list, use a loop or write sql_query that get only 5000 of records.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Harish Supekar9y ago
still, your question is not clear. but see below code it may help you.
class clsCustomer
{
public int Id {get; set; }
public string Name {get; set; }
public string Address {get; set; }
}

class clsFactory
{
List ListCustomer = new List();
//method that bunch of record from database table
public List GetCustomerList()
{
  SqlConnection con = new  SqlConnection(db connection string);
  SqlCommand cmd = new SqlCommand(sql_query, con);
  con.open();
  while (reader.Read())
  {
              clsCustomer objCustomer = new clsCustomer() ;
        objCustomer.Id = (int)reader["ID"];
        objCustomer.Name = reader["FullName"].ToString();
        objCustomer.Address = reader["FullAddress"].ToString();
    ListCustomer.Add(objCustomer);
  }
}
}
Note: to add only 5000 objects into your list, use a loop or write sql_query that get only 5000 of records.
sharan raj9y ago
in sharepoint list add list item into list limit 5000 items. i need more list item to add into list . how can do it?
Harish Supekar9y ago
please explain your question in brief.