Prasad Bolla's SharePoint Blog

Click Here to go through the Interesting posts within my Blog.

Click Here to go through the new posts in my blog.

Thursday, March 29, 2012

JavaScript Vs JQuery

According to my knowledge JavaScript only supports 32 bit Browsers. where as JQuery supports all browsers irrespective of 32 bit or 64 bit.

Tuesday, March 27, 2012

How to open 32 bit Browser in 64 bit windows

Edit,Update and Delete in SharePoint List From a GridView or SpGridView

Note:-

I have done some more operations with a GridView.

1.        Multiple Deletion of SharePoint ListItems in GridView.
2.        Using Asp.Net Dropdowlist in GridView using SharePoint Data.
3.        Using Asp.Net CheckBoxlist in GridView using SharePoint Data.
4.        Using Asp.Net RadioButtonList in GridView using SharePoint Data.
5.        Bulk Edit and Update of SharePoint ListItems within a GridView. 
6.        Insertion into a SharePoint List using GridView.

 


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="EUDGridViewUserControl.ascx.cs"
    Inherits="EUDGridView.EUDGridView.EUDGridViewUserControl" %>
<asp:GridView ID="dgvEditUpdateDelete" runat="server" AutoGenerateColumns="False"
    CellPadding="4" EnableModelValidation="True" ForeColor="#333333" GridLines="None"
    AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" OnRowDeleting="dgvEditUpdateDelete_RowDeleting"
    OnRowEditing="dgvEditUpdateDelete_RowEditing" OnRowUpdating="dgvEditUpdateDelete_RowUpdating"
    OnRowCancelingEdit="dgvEditUpdateDelete_RowCancelingEdit" DataKeyNames="ID">
    <AlternatingRowStyle BackColor="White" />
    <Columns>
        <asp:TemplateField HeaderText="ItemID">
            <ItemTemplate>
                <%# Eval("ID") %>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:Label ID="lblItemID" runat="server" Text='<%# Eval("ID") %>' Columns="3" />
            </EditItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Title">
            <ItemTemplate>
                <%# Eval("Title") %>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtTitle" runat="server" Text='<%# Eval("Title") %>' Columns="3" />
            </EditItemTemplate>
        </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>
<asp:Label ID="lblMessage" runat="server"></asp:Label>


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;
namespace EUDGridView.EUDGridView
{
    public partial class EUDGridViewUserControl : UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                SPWeb currentWeb = SPContext.Current.Web;
                SPList lst = currentWeb.Lists["Sample List001"];
                SPListItemCollection myColl = lst.Items;
                if (myColl.Count > 0)
                {
                    if (!IsPostBack)
                    {
                        dgvEditUpdateDelete.DataSource = myColl.GetDataTable();
                        dgvEditUpdateDelete.DataBind();
                    }
                }
            }
            catch (Exception ex)
            {

                Response.Write(ex.ToString());
            }
        }
        public void getData()
        {
            SPWeb currentWeb = SPContext.Current.Web;
            SPList lst = currentWeb.Lists["Sample List001"];
            SPListItemCollection myColl = lst.Items;
            if (myColl.Count > 0)
            {
                    dgvEditUpdateDelete.DataSource = myColl.GetDataTable();
                    dgvEditUpdateDelete.DataBind();
            }
        }
        string strItemID1;
        protected void dgvEditUpdateDelete_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            try
            {
                strItemID1 = dgvEditUpdateDelete.DataKeys[e.RowIndex].Value.ToString();
                SPSecurity.RunWithElevatedPrivileges(delegate()
                {
                    DeleteRow(strItemID1);
                    getData();
                });
            }
            catch (Exception ex)
            {

                Response.Write(ex.ToString());
            }
        }

        protected void dgvEditUpdateDelete_RowEditing(object sender, GridViewEditEventArgs e)
        {
            try
            {
                 dgvEditUpdateDelete.EditIndex = e.NewEditIndex;
                 SPSecurity.RunWithElevatedPrivileges(delegate()
                 {
                     getData();
                 });
           
            }
            catch (Exception ex)
            {

                Response.Write(ex.ToString());
            }
        }
        protected void dgvEditUpdateDelete_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            try
            {
                Label lbl = (Label)dgvEditUpdateDelete.Rows[e.RowIndex].Cells[2].FindControl("lblItemID");
                TextBox txtTitle1 = (TextBox)dgvEditUpdateDelete.Rows[e.RowIndex].Cells[2].FindControl("txtTitle");
                SPSecurity.RunWithElevatedPrivileges(delegate()
                {
                    updateRow(lbl.Text, txtTitle1.Text);
                    dgvEditUpdateDelete.EditIndex = -1;
                    getData();
                });
            }
            catch (Exception ex)
            {

                Response.Write(ex.ToString());
            }
        }
        public void updateRow(string ItemID1,string Title)
        {
            SPWeb currentWeb = SPContext.Current.Web;
            SPList lst = currentWeb.Lists["Sample List001"];
            SPListItem item = null;
            item = lst.GetItemById(int.Parse(ItemID1));
            currentWeb.AllowUnsafeUpdates = true;
            item["Title"] = Title;
            item.Update();
            lst.Update();
            currentWeb.AllowUnsafeUpdates = false;

        }
        public void DeleteRow(string ItemIDNew)
        {
            SPWeb currentWeb = SPContext.Current.Web;
            SPList lst = currentWeb.Lists["Sample List001"];
            SPListItem item = null;
            item = lst.GetItemById(int.Parse(ItemIDNew));
            currentWeb.AllowUnsafeUpdates = true;
            item.Delete();
            lst.Update();
            currentWeb.AllowUnsafeUpdates = false;

        }
        protected void dgvEditUpdateDelete_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            dgvEditUpdateDelete.EditIndex = -1;
            SPSecurity.RunWithElevatedPrivileges(delegate()
            {
                getData();
            });
        }
    }
}