C#

total_emp = 100,000;
//lot of calculations in the list
lvloanDetails.Items.Clear();

for (int i = 0; i < total_emp; i++)
{
ListViewItem lvi = new ListViewItem(emp_id.ToString("D2"));  

loan_balance get from =(formula/additions/diductions/calculations) 
  
lvi.SubItems.Add(loan_balance.ToString("#,0.00"));
      lvLoanDetails.Items.Add(lvi);
i++;
}

Process button click event -> list view’s data insert in to sql database table 

for (int i = 0; i < lvLoanDetails.Item.Count; i++) //item count = 100,000
{
insert -> list view to sql
i++;
}

//Set the URi Value
        Uri collectionUri = new Uri(@"http://XXX.XXX.XXX.XXX:8080/tfs/projectcollection");

        //Initialize the TeamProjection Collection
        TfsTeamProjectCollection teamProjectCollection =
           new TfsTeamProjectCollection(collectionUri, new NetworkCredential(@"user","userpassword"));

        //Sign in to the TFS Project
        teamProjectCollection.EnsureAuthenticated();            

        WorkItemStore workItemStore = teamProjectCollection.GetService<WorkItemStore>();

        string wiql = "SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State] FROM WorkItems " + 
            "WHERE [System.TeamProject] = 'Pathway' " + "AND  [System.State] = 'System Test Complete' " + 
            "AND  [Sagitec.Common.TestPhase] = '4.B – System Testing' ORDER BY [System.Id]";

        WorkItemCollection workItemCollection = workItemStore.Query( wiql);

        foreach (WorkItem wi in workItemCollection)
        {
            wi.Fields["Assigned To"].Value = "Srikanth";
            wi.Fields["State"].Value = "Ready for Client Review";
            wi.Fields["Reason"].Value = "Ready for Client Review";

            MessageBox.Show(wi.Fields["Assigned To"].Value + " + " + wi.Fields["State"].Value + " + " + wi.Fields["Reason"].Value);
        }