SharePoint2u

Tuesday, January 19, 2010

Iframe

Thursday, January 14, 2010

How set distinct value to dropdown list

private void FillInt()
{
using (SPSite site = SPContext.Current.Site)
{
using (SPWeb web = site.OpenWeb())
{
web.Lists.IncludeRootFolder = true;
SPList ChartList = web.Lists["Organization Charts"];

//query.Query = "USA";

SPQuery query = new SPQuery();
query.Query = "";
SPListItemCollection listItems = ChartList.GetItems(query);
foreach (SPListItem listItem in listItems)
{
FillDropDownList(listItem, ddlGroup, "field");
}
}
}
}
private void FillDropDownList(SPListItem listItem,DropDownList ddlTemp, string fieldName)
{
if (null == ddlTemp.Items.FindByText(listItem[fieldName].ToString()))
{
ListItem ThisItem = new ListItem();
ThisItem.Text = listItem[fieldName].ToString();
ThisItem.Value = listItem[fieldName].ToString();
ddlTemp.Items.Add(ThisItem);
}

}

How to get distinct value from CAML query

Many times, we face a challenge to get unique rows froma CAML query. The main problem is that CAML does not have any feature to get the distinct rows in one go.

Way Around:

We all know that CAML query returns SPListItemCollection and we can convert the outcome to data table also.
We can convert the resultant datatable to dataview and again convert the dataview to datatable by using ToTable and arguments :
Distinct = true
and column name

So..
suppose we have SPWeb object as 'web' so

DataTable DT= web.GetSiteData(qry);
DataView v = new DataView(tbl);
return v.ToTable(true, "Type");

This code snippets returns the distinct rows by comparing column name "Type".

copy from: http://firstblogofvarun.blogspot.com/2009/05/how-to-get-distinct-value-from-caml.html

Thursday, January 7, 2010

print particular part by javascript

<br /><input type="button" value="Print" onclick="JavaScript:printPartOfPage('MSOZoneCell_WebPartWPQ3');" ><br /><br /><script language=JavaScript><br /><!--<br />function printPartOfPage(elementId)<br />{<br /> var printContent = document.getElementById(elementId);<br /> var windowUrl = 'about:blank';<br /> var uniqueName = new Date();<br /> var windowName = 'Print' + uniqueName.getTime();<br /> var printWindow = window.open(windowUrl, windowName, 'left=50000,top=50000,width=0,height=0');<br /><br /> var actContent = "<%@ Page Language='C#' Inherits='System.Web.UI.Page' %><!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>";<br /> var actContent = actContent + "<%@ Register TagPrefix='SharePoint' Namespace='Microsoft.SharePoint.WebControls' Assembly='Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' %> ";<br /> var actContent = actContent + "<%@ Import Namespace='Microsoft.SharePoint' %>";<br /> var actContent = actContent +  "<HTML>";<br /> var actContent = actContent +  "<HEAD>";<br /> var actContent = actContent +  "<link rel='stylesheet' type='text/css' href='/_layouts/1033/styles/core.css' />";<br /> var actContent = actContent +  "<link rel='stylesheet' type='text/css' href='/Style Library/CSS/RedIconsNewsXSL.css' />";<br /> var actContent = actContent +  "<link rel='stylesheet' type='text/css' href='/Style Library/CSS/RedIcons.css' />";<br /> var actContent = actContent +  "<link rel='stylesheet' type='text/css' href='/_layouts/1033/styles/calendar.css' />";<br /> var actContent = actContent +  "</HEAD>";<br /> var actContent = actContent +  "<Body>";<br /> var actContent = actContent +  printContent.innerHTML;<br /> var actContent = actContent +  "</Body>";<br /> var actContent = actContent +  "</Html>";<br /> printWindow.document.write(actContent);<br /> printWindow.document.close();<br /> printWindow.focus();<br /> printWindow.print();<br /> printWindow.close();<br />}<br />// --><br /></script><br />

Wednesday, January 6, 2010

copy assembly from GAC

use the command line to copy the file from (for an assembly called system.core, version 3.5.0.0, culture=neutral, publickeytoken=b77a5c561934089)

Final command:
copy C:\windows\assembly\GAC_MSIL\system.core\3.5.0.0__b77a5c561934089\system.core.dll c:\

tiny calendar css

<br /><style type="text/css"><br /><br />/* Tiny Calendar */<br />/* Christophe@PathToSharePoint.com */<br /><br />/* Remove week blocks */   <br />#MontlyViewDefault_CalendarView .ms-cal-weekempty {display:none;} <br />#WeeklyViewDefault_CalendarView .ms-cal-weekempty {display:block;} <br />#MontlyViewDefault_CalendarView .ms-cal-week {display:none;}  <br />#WeeklyViewDefault_CalendarView .ms-cal-week {display:block;}   <br />.ms-cal-weekB {display:none;}   <br />.ms-cal-weekB {display:none;}   <br />/* Shrink cells */   <br />.ms-cal-workitem2B {display:none;}   <br />.ms-cal-noworkitem2B {display:none;}   <br />.ms-cal-nodataBtm2 {display:none;}   <br />.ms-cal-todayitem2B {display:none;}   <br />.ms-cal-workitem {font-size:0px;}   <br />.ms-cal-muworkitem {font-size:0px;}   <br />.ms-cal-noworkitem {font-size:0px;}   <br />.ms-cal-nodataMid {font-size:0px;}   <br />.ms-cal-todayitem {font-size:0px;}   <br />/* thin out header */<br />/*.ms-cal-nav {display:none;}<br />.ms-cal-nav-buttonsltr {display:none;}*/<br />.ms-cal-navheader {padding:0px;spacing:0px;}<br />.ms-calheader IMG {width:20px;}<br />.ms-cal-nav IMG{display:none;}<br />.ms-cal-navselected  IMG{display:none;}<br />/* Abbreviate weekdays */<br />.ms-cal-weekday {letter-spacing:6px; width:18px; overflow: hidden;}<br /><br />.ms-cal-topdayover {visibility:hidden;}<br />.ms-cal-topdayfocusover {visibility:hidden;}<br />.ms-cal-topday-todayover {visibility:hidden;}<br /><br />/*.ms-cal-defaultbgcolor {padding:0;}<br />.ms-cal-defaultbgcolor a {font-size:3px;}<br />.ms-cal-monthitem a {font-size:3px;}<br />.ms-cal-monthitem a:hover {font-size:10px;}<br />.ms-cal-more NOBR {font-size:3px;}<br />.ms-cal-more:hover NOBR {font-size:10px;}*/<br />.ms-cal-weekedge{display:none;}<br />.ms-cal-workhourF{width:5px;}<br />.ms-cal-workhourhalfhour{width:5px;}<br />.ms-cal-workhour{width:5px;}<br />.ms-cal-workhourFFover{width:5px;}<br />.ms-cal-workhourover {width:5px;}<br />.ms-cal-workhourFover {width:5px;}<br /><br />.ms-cal-wtopdayL DIV IMG {width:0px}<br />.ms-cal-wtopdayfocus DIV IMG {width:0px}<br />.ms-cal-wtopday DIV IMG  {width:0px}<br />.ms-cal-wtopday-today DIV IMG  {width:0px}<br />.ms-cal-wtopdayfocusover DIV IMG {width:0px}<br />.ms-cal-wtopdayLover DIV IMG {width:0px}<br />.ms-cal-wtopdayover  DIV IMG {width:0px}<br />.ms-cal-wtopday-todayover  DIV IMG {width:0px}<br /><br />.ms-cal-wtopdayL DIV A SPAN{padding-left:1px;padding-right:1px}<br />.ms-cal-wtopdayfocus DIV A SPAN{padding-left:1px;padding-right:1px}<br />.ms-cal-wtopday DIV A SPAN{padding-left:1px;padding-right:1px}<br />.ms-cal-wtopday-today DIV A SPAN{padding-left:1px;padding-right:1px}<br />.ms-cal-wtopdayfocusover DIV A SPAN{padding-left:1px;padding-right:1px}<br />.ms-cal-wtopdayLover DIV A SPAN{padding-left:1px;padding-right:1px}<br />.ms-cal-wtopdayover DIV A SPAN{padding-left:1px;padding-right:1px}<br />.ms-cal-wtopday-todayover DIV A SPAN{padding-left:1px;padding-right:1px}<br /></style><br />

Friday, September 25, 2009

Debugging Web Parts - a full explanation of the requirements

http://www.bluedoglimited.com/SharePointThoughts/ViewPost.aspx?ID=60

CallStack=true
debug=”true”
level=”Full”
mode=”Off” in the node