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

Wednesday, September 9, 2009

Customizing the Content Query Web Part and Custom Item Styles

http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx
http://blogs.edork.com/MikeGeyer/Lists/Posts/Post.aspx?ID=20

Tuesday, September 8, 2009

Test google.

google-analytics.

Tuesday, August 25, 2009

web part property

http://www.brightworkdemo.com/_vti_bin/help/1033/BrightWork/modify_a_web_part.htm

Monday, August 17, 2009

Get all Document Library List

0

This discards all items except those marked as Files/Documents.

CrossListQueryInfo clqi = new CrossListQueryInfo();
clqi.Query = @"0";
clqi.ViewFields = "";
clqi.Lists = "";
clqi.Webs = "";
clqi.UseCache = true;
clqi.RowLimit = (documentCount==0) ? 5 : (uint)documentCount;
CrossListQueryCache clqc = new CrossListQueryCache(clqi);
DataTable dt = clqc.GetSiteData(SPContext.Current.Site, CrossListQueryCache.ContextUrl());

Thursday, August 6, 2009

Stop Office Sharepoint Search server

pskill \\sharepointservername mssearch
Detail:
http://social.technet.microsoft.com/Forums/en-US/sharepointsearch/thread/9b313d05-73e3-4c3a-ac18-39fefaa4352a

PSTools Downloads:
http://technet.microsoft.com/en-us/sysinternals/dd443648.aspx

Sunday, August 2, 2009

CALM

http://elczara.spaces.live.com/blog/cns!554EC06D366AC9D5!681.entry

PARENT ELEMENT
ELEMENT
DESCRIPTION

Where Used within the context of a query to specify a filter.
And Used within the Where element to group filters in a query for a view.
Or Used within the Where element to group filters in a query.
BeginsWith Searches for a string at the start of a column that holds Text or Note field type values.
Contains Searches for a string anywhere within a column that holds Text or Note field type values.
Eq Arithmetic operator that means "equal to" and is used within a query.
Geq Arithmetic operator that means "greater than or equal to." This element can be used within a Where element in a query.
Gt Arithmetic operator that means "greater than." This element is used similarly to the Eq and Lt elements.
Leq Arithmetic operator that means "less than or equal to." The Leq element is used in view queries similarly to the Eq and Geq elements.
Lt Arithmetic operator that means "less than" and is used in queries in views. This element is used similarly to the Eq and Gt elements.
Neq Arithmetic operator that means "not equal to" and is used in queries.
DateRangesOvelap Used in queries to compare the dates in a recurring event with a specified DateTime value, to determine whether they overlap.
IsNotNull Used within a query to return items that are not empty (Null).
IsNull Used within a query to return items that are empty (Null).
OrderBy Determines the sort order for a query. The OrderBy element contains a group of FieldRef elements.
GroupBy Contains a Group By section for grouping the data returned through a query in a list view.

Thanks.

Wednesday, June 10, 2009

silde library

http://wm.microsoft.com/ms/gsd/mikegannotti/PowerPoint_2007_Slide_Libraries.wmv

Sunday, June 7, 2009

open edit document mode

 string strUrl = "<A onfocus=\"OnLink(this)\"  HREF='" + url + "' onclick=\"return DispEx(this,event,'TRUE','FALSE','TRUE','','0','SharePoint.OpenDocuments','','','','21','0','0','0x7fffffffffffffff')\">" + Request["FileName"].ToString() + "</A>";

Monday, June 1, 2009

WSS Field Names for Lists & Document Libraries

http://blog.thekid.me.uk/archive/2007/03/21/wss-field-display-amp-internal-names-for-lists-amp-document-libraries.aspx

Wednesday, May 27, 2009

hide show file vb script

Set sh = CreateObject("WScript.Shell")

theKey = "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced\Hidden"

setHidden = sh.RegRead(theKey)

If setHidden = 1 Then

setHidden = 0

MsgBox "System and hidden files will no longer appear in Explorer.",64,"Hidden File Exchange"

Else

setHidden = 1

MsgBox "System and hidden files will appear in Explorer.",64,"Hidden File Exchange"

End If

sh.RegWrite theKey,setHidden,"REG_DWORD"

Set sh = Nothing

Thursday, May 14, 2009

How to Create Installer (.cab) for web part?

http://www.codeproject.com/KB/install/WebpartInstaller.aspx Introduction A sample project (Hello world webpart and installer project) and walk through for creating an installer for web part that will install the webpart on the share point portal site. It will make a SafeControl entry in share point portal site's webconfig file, will add a file in the share point portal site's wpcatalog, will create a folder under share point portal site's wpresources directory and add files to the created folder. Assumptions Hello world webpart project is ready for use. Developer knows how to add a webpart to the share point portal site. Developer has knowledge of webparts and share point portal site. How to add a .cab project to the existing web part solution? Right click the solution and navigate to Add -> New Project. Select Setup and Deployment project from project type. Select Cab Project from Template section. Write the appropriate Project name, select the appropriate project location and click OK. How to add (file installation properties) the project output to the .cab project? Right click on the .cab project. Navigate to Add -> Project Output. Select the Primary Output and Content Files from the available list. How to add the file to the Primary Output file installation properties? Right click on the Primary Output. Select Properties. In the Primary Output properties click on Outputs and select the WpSampleHelloWorld.dll. How to add the file to the Content Files file installation properties? Edit Manifest.xml in the webpart project. Under the section <ClassResources>, add an entry like <ClassResource FileName ="minus.gif"/> for each file that needs to be deployed under "wpresources\WpSampleHelloWorld". Assembly mentioned under the section <Assemblies> will be deployed in the share point portal's bin directory. DWP file mentioned under the section <DwpFiles> will be deployed in the share point portal's wpcatalog directory. Right click on the Content Files of the installer project. Select Properties. In Content Files properties click on Outputs and it will show the entire files that are part of the current project in the popup window. How to run the cab file? Edit the .bat file WpSampleHelloWorldInstaller.bat and modify "http://ABC/" to the required portal site. Through the command prompt, navigate to the directory where WpSampleHelloWorldInstaller.bat and WpSampleHelloWorldInstaller.CAB are present. Enter the WpSampleHelloWorldInstaller.bat file name on the command prompt and press the Enter key. It will show a success message. Verify that a SafeControl entry is added to the webconfig file and "WpSampleHelloWorld_1.0.0.0__b8904f2e5aa5eda1_HelloWorld.dwp" file is added to thewpcatalog directory. Create a folder with the name "WpSampleHelloWorld" under wpresource directory and add all the files that are mentioned inmanifest.xml to the "wpresource\WpSampleHelloWorld" directory.