SharePoint Programming

Tuesday, February 5, 2013

Paging without Refresh in GridView using Visual WebPart

Note:-

Here we are fetching data from SharePoint List.
We have to keep the GridView in UpdatePanel.

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="AjaxTestingNewUserControl.ascx.cs" Inherits="AjaxTestingNew.AjaxTestingNew.AjaxTestingNewUserControl" %>

<%@ Register Assembly="AjaxControlToolkit, Version=3.0.30930.28736, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e" Namespace="AjaxControlToolkit" TagPrefix="AjaxControlToolkit" %>

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

<tr>

<td>

<asp:GridView ID="sgvCountries" runat="server" AutoGenerateColumns="False"

Width="100%" AllowPaging="True" PageSize="10"

CellPadding="4" EnableModelValidation="True" ForeColor="#333333"

GridLines="Both">

<asp:BoundField HeaderText="Country" DataField="Title" />

<asp:BoundField HeaderText="Region" DataField="Region" />

</Columns>

</asp:GridView>

</td>

</tr>

</table>

</ContentTemplate>

</asp:UpdatePanel>

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.Data;

namespace AjaxTestingNew.AjaxTestingNew

{

public partial class AjaxTestingNewUserControl : UserControl

{

protected void Page_Load(object sender, EventArgs e)

{

sgvCountries.PagerSettings.Mode = (PagerButtons)PagerMode.NextPrev;

sgvCountries.PagerSettings.NextPageText = "Next ";

sgvCountries.PagerSettings.PreviousPageText = "Previous";

sgvCountries.PageIndexChanging += new GridViewPageEventHandler(sgvCountries_PageIndexChanging);

if (!IsPostBack)

{

sgvCountries.DataSource = BindGridView();

sgvCountries.DataBind();

}

void sgvCountries_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

sgvCountries.PageIndex = e.NewPageIndex;

sgvCountries.DataSource = BindGridView();

sgvCountries.DataBind();

}

public DataTable BindGridView()

{

SPWeb currentWeb = SPContext.Current.Web;

SPList lstEmployee = currentWeb.Lists["lst_Country"];

SPQuery sQuery = new SPQuery();

sQuery.Query = "<OrderBy><FieldRef Name='ID' Ascending='False' /></OrderBy>";

SPListItemCollection myColl = lstEmployee.GetItems(sQuery);

return myColl.GetDataTable();

}

Refresh Your WebPart Page every Five Minutes using Visual WebPart

string strCurrentWebUrl = SPContext.Current.Web.Url + "/UserPages/Ajax%20Accordin%20Control.aspx";

Response.AppendHeader("Refresh", "5; URL='"+strCurrentWebUrl+"'");

Wednesday, January 30, 2013

How to get the Curently Logged User IP Address

Note:-
We can use the same logic in SharePoint.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Net;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

string strIPAddress = getclientIPAddress();

Response.Write(strIPAddress);

}

public static string getclientIPAddress()

{

IPHostEntry host;

string localIP = "?";

host = Dns.GetHostEntry(Dns.GetHostName());

foreach (IPAddress ip in host.AddressList)

{

if (ip.AddressFamily.ToString() == "InterNetwork")

{

localIP = ip.ToString();

}

return localIP;

}

Monday, January 28, 2013

How to get User Defined Fields within a Custom List Type using SharePoint 2010 Event Reiever

Live Task How to get User Defined Fields within a Custom List Type using SharePoint 2010 Event Reiever

ArrayList ArrColumnNames = new ArrayList();

ArrayList ArrOldValues = new ArrayList();

SPListItem item = properties.ListItem;

for (int i = 0; i <= properties.List.Fields.Count - 1; i++)

{

if (!properties.List.Fields[i].Hidden && !properties.List.Fields[i].ReadOnlyField && properties.List.Fields[i].Type != SPFieldType.Attachments && properties.List.Fields[i].Title != "Content Type")

{

ArrColumnNames.Add(properties.List.Fields[i].StaticName);

if (item[properties.List.Fields[i].StaticName] != null)

{

string strColumnName = properties.List.Fields[i].StaticName.ToString();

ArrColumnNames.Add(strColumnName);

if(item[strColumnName]!=null)

{

ArrOldValues.Add(item[strColumnName]).ToString();

}

string strSqlServerFieldName = "";

string strSqlServerOldFieldValue = "";

for (int j = 0; j < ArrColumnNames.Count - 1; j++)

{

strSqlServerFieldName+= ArrColumnNames[j].ToString()+"!!";

strSqlServerOldFieldValue+= ArrOldValues[j].ToString()+"!!";

}

Getting Column Names, Data Type and Data Dynamically in SharePoint List

Getting Column Names and Data Dynamically in SharePoint List

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="SpFieldsExUserControl.ascx.cs" Inherits="SpFieldsEx.SpFieldsEx.SpFieldsExUserControl" %>

.HeaderClass

{

background-color:Green;

font-weight:bold;

color:White;

}

.InnerDataClass

{

background-color:Orange;

font-weight:bold;

color:White;

}

.BlankTRClass

{

background-color:Red;

height:1px;

}

</style>

<asp:Panel ID="pnlDynamicData" runat="server"></asp:Panel>

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 SpFieldsEx.SpFieldsEx

{

public partial class SpFieldsExUserControl : UserControl

{

protected void Page_Load(object sender, EventArgs e)

{

try

{

string strBindData = string.Empty;

string strHeaderData = string.Empty;

string strInnerData = string.Empty;

ArrayList arrData = new ArrayList();

ArrayList arrColumnType = new ArrayList();

SPWeb currentWeb = SPContext.Current.Web;

SPList lst = currentWeb.Lists["Employees Data"];

SPQuery sQuery = new SPQuery();

sQuery.Query = "<OrderBy><FieldRef Name='ID' /></OrderBy>";

SPListItemCollection mycoll = lst.GetItems(sQuery);

int count = 0;

strHeaderData += "<Tr class='HeaderClass'>";

if (mycoll.Count > 0)

{

for (int i = 0; i < lst.Fields.Count - 1; i++)

{

if (!lst.Fields[i].Hidden && !lst.Fields[i].ReadOnlyField && lst.Fields[i].Type != SPFieldType.Attachments && lst.Fields[i].Title != "Content Type")

{

strHeaderData += "<Td>";

strHeaderData += lst.Fields[i].Title;

strHeaderData += "</Td>";

arrData.Add(lst.Fields[i].StaticName);

arrColumnType.Add(lst.Fields[i].Type.ToString());

count++;

}

strHeaderData += "</Tr>";

strBindData += "<Table width='100%' cellpadding='1' cellspacing='0'>";

strBindData += "<Tr class='BlankTRClass'>";

strBindData += "<Td Colspan='"+count+"'>";

strBindData += "</Td>";

strBindData += "</Tr>";

strBindData += strHeaderData;

foreach (SPListItem item in mycoll)

{

strInnerData += "<Tr class='InnerDataClass'>";

for (int k = 0; k < arrData.Count; k++)

{

strInnerData += "<Td>";

if (arrColumnType[k].ToString() == "Lookup")

{

string strLookUpColumn = item[arrData[k].ToString()].ToString();

SPFieldLookupValue strLookUp = new SPFieldLookupValue(strLookUpColumn);

strInnerData += strLookUp.LookupValue;

}

if (arrColumnType[k].ToString() == "DateTime")

{

DateTime strDtJoingDate=Convert.ToDateTime(item[arrData[k].ToString()]);

strInnerData += strDtJoingDate.ToShortDateString();

}

if (arrColumnType[k].ToString() == "Text")

{

strInnerData += item[arrData[k].ToString()].ToString();

}

if (arrColumnType[k].ToString() == "Choice")

{

strInnerData += item[arrData[k].ToString()].ToString();

}

strInnerData += "</Td>";

}

strInnerData += "</Tr>";

strInnerData += "<Tr class='BlankTRClass'>";

strInnerData += "<Td Colspan='" + count + "'>";

strInnerData += "</Td>";

strInnerData += "</Tr>";

}

strBindData += strInnerData;

strBindData += "</Table>";

for (int l = 0; l < arrColumnType.Count; l++)

{

Response.Write("The Column Type Of " + arrData[l].ToString()+" is "+ arrColumnType[l].ToString()+"<Br />");

}

pnlDynamicData.Controls.Add(new LiteralControl(strBindData));

}

catch (Exception Ex)

{

Response.Write(Ex.ToString());

}