My Techy Memories

Windows Azure Monitoring using SCOM2007

2012-02-08T11:29:00.001-08:00

http://www.microsoft.com/download/en/details.aspx?id=11324

Running PowerShell Scripts from a SCOM Management Pack

2012-01-26T12:49:00.001-08:00

http://blogs.technet.com/b/brianwren/archive/2008/02/20/running-powershell-scripts-from-a-management-pack.aspx

A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe.

2012-01-04T22:02:00.000-08:00

When you create a Visual Webpart using Visual Studio 2010 you may see the following error:

A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe.

The reason for this error is if we modify default namespace into custom namespace, Visual Studio 2010 Package is not generating webpart file properly.

1) Make sure your webpart is added into Safe Control list in Web.config file.

2) Open your .webpart file in your visual studio -Make sure type element name has proper namespace & class name.

When you made changes to default name space which is being generated by visual studio, you may not see updated namespace in type element. So make sure your webpart name space name & webpart class name placed correctly in type element's name attribute

type name="WebpartNameSpace.WebPartClassName", $Sharepoint.Project.AssemblyFullName$

3) Access http://server/_layouts/newdwp.aspx page and make sure webpart exist. If webpart not shown in the list, still your webpart name space/classname not matches to your safe control entry in web.config file.

4) Access http://server/_catalogs/wp/Forms/AllItems.aspx. By clicking on webpart opens webpart in webpart preview page.

Windows Azure Package Build Error: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

2011-12-14T11:08:00.000-08:00

I often see when packaging Windows Azure project getting "The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters." error.

To fix this issue I had to change Cloud Project User options file add add ServiceOutputDirectory entry to the file.

1) Open your Cloud Project file in Windows Explorer from Visual Studio.
2) Find Cloud Project file in opened directory (*.ccproj file)
3) Open file in Notepad
4) Add c:\azure entry

Now your cloud visual studio project user options file looks similar to below:

5) Save file and open your solution again.
6) Package Solution and it should package without above error.

Get Sharepoint2010 Web Analytics from Sql Server

2011-10-24T14:20:00.000-07:00

http://msdn.microsoft.com/en-us/library/dd773850(v=office.12).aspx

http://otak-otak-it.blogspot.com/2011/05/how-to-get-sharepoint-2010-web.html

BCS Model with WCF Service

2011-08-17T14:49:00.001-07:00

http://msdn.microsoft.com/en-us/library/ff953200.aspx

How to increase Sharepoint Silverlight Webpart Timeout

2011-07-23T22:58:00.000-07:00

Often you may see the following message when loading Silverlight webpart on sharepoint.

"To re-configure the Web Part or to provide a different Silverlight application (.xap), open the tool pane and then click Configure"

You can download SLTimeout webpart and set Timeout property.

http://buyevich.blogspot.com/2011/02/setting-time-out-for-silverlight-web.html

Hide Listview webpart Header/Columns

2011-07-21T14:43:00.000-07:00

Add Content Editor Webpart to Page and set viewheadertr attribute to none and set Content Editor Webpart as Hidden.

<style>

.ms-viewheadertr { display: none;}

</style>

This hides all your list views header.

Display Images From Database In Silverlight

2011-07-14T11:52:00.000-07:00

http://www.dotnetcurry.com/ShowArticle.aspx?ID=220

Modular WPF with MEF (Managed Extensibility Framework) & MVVM

2011-07-13T12:37:00.000-07:00

Screencast: Modular WPF with MEF & MVVM Tutorial Part 1

http://mark-dot-net.blogspot.com/2011/07/screencast-modular-wpf-with-mef-mvvm.html

Screencast: Modular WPF with MEF & MVVM Tutorial Part 2

http://mark-dot-net.blogspot.com/2011/07/screencast-modular-wpf-with-mef-mvvm_11.html

Data Driven Applications with MVVM

2011-07-13T12:12:00.000-07:00

Data Driven Applications with MVVM Part I: The Basics

http://www.silverlightshow.net/items/Data-Driven-Applications-with-MVVM-Part-I.-The-Basics.aspx

Data Driven Applications with MVVM Part II: Messaging, Unit Testing, and Live Data Sources

http://www.silverlightshow.net/items/Data-Driven-Applications-with-MVVM-Part-II.-Messaging-Unit-Testing-and-Live-Data-Sources.aspx

Data Driven Applications with MVVM Part III: Validation, Bringing the UI Closer

http://www.silverlightshow.net/items/Data-Driven-Applications-with-MVVM-Part-III.aspx

Silverlight ViewModel Unit Testing

2011-07-12T16:45:00.001-07:00

http://www.timmykokke.com/2010/12/unit-testing-mvvm-in-silverlight-sdn-eventcode-and-slides/

Explains async calls Unit Testing in Silverlight

Part1
http://www.silverlightshow.net/items/Silverlight-Testing-Part-1-Testing-the-untested.aspx

Part2
http://www.silverlightshow.net/items/Data-Driven-Applications-with-MVVM-Part-II.-Messaging-Unit-Testing-and-Live-Data-Sources.aspx

Creating FAST Managed Properties using Power shell

2011-07-11T16:32:00.000-07:00

Add-PSSnapin Microsoft.SharePoint.PowerShell
if([Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")-eq$null){throw "Unable to load Microsoft.SharePoint.dll";}

Add-PSSnapin Microsoft.FASTSearch.PowerShell
if([Reflection.Assembly]::LoadWithPartialName("Microsoft.FASTSearch.PowerShell")-eq$null){throw "Unable to load Microsoft.FASTSearch.dll";}

function SetManagedProperties([string]$mpName, [int]$mpType = 0, [string]$cpName, [int]$sortableType = 0, [bool]$isQueryable = $false, [bool]$isRefiner = $false, [string]$ftiName, [int]$indexMapping = 1){

    if($mpName -eq $null){
        Write-Host "Error: Managed Property Name is null"
        return;
    }
    if($mpType -eq 0){
        Write-Host "Error: Managed Property Type should be grater than zero"
        return;
    }
    if($cpName -eq $null){
        Write-Host "Error: Crawled Property Name is null"
        return;
    }

    $mp = Get-FASTSearchMetadataManagedProperty $mpName

    if($mp -ne $null){
        Remove-FASTSearchMetadataManagedProperty -Name $mpName -Force
        Write-Host "Removing existing managed property ($mpName).."
    }

    $cp = Get-FASTSearchMetadataCrawledProperty -Name $cpName

    if($cp -eq $null){
        Write-Host "Error: $cpName - Crawled Property Not Found."
        return;
    }

    try{

        $mp = New-FASTSearchMetadataManagedProperty -Name $mpName -Type $mpType
    }
    catch{
        Write-Host "Error in creating managed property - $mpName"
        return;
    }

    try{
        $pMapping = New-FASTSearchMetadataCrawledPropertyMapping -CrawledProperty $cp -ManagedProperty $mp
    }
    catch{
        Write-Host "Error in Mapping managed property - $mpName & Crawled Propery - $cpName"
        return;
    }

    $fti = Get-FASTSearchMetadataFullTextIndex -Name $ftiName

    try{
        New-FASTSearchMetadataFullTextIndexMapping -ManagedProperty $mp -FullTextIndex $fti -Level $IndexMapping
    }
    catch{
        Write-Host "Error in Index Mapping to Managed Property - $mpName & Crawled Propery - $cpName"
        return;
    }

    try{
        Set-FASTSearchMetadataManagedProperty -Name $mpName -MergeCrawledProperties $true -Queryable $isQueryble -SortableType $sortableType -RefinementEnabled $isRefiner
    }
    catch{
        Write-Host "Error on enable Sortable, Queryable, RefinementEnabled for Managed Property - $mpName & Crawled Propery - $cpName"
        return;
    }
    Write-Host "$mpName created successfully!"
}

#mpType (1-Text, 2-Integer, 3-Boolean, 4-Float, 5-decimal, 6-DateTime)
#sortableType (0-Disabled, 1-Enabled)
#indexMapping (1 to 7)
SetManagedProperties -mpName "ManagedPropertyName" -mpType 1 -cpName "CrawledPropertyName" -sortableType 0 -isQueryable $false -isRefiner $false -ftiName "Content" -indexMapping 1

Power Shell Operators

2011-07-11T12:17:00.001-07:00

http://www.computerperformance.co.uk/powershell/powershell_syntax.htm#Operators_

Power Shell Scripts

2011-06-14T21:55:00.001-07:00

http://technet.microsoft.com/en-us/scriptcenter/dd742419

Explains Functions/Scripts/Args
http://devcentral.f5.com/weblogs/Joe/archive/2009/01/13/powershell-abcs---p-is-for-parameters.aspx

How to pass params:
param(
    [string] $optionalparam1, #an optional parameter with no default value
    [string] $optionalparam2 = "default", #an optional parameter with a default value
    [string] $requiredparam = $(throw ""requiredparam required."), #throw exception if no value provided
    [string] $user = $(Read-Host -prompt "User"), #prompt user for value if none provided
    [switch] $switchparam; #an optional "switch parameter" (ie, a flag)
    )

eg:

# Begin script foo.ps1
param([string]$foo = "foo", [string]$bar = $(Read-Host -promt "Bar Value"))
Write-Host "Arg: $foo"
Write-Host "Arg: $bar"
# End script foo.ps1

Passing InitParams to the Silverlight App

2011-06-13T21:55:00.001-07:00

http://abhijitjana.net/2010/11/03/how-to-pass-initparams-to-silverlight-application-which-is-hosted-as-sharepoint-2010-web-parts/

http://blogs.msdn.com/b/kaevans/archive/2008/10/08/hosting-silverlight-in-a-sharepoint-webpart.aspx

Show chart data in Silverlight
http://www.synergyonline.com/blog/blog-moss/Lists/Posts/Post.aspx?ID=26

Render Silver light with Silverlight 3.0 without silver light server control:

http://karinebosch.wordpress.com/2009/07/17/integrating-silverlight-3-in-sharepoint-2007/

http://karinebosch.wordpress.com/2009/07/24/create-a-sharepoint-application-page-hosting-a-silverlight-3-application/

FAST Search Sharepoint2010 Installation

2011-06-12T22:07:00.001-07:00

http://www.dotnetscraps.com/dotnetscraps/category/FAST-Search-2010.aspx

Sharepoint Videos

2011-05-26T10:24:00.001-07:00

http://www.sharepoint-videos.com/all-free-videos/

Delegates

2011-05-13T16:24:00.000-07:00

http://www.akadia.com/services/dotnet_delegates_and_events.html

Sharepoint with Powershell

2011-05-11T11:46:00.001-07:00

http://sharepoint.microsoft.com/blogs/zach/Lists/Posts/Post.aspx?ID=7

http://blumenthalit.net/blog/Lists/Posts/Post.aspx?ID=30

How does Sharepoint work?

2011-05-08T12:23:00.000-07:00

Q.How Does SharePoint work?
Ans. The browser sends a DAV packet to IIS asking to perform a document check in. PKMDASL.DLL, an ISAPI DLL, parses the packet and sees that it has the proprietary INVOKE command. Because of the existence of this command, the packet is passed off to msdmserv.exe, who in turn processes the packet and uses EXOLEDB to access the WSS, perform the operation and send the results back to the user in the form of XML.

Ref: http://mysharepointwork.blogspot.com/2011/05/sharepoint-interview-questions-iii.html

SPWeb Dispose Patterns

2011-05-08T12:07:00.001-07:00

http://blogs.msdn.com/b/rogerla/archive/2008/02/12/sharepoint-2007-and-wss-3-0-dispose-patterns-by-example.aspx

How to link your Site Definition with Site Template

2011-05-07T12:48:00.000-07:00

When you have a new site definition (onet.xml) is ready, and in order to make that definition available into site template you have to create a webtemp*.xml file into 12\template\1033\xml\webtemp*.xml.

The following is the thumb rule to create web temp file.

The name of the template must match the name of the folder in which you store the site definition. Every site definition needs a unique identifier on your computer. The site definition allows for one configuration as you have defined it in Onet.xml.

If you store your onet.xml in MyCustomSite folder ( 12\Template\SiteTemplates\MyCustomSite\XML\Onet.xml) you have to create your webtemp file as webtempMyCustomSite.xml in 12\Template\1033\XML\webtempMyCustomSite.xml. Make sure you have unique configuration ids maintained across the webtemp*.xml files on the computer.

Ref: http://msdn.microsoft.com/en-us/library/dd583160(office.11).aspx

Enable Sharepoint Errors

2011-05-05T10:06:00.000-07:00

By default Sharepoint won't show you actual error if any error occurs in the application. We have to disable custom errors & Callstack to true on web.config page.

http://blog-sharepoint.blogspot.com/2009/12/sharepoint-webconfig-how-to-show-full.html

SPWeb Property Bag

2011-04-19T22:41:00.000-07:00

The following url explains about SPWeb Property bag and how to add properties to the SPWeb Properties.

http://trentacular.com/2009/06/sharepoint-the-wicked-spwebproperties-propertybag/

Hierarchical Object Store (SPPersistedObject)

Provides the methods for an object to automatically serialize its state, persist that state in a permanent store, retrieve it at a later time, and deserialize it back into an in-memory object.

http://www.chaholl.com/archive/2011/01/30/the-skinny-on-sppersistedobject-and-the-hierarchical-object-store-in.aspx

http://www.chaholl.com/archive/2010/12/13/persisting-a-stream-to-the-sharepoint-configuration-database.aspx

Create DefaultSharepoint Groups

2011-04-13T18:24:00.001-07:00

I am recently trying to create site collection using Admin Web Service. When site creating using admin web service, share point not creating default share point groups. You have to write custom code to create share point default groups. The following is the code to create default sp groups.

public bool CreateDefaultSPGroups(string url)

{

bool isGroupsCreated = false;

try

{

using (SPSite site = new SPSite(url))

{

using (SPWeb web = site.OpenWeb())

{

web.CreateDefaultAssociatedGroups(site.Owner.LoginName, site.SecondaryContact.LoginName, string.Empty);

isGroupsCreated = true;

}

catch (Exception ex)

{

isGroupsCreated = false;

}

return isGroupsCreated;

}

RunPowershellCommand From ASPx Page

2011-04-07T10:55:00.001-07:00

private void RunPowershellCommand(string loginName)

{

try

{

PSSnapInException exc = new PSSnapInException();

RunspaceConfiguration rc = RunspaceConfiguration.Create();

PSSnapInInfo info = rc.AddPSSnapIn("Microsoft.Sharepoint.Powershell", out exc);

Runspace rs = RunspaceFactory.CreateRunspace(rc);

rs.Open();

Pipeline cmd = rs.CreatePipeline(string.Format("set-SPSite -Identity http://sitecollection -SecondaryOwnerAlias {0}",loginName));

Collection<PSObject> results = cmd.Invoke();

foreach (PSObject str in results)

SendToTextFile(str.ToString());

}

catch (Exception ex)

{

SendToTextFile("RunPowershellCommand() Error: " + ex.ToString());

}

Get all Site Colletions with Primary and Secondary Contatct User Info from Sharepoint Content Database

2011-03-09T14:30:00.000-08:00

--Get all site collections with primary secondary owner user info

Select W.FullURl, W.Title, S.OwnerId,

Max(Case When S.OwnerId = U.tp_Id And S.Id = U.tp_siteId then U.tp_Login End) as PrimaryLogin,

Max(Case When S.OwnerId = U.tp_Id And S.Id = U.tp_siteId then U.tp_Title End) as PrimaryName,

Max(Case When S.OwnerId = U.tp_Id And S.Id = U.tp_siteId then U.tp_Email End) as PrimaryEmailAddress,

S.SecondaryContactID,

Max(Case When S.SecondaryContactID = U.tp_Id And S.Id = U.tp_siteId then U.tp_Login End) as SecondaryLogin,

Max(Case When S.SecondaryContactID = U.tp_Id And S.Id = U.tp_siteId then U.tp_Title End) as SecondaryName,

Max(Case When S.SecondaryContactID = U.tp_Id And S.Id = U.tp_siteId then U.tp_Email End) as SecondaryEmailAddress,

HostHeader, DiskUsed, LastContentChange, W.Id as WebId, W.SiteId, S.RootWebId

From dbo.Sites S Inner Join dbo.Webs W On S.RootWebId = W.Id

Inner join dbo.UserInfo U On S.Id = U.tp_SiteId

Where tp_SiteAdmin =1 and tp_IsActive =1

Group By W.Id, W.SiteId, W.FullURl, W.Title, HostHeader, DiskUsed, LastContentChange, S.OwnerId, S.SecondaryContactID, S.RootWebId, S.RootWebId

-- Get site users with roles & groups
Select W.Id as WebId, W.SiteId, W.FullURl, tp_Id, tp_Login, tp_title, tp_Email, tp_DomainGroup,

R.Title as RoleName, R.RoleId, G.Title as GroupName, GM.GroupId

From Webs W Inner Join Groups G On W.SiteId = G.SiteId

Inner Join GroupMembership GM on GM.SiteId = G.SiteId and GM.GroupId = G.Id

Inner Join UserInfo U on GM.SiteId = U.tp_SiteId and GM.MemberId = U.tp_Id and U.tp_IsActive = 1 and U.tp_Deleted = 0

Inner Join RoleAssignment RA on GM.SiteId = RA.SiteId and GM.GroupId = RA.PrincipalId and W.ScopeId = RA.ScopeId

Inner Join Roles R on R.SiteId = RA.SiteId and R.RoleId = RA.RoleId

Group By W.Id, W.SiteId, W.FullURl, W.Title, U.tp_Id, U.tp_Login, U.tp_title, U.tp_Email, tp_DomainGroup

,GM.GroupId, R.RoleId, R.Title, G.Title

-- Get Site users not added under any group

Select W.Id as WebId, W.SiteId, W.FullURl, tp_Id, tp_Login, tp_title, tp_Email, tp_DomainGroup,R.Title as RoleName, R.RoleId

From Webs W Inner Join RoleAssignment RA on W.SiteId = RA.SiteId and W.ScopeId = RA.ScopeId

Inner Join Roles R on RA.SiteId = R.SiteId and RA.RoleId = R.RoleId

Inner Join UserInfo U on RA.SiteId= U.tp_SiteId and RA.PrincipalId = U.tp_Id and U.tp_IsActive = 1 and U.tp_Deleted = 0

Group By W.Id, W.SiteId, W.FullURl, W.Title, U.tp_Id, U.tp_Login, U.tp_title, U.tp_Email, tp_DomainGroup, R.RoleId, R.Title

-- Find a feature on content db

SELECT DISTINCT dbo.Webs.Id AS WebGuid, dbo.Webs.Title AS SiteName,

dbo.Webs.FullUrl AS SiteUrl, dbo.Features.FeatureId, dbo.Sites.HostHeader

FROM dbo.Features INNER JOIN

dbo.Webs ON dbo.Features.SiteId = dbo.Webs.SiteId

Inner Join Sites ON Webs.SiteId = Sites.Id

WHERE dbo.Features.FeatureId = 'featureId'

-- Find webpart on content db

SELECT DISTINCT D.SiteID, D.WebID, W.Title as SiteName, D.DirName as SiteRelativeUrl,

D.LeafName as PageName, S.HostHeader

FROM dbo.Docs D WITH (nolock)

INNER JOIN dbo.Webs W WITH (nolock) ON D.WebID = W.Id

INNER JOIN dbo.WebParts WP WITH (nolock) ON D.Id = WP.tp_PageUrlID

INNER JOIN dbo.Sites S WITH (nolock) ON D.SiteId = S.Id

WHERE WP.tp_ListId Is Null AND WP.tp_Type Is Null AND WP.tp_Flags Is Null

AND WP.tp_BaseViewID Is Null AND WP.tp_DisplayName Is Null

AND WP.tp_Version Is Null AND WP.tp_WebPartTypeId ='webPartId';

-- Generate WebPart ID from web part assembly name & web part type

string data = assemblyName + "|" + typeName;

byte[] dataBytes = Encoding.Unicode.GetBytes(data);

MD5 hashAlgo = new MD5CryptoServiceProvider();

byte[] hash = hashAlgo.ComputeHash(dataBytes);

Guid hashGuid = new Guid(hash);

WebPartId = hashGuid.ToString();

Get Content Databases from Farm:

SPFarm thisFarm = SPFarm.Local;

SPWebService contentService = (SPWebService)thisFarm.Services.GetValue<SPWebService>("");

foreach (SPWebApplication webApp in contentService.WebApplications)

{

string webAppUrl = webApp.GetResponseUri(SPUrlZone.Default).AbsoluteUri;

foreach (SPContentDatabase contentDb in webApp.ContentDatabases)

{

string server = contentDb.Server;

string dbName = contentDb.Name;

}

Custom Search Result in Sharepoint (FAST Search in 2010)

2011-03-03T15:16:00.000-08:00

The following blog explains FAST 2010 for SharePoint 2010 Managed Properties.

http://blogs.msdn.com/b/shad_phillips/archive/2010/05/31/fast-2010-for-sharepoint-2010-managed-properties.aspx

How to Delete SPView

2011-02-18T13:38:00.000-08:00

Sharepoint Object model doesn't have any SPView.Delete method to delete view.

If you want to delete SPView, you have to delete from SPList.

void DeleteView(SPList list, SPView view)

{

list.Views.Delete(view.ID);

list.Update();

}

Get Yahoo Weather RSS Feed using C#

2011-02-04T17:57:00.000-08:00

http://developer.yahoo.com/weather/

http://developer.yahoo.com/dotnet/howto-xml_cs.html

Run Visual Studio Web Application with x64 version

2011-01-19T12:30:00.000-08:00

By Default Visual Studio's Development Server runs on x86 version, In order to use x64 version we have to use Custom Web Server to run web application/web service on x64. The following URL explains how to setup Custom Web Server for x64 version.

http://patricklamber.blogspot.com/2010/10/file-not-found-exception-when-accessing.html

Custom Search Scopes at Site Collection Level

2010-12-01T15:12:00.000-08:00

static void GetAvailableScopes()

{

SearchContext searchContext;

using (SPSite site = new SPSite("Your Site Collection URL"))

{

searchContext = SearchContext.GetContext(site);

Scopes scopes = new Scopes(searchContext);

foreach (Scope scope in scopes.AllScopes)

{

Console.WriteLine("\t Scope Name: {0}", scope.Name);

}

static void CreateScope()

{

SearchContext searchContext;

using (SPSite site = new SPSite("Your Site Collection URL"))

{

searchContext = SearchContext.GetContext(site);

Scopes scopes = new Scopes(searchContext);

Scope newScope = scopes.AllScopes.Create("Your Custom Scope", "Scope Desc", new Uri(site.Url), true, "Custom Search ASPx Page", ScopeCompilationType.AlwaysCompile);

newScope.Rules.CreateUrlRule(ScopeRuleFilterBehavior.Include, UrlScopeRuleType.Folder, "Document Library Folder with URL");

newScope.Update();

ScopeDisplayGroup group = scopes.GetDisplayGroup(new Uri(site.Url), "Search Dropdown");

group.Add(newScope);

group.Update();

}

private static void RemoveSharedScopes()

{

SearchContext searchContext;

using (SPSite site = new SPSite("your Site Collection URL"))

{

searchContext = SearchContext.GetContext(site);

Scopes scopes = new Scopes(searchContext);

ScopeDisplayGroup group = scopes.GetDisplayGroup(new Uri(site.Url), "Search Dropdown");

foreach (Scope scope in scopes.GetSharedScopes())

{

if (scope.Name == "All Sites" || scope.Name == "People")

group.Remove(scope);

}

group.Update();

}

static void UpdateSiteCollectionSearchCenterSettings()

{

using (SPSite site = new SPSite("Your Site Collection URL"))

{

using (SPWeb web = site.RootWeb)

{

string searchCenter = @"Search Center URL";

web.AllProperties["SRCH_ENH_FTR_URL"] = searchCenter;

web.Update();

}

Sharepoint 2010 Client Object Model Mechanics

2010-11-15T15:58:00.000-08:00

The following post explains about Sharepoint 2010 Client Object model.

http://msdn.microsoft.com/en-us/library/ee857094.aspx

Debug GAC Assembly

2010-10-29T13:31:00.000-07:00

The following post explains Debugging the GAC Assembly without coping .pdb file into GAC.

http://www.elumenotion.com/Blog/Lists/Posts/Post.aspx?ID=23

Entity Framework 4.0 and POCO Performance

2010-09-30T13:56:00.000-07:00

This link explains Entity Framework 4.0 and POCO Performance

http://sharedtolearn.blogspot.com/2010/05/entity-framework-40-poco-performance.html

Java Script Best Practices

2010-09-24T16:54:00.000-07:00

Java Script best Practices

http://www.javascripttoolbox.com/bestpractices/

Sharepoint 2010 Master Page Branding (Known as Minimal Master Page)

2010-09-23T11:27:00.000-07:00

The following two URLs explains sharepoint 2010 Master Page Branding:

http://msdn.microsoft.com/en-us/library/ee354191.aspx

http://msdn.microsoft.com/en-us/library/ee354190.aspx

ASP.Net 4.0 Enhancements

2010-09-10T08:23:00.000-07:00

http://www.codeproject.com/KB/aspnet/Whatis_New_ASP_Net_4.aspx

Design Patterns

2010-08-27T09:38:00.000-07:00

The following link explains four design patterns using real time example.

1) Observer Pattern (Behavioral)

2) Strategy Pattern (Behavioral)

3) Decorator Pattern (Structural)

4) Builder Pattern (Creational)

http://amazedsaint.blogspot.com/2008/01/design-patterns-part-i-and-ii.html

How to sort AlphaNumerics values in SQL Server?

2010-08-13T16:49:00.000-07:00

Column Name [Revision] with Alphanumerics.
Type – varchar(5)
Sample Data as follows:
A B 1 10 2 30 4 5 6 7 10 C D

Sort Revisions by Order By clause:

Select Revision from [#Table1]

ORDER BY CASE WHEN Revision LIKE '%[^0-9]%' THEN 99999

ELSE CONVERT(INTEGER,Revision) END, Revision

Above query select revision and if revision is not numeric value, assigns 99999 values for nonnumeric data. If Revision has numeric value it converts into Integer and Orders the Revision value.

Generate ADO.Net Entity Framework Connection String on RunTime

2010-08-13T16:27:00.000-07:00

When application uses ADO.Net Entity framework, by default connection string saves in web.config file. We can delete the default connection string from web.config file and pass the connection string to the context object as follows.

using System.Data.SqlClient;

using System.Data.EntityClient;

//ConnectionString would be normal sql connection string

string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(connectionString);

EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();

entityBuilder.Provider = "System.Data.SqlClient";

entityBuilder.ProviderConnectionString = sqlBuilder.ToString();

entityBuilder.Metadata = @"res://*/Entities.csdl|res://*/ Entities.ssdl|res://*/ Entities.msl";

EntityConnection conn = new EntityConnection(entityBuilder.ToString());

using (Entities context = new Entities(conn))

{

//Your code ..

}

Create ADO.Net Entity Framework Complex Type

2010-08-11T14:35:00.000-07:00

Complex Type creation in ADO.Net Framework:

http://blogs.msdn.com/b/nihitk/archive/2010/04/23/ado-net-entity-designer-in-vs-2010-stored-procedure-return-type-shape-sensing.aspx

ADO.Net Entity Framework vs Linq to Sql Classes

2010-08-03T15:58:00.000-07:00

http://www.scip.be/index.php?Page=ArticlesNET12

Comparing collections in .NET

2010-07-13T09:37:00.000-07:00

This article explained from Simple comparison to Complex comparison.

http://robertbouillon.com/2010/04/29/comparing-collections-in-net/

Copy Content Types

2010-07-08T11:22:00.000-07:00

Sharepoint Automation of Copy Content Types to another Site:

http://stsadm.blogspot.com/2007/08/copy-content-types.html

ASP.Net Page PostBacks & Callbacks

2010-06-29T13:25:00.000-07:00

http://edndoc.esri.com/arcobjects/9.2/NET_Server_Doc/developer/ADF/pagepost_clientcall.htm

http://www.ajaxmatters.com/2006/05/creating-an-ajax-enabled-grid-using-icallbackeventhandler-part-1/

http://msdn.microsoft.com/en-us/library/ms178208.aspx

http://www.ajaxprojects.com/ajax/tutorialdetails.php?itemid=119#start

log4net AdoNetAppender Connection String from App Config

2010-04-07T14:42:00.000-07:00

Currently log4net version 1.2.10.0 is not supporting reading connection strings from or directly. But in order to read connection string from <appSettings>, we have to override ActivateOptions and ConnectionString property of AdoNetAppender.

Here is the code:

AppSettingsConnectionStringAdoNetAppender.cs file

namespace MyNameSpace

{

[Serializable()]

public class AppSettingsConnectionStringAdoNetAppender : AdoNetAppender

{

public override void ActivateOptions()

{

PopulateConnectionString();

base.ActivateOptions();

}

private void PopulateConnectionString()

{

ConnectionString = ConnectionString;

}

public new string ConnectionString

{

get { return base.ConnectionString; }

set {

base.ConnectionString

= ConfigurationManager.AppSettings["conn1"].ToString();

}

}
}

App.Config Entries for log4net:

<root>

<appender-ref ref="CustomAdoNetAppender"/>

<root>

</parameter>

</appender>

</log4net>

</configuration>

Main Program:

class Program

{

private static readonly ILog log = LogManager.GetLogger(typeof(Program));

static void Main(string[] args)

{

log4net.Config.XmlConfigurator.Configure();

log.ErrorFormat("This is Test Error1!");

Console.ReadLine();

}

This will insert a new error into Database.

Set Difference Minus Operation with LINQ using Except

2010-03-22T14:30:00.000-07:00

If you have morethan two columns to compare in List Object, you need to use Equality Compare Based on Class Objects.

The following program compares two list objects and applies Set Minus operation:

protected void Page_Load(object sender, EventArgs e)

{

List<listclass> lst1 = new List<listclass> {

new listclass { no = 1, revsion =0, title = "title1"},

new listclass { no = 2, revsion =0, title = "title2"},

new listclass { no = 3, revsion =0, title = "titleN"},

new listclass { no = 4, revsion =0, title = "title4"},

};

List<listclass> lst2 = new List<listclass>{

new listclass { no = 1, revsion =0, title = "title1"},

new listclass { no = 2, revsion =0, title = "title2"},

new listclass { no = 3, revsion =0, title = "title3"},

};

var minus = lst1.Except(lst2, new listComparer());

foreach (var item in minus)

{

Response.Write(string.Format("No:{0}, Revision:{1}, Title:{2}", item.no, item.revsion, item.title));

}

public class listclass

{

public int no {get; set;}

public int revsion {get; set;}

public string title { get; set; }

}

public class listComparer : EqualityComparer<listclass>

{

public override bool Equals(listclass x, listclass y)

{

if (ReferenceEquals(x,y)) return true;

return x.no == y.no &&

x.revsion == y.revsion &&

x.title == y.title;

}

public override int GetHashCode(listclass obj)

{

if (ReferenceEquals(obj, null)) return 0;

{

var noHash = obj.no == null ? 0 : obj.no.GetHashCode();

var revsionHash = obj.revsion == null ? 0 : obj.revsion.GetHashCode();

var titleHash = obj.title == null ? 0 : obj.title.GetHashCode();

return noHash ^ revsionHash ^ titleHash;

}

Output:

No:3, Revision: 0, Title: titleN

No:4, Revision: 0, Title: title4

Ref: http://christopherdeweese.com/blog2/post/loving-linq-generics-using-except-with-equalitycomparert

Resize of IFrame

2010-03-05T17:37:00.000-08:00

[script type="text/javascript"]
   document.domain='your domain'

    function AdjustIFrame(h, w,framename)
    {
        document.getElementById(framename).style.height = h + "px";
        document.getElementById(framename).style.width = w + "px";
    }
[/script]

[iframe style="border:none;" scrolling="no" frameborder="0px" src="yoursite" width="100%" id="testframe"][/iframe]

Advanced ADO.Net Entity Framework

2010-01-28T17:04:00.001-08:00

http://blogs.msdn.com/meek/

http://sharedtolearn.blogspot.com/

EF 4.0

http://blogs.msdn.com/b/somasegar/archive/2010/01/11/entity-framework-in-net-4.aspx

AJAX and the ASP.NET 2.0 Callback Framework

2010-01-27T09:03:00.000-08:00

ASP.Net Client Callback model:

http://edndoc.esri.com/arcobjects/9.2/NET_Server_Doc/developer/ADF/ajax_callback.htm

http://msdn.microsoft.com/en-us/library/ms178210.aspx

Script Exploits Overview
http://msdn.microsoft.com/en-us/library/w1sw53ds.aspx

Creating & Adding Eventhandler to Sharepoint Doc Library

2010-01-19T14:42:00.000-08:00

Adding Events & Registering Events:

http://farhanfaiz.wordpress.com/2007/12/31/creating-adding-an-event-handler/

Get Available Events for Sharepoint Library:

static void GetEvent()
        {
            using (SPSite site = new SPSite("http://moss2003/"))
            {
                using (SPWeb web = site.OpenWeb())
                {
                    SPDocumentLibrary doc = (SPDocumentLibrary)web.GetList("Shared Documents");

                    foreach (SPEventReceiverDefinition def in doc.EventReceivers)
                    {
                        Console.WriteLine("Name:{0}",def.Name);
                    }
                }
            }
        }

Work Around for Updating Event Fires Twice:

http://support.microsoft.com/kb/939307/en-us

if (properties.AfterProperties["vti_sourcecontrolcheckedoutby"] == null && properties.BeforeProperties["vti_sourcecontrolcheckedoutby"] != null)
            {
                //This is when the update event is triggered by check-in.
            }
            else
            {
                //This is triggered by events other than check-in action.
            }

Create Multiple Contents for Document Library:

If you want to get Multiple Templates under Document Library "New" create custom content types for Share point document library. The following URL explains how to create Custom Content with Template.

http://grumpywookie.wordpress.com/2008/08/26/microsoft-word-template-dotx-sharepoint-contenttype/

Create Custom Content Document Templates:

http://platinumdogs.wordpress.com/2010/01/15/provision-a-content-type-with-a-document-template-using-a-feature-part-1/

http://platinumdogs.wordpress.com/2010/01/15/provision-a-content-type-with-a-document-template-using-a-feature-%e2%80%93-part-2/

CAML Query Tool

2010-01-16T23:49:00.000-08:00

http://www.u2u.be/Res/Tools/CamlQueryBuilder.aspx

SharePoint - Development and Programming Forum

2009-12-29T10:22:00.000-08:00

Microsoft Ramp up Videos:

http://msdn.microsoft.com/en-us/rampup/default.aspx

Sharepoint Forum:

http://social.msdn.microsoft.com/forums/en-US/sharepointdevelopment/threads/

How to Create a MOSS 2007 VPC Image:
http://www.pptspaces.com/sharepointreporterblog/Lists/Posts/Post.aspx?ID=28

Sharepoint 2010 Videos (Channel 9):
http://channel9.msdn.com/learn/courses/SharePoint2010Developer/

Inside Look at Developing with Microsoft® Windows® SharePoint® Services 3.0

2009-12-29T10:21:00.000-08:00

WSS 3.0 Development Training:

https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=61917&tab=overview

How To: Encrypt Configuration Sections in ASP.NET 2.0

2009-10-15T09:11:00.000-07:00

The following Two URLs explains Encryption of Config Sections in ASP.Net2.0

http://aspnet.4guysfromrolla.com/articles/021506-1.aspx

http://msdn.microsoft.com/en-us/library/ms998280.aspx

MSDN Magazine

2009-10-06T09:00:00.000-07:00

http://www.nxtbook.com/nxtbooks/cmp/msdnmag1009/

Truncate/Shirnk ldf File in Sql Server2005

2009-09-17T14:41:00.000-07:00

The following Sql Statements will clear .ldf file into normal size.

Declare @logfile_id int
Backup Log <> with No_Log
Select @logfile_id = max(fileid) from dbo.sysfiles where name like '%log%'
DBCC Shrinkfile (@logfile_id, truncateonly)

My 10GB Database ldf came back to 2 MB. :-)

Microsoft Ajax 4 Preview 5: The DataView Control

2009-09-17T09:32:00.000-07:00

http://weblogs.asp.net/infinitiesloop/archive/2009/09/10/microsoft-ajax-4-preview-5-the-dataview-control.aspx

Dataview Control Complete Example:

http://weblogs.asp.net/jimwang/archive/2008/11/05/working-with-ado-net-data-services-in-ajax.aspx

What is Windows Azure?

2009-09-14T14:28:00.000-07:00

Good Article from SivaPrasad ...

http://www.dotnetspark.com/kb/702-windows-azure-faq-part-1.aspx

You can find lot of Sample Videos of SivaPrasad on Questpond.com

http://www.questpond.com/demo.html

Sharepoint Workflows using Designer:

http://www.dotnetspark.com/kb/532-8-steps-to-create-workflows-using-sharepoint.aspx

Sharepoint Basics By Siva Prasad:

You can find five useful links from this web page.

http://www.dotnetspark.com/kb/515-sharepoint-workflow-basics.aspx

Differences between WCF & ASMX:

http://www.keithelder.net/blog/archive/2008/10/17/WCF-vs-ASMX-WebServices.aspx

Basics of WPF Databinding:
http://msdn.microsoft.com/en-us/library/ms752347.aspx

Sharepoint Six Series of FAQs ... Its almost explains Sharepoint Model.

http://www.codeproject.com/KB/aspnet/SharePoint.aspx

Webpart Overview

2009-08-11T09:13:00.000-07:00

MSDN article for Webpart Overview:

http://msdn.microsoft.com/en-us/library/ms432401.aspx

Open Source Bug Traker S/w

2009-08-04T09:14:00.000-07:00

The Follwing is the open Source Bug Tracker Application, which is written in ASP.Net/C# and Sql Server2005.

http://ifdefined.com/bugtrackernet.html

Thank You.

Get SQL Records using XQuery

2009-08-03T14:30:00.000-07:00

XML DataType Functions:

Function	Description
Query	Gets a set of nodes from an XML document/fragment (returns XML)
Value	Gets a single value from an element or attribute of an XML document/fragment (returns scalar value)
Exist	Returns a Boolean value indicating if the XQuery expression returns values
Modify	Changes values in an XML document/fragment
Nodes	Gets a context to a node based upon the XQuery expression

The Following Query runs on AdventureWorks HumanResources.JobCandidate Table to get all Employee First Name & Last Name, Telephone Nos.

SELECT