Bulk Edit and Update of SharePoint List Items within a GridView

OutPut:-

Backend List:-

Note:-

1.       I was unable to design the properly.

2.       At a time you can do batch update only for 100 list items. If you do more than that the performance will get degraded.

Ascx

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="MEUGridViewUserControl.ascx.cs" Inherits="MEUGridView.MEUGridView.MEUGridViewUserControl" %>  <table align="center"> <tr> <td> <span> <asp:Button ID="btnCheckAll" runat="server" Text="Check All"         onclick="btnCheckAll_Click" /> </span> <span>&nbsp;</span> <span> <asp:Button ID="btnUncheckAll" runat="server" Text="UnCheck All"         onclick="btnUncheckAll_Click" /> </span> <span>&nbsp;</span> <span> <asp:Button ID="btnEdit" runat="server" Text="Edit" onclick="btnEdit_Click"  /> </span> <span>&nbsp;</span> <span> <asp:Button ID="btnUpdate" runat="server" Text="Update"         onclick="btnUpdate_Click"  /> </span> </td> </tr> <tr> <td> <asp:GridView ID="dgvMultipleRecordsEditUpdate" runat="server"     AutoGenerateColumns="False" DataKeyNames="ID" CellPadding="4"     EnableModelValidation="True" ForeColor="#333333" GridLines="Both">     <AlternatingRowStyle BackColor="White"  /> <Columns> <asp:TemplateField HeaderText="Select"> <ItemTemplate> <asp:CheckBox ID="chkMultiple" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <HeaderTemplate> <span>ID</span> <span>Player Name</span> <span>Location</span> </HeaderTemplate> <ItemTemplate> <asp:Panel ID="pnlLabels" runat="server"> <span><%# Eval("ID") %></span> <span><%# Eval("Title") %></span> <span><%# Eval("Location") %></span> </asp:Panel> <asp:Panel ID="pnlControls" runat="server" Visible="false"> <span style="text-align:center;"><asp:Label ID="lblItemID" Text='<%# Eval("ID") %>' runat="server"></asp:Label> </span> <span style="text-align:center;"><asp:TextBox ID="txtPlayerName" runat="server" Text='<%# Eval("Title") %>'></asp:TextBox></span> <span style="text-align:center;"><asp:TextBox ID="txtLocation" runat="server" Text='<%# Eval("Location") %>'></asp:TextBox></span> </asp:Panel> </ItemTemplate> </asp:TemplateField> </Columns>     <EditRowStyle BackColor="#7C6F57" />     <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />     <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />     <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />     <RowStyle BackColor="#E3EAEB" />     <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" /> </asp:GridView> </td> </tr> <tr> <td bgcolor="white"> <asp:Label ID="lblMessage"  runat="server"></asp:Label> </td> </tr> </table>

Ascx.cs

using System; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using Microsoft.SharePoint; using System.Security; using System.Collections; namespace MEUGridView.MEUGridView {     public partial class MEUGridViewUserControl : UserControl     {         ArrayList ArrItemID = new ArrayList();         ArrayList ArrPlayerNames = new ArrayList();         ArrayList ArrLocation = new ArrayList();         protected void Page_Load(object sender, EventArgs e)         {             if (!IsPostBack)             {                 getData();             }         }         public void getData()         {             try             {                 SPSecurity.RunWithElevatedPrivileges(delegate()                 {                     SPWeb curretWeb = SPContext.Current.Web;                     SPList lst = curretWeb.Lists["Players Location"];                     SPQuery sQuery = new SPQuery();                     sQuery.Query = "<OrderBy><FieldRef Name='ID' /></OrderBy>";                     SPListItemCollection myColl = lst.GetItems(sQuery);                     if (myColl.Count > 0)                     {                         dgvMultipleRecordsEditUpdate.DataSource=myColl.GetDataTable();                         dgvMultipleRecordsEditUpdate.DataBind();                     }                 });             }             catch (Exception Ex)             {                 lblMessage.Text = Ex.ToString();             }         }         protected void btnCheckAll_Click(object sender, EventArgs e)         {             try             {                 CheckBox chkMultipleEdit;                 foreach (GridViewRow gi in dgvMultipleRecordsEditUpdate.Rows)                 {                     chkMultipleEdit = (CheckBox)gi.Cells[0].FindControl("chkMultiple");                     chkMultipleEdit.Checked = true;                 }             }             catch (Exception Ex)             {                 lblMessage.Text = Ex.ToString();             }         }         protected void btnUncheckAll_Click(object sender, EventArgs e)         {             try             {                 CheckBox chkMultipleEdit;                 Panel pnlLabels1;                 Panel pnlControls1;                 foreach (GridViewRow gi in dgvMultipleRecordsEditUpdate.Rows)                 {                     chkMultipleEdit = (CheckBox)gi.Cells[0].FindControl("chkMultiple");                     chkMultipleEdit.Checked = false;                     if (chkMultipleEdit.Checked == false)                     {                         pnlLabels1 = (Panel)gi.Cells[0].FindControl("pnlLabels");                         pnlControls1 = (Panel)gi.Cells[0].FindControl("pnlControls");                         if (pnlControls1.Visible == true)                         {                             pnlControls1.Visible = false;                         }                         if (pnlLabels1.Visible == false)                         {                             pnlLabels1.Visible = true;                         }                     }                 }             }             catch (Exception Ex)             {                 lblMessage.Text = Ex.ToString();             }         }         protected void btnEdit_Click(object sender, EventArgs e)         {             try             {                 CheckBox chkMultipleEdit;                 Panel pnlLabels1;                 Panel pnlControls1;                 foreach (GridViewRow gi in dgvMultipleRecordsEditUpdate.Rows)                 {                     chkMultipleEdit = (CheckBox)gi.Cells[0].FindControl("chkMultiple");                     pnlLabels1 = (Panel)gi.Cells[0].FindControl("pnlLabels");                     pnlControls1 = (Panel)gi.Cells[0].FindControl("pnlControls");                     if (chkMultipleEdit.Checked == true)                     {                         pnlLabels1.Visible = false;                         pnlControls1.Visible = true;                     }                 }             }             catch (Exception Ex)             {                 lblMessage.Text = Ex.ToString();             }         }         protected void btnUpdate_Click(object sender, EventArgs e)         {             try             {                 CheckBox chkMultipleEdit;                 TextBox txtPlayerNames1;                 TextBox txtLocation1;                 foreach (GridViewRow gi in dgvMultipleRecordsEditUpdate.Rows)                 {                     chkMultipleEdit = (CheckBox)gi.Cells[0].FindControl("chkMultiple");                     txtPlayerNames1 = (TextBox)gi.Cells[1].FindControl("txtPlayerName");                     txtLocation1 = (TextBox)gi.Cells[1].FindControl("txtLocation");                     if (chkMultipleEdit.Checked == true)                     {                         ArrItemID.Add(dgvMultipleRecordsEditUpdate.DataKeys[gi.RowIndex].Value);                         ArrPlayerNames.Add(txtPlayerNames1.Text);                         ArrLocation.Add(txtLocation1.Text);                     }                                     }                 SPSecurity.RunWithElevatedPrivileges(delegate()                 {                     SPWeb currentWeb = SPContext.Current.Web;                     SPList lst = currentWeb.Lists["Players Location"];                     string strBatch = string.Empty;                     string strBatchFormat="<?xml version=\"1.0\" encoding=\"UTF-8\"?>" + "<ows:Batch OnError=\"Return\">{0}</ows:Batch>";                    int k = 1;                     for (int i = 0; i < ArrItemID.Count; i++)                     {                         strBatch += "<Method ID=\"{0}\">";                         strBatch += "<SetList>" + lst.ID + "</SetList>";                         strBatch += "<SetVar Name=" + "\"ID\">" + ArrItemID[i].ToString() + "</SetVar>";                         strBatch += "<SetVar Name=\"Cmd\">Save</SetVar>";                         strBatch += "<SetVar Name=" +"\"urn:schemas-microsoft-com:office:office#Title\">"+ArrPlayerNames[i].ToString()+"</SetVar>";                         strBatch += "<SetVar Name=" + "\"urn:schemas-microsoft-com:office:office#Location\">" + ArrLocation[i].ToString() + "</SetVar>";                         strBatch += "</Method>";                         k++;                         if (i == ArrItemID.Count)                         {                             break;                         }                     }                     string strCompleteBatch = string.Format(strBatchFormat, strBatch);                     string strProcessBatch = currentWeb.ProcessBatchData(strCompleteBatch);                     lst.Update();                     getData();                 });             }             catch (Exception Ex)             {                 lblMessage.Text = Ex.ToString();             }         }     } }