SharePoint For Dummies

Start With MVC Application Part 1

2013-02-13T12:03:00.001+05:30

Before we starting to create MVC Application we required customer table on which we create our application. So first create customer table as show in below

CREATE TABLE [dbo].[tblCustomer]
( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NOT NULL, [Address] [varchar](500) NOT NULL, [City] [varchar](50) NOT NULL,[State] [varchar](50) NOT NULL,[Country] [varchar](50) NULL, [Phone] [varchar](15) NULL, [EmailId] [varchar](50) NULL,
CONSTRAINT [PK_tblCustomer] PRIMARY KEY CLUSTERED ( [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GO

We creating our MVC Application with Visual Studio 2010. Start your visual studio, from File menu select New Project as shown in below. Select ASP.NET MVC 2 Web Application template (other wise download template from http://www.asp.net/mvc) give name MyFirstApplication and click on Ok in next screen skip Unit Test Project Creation.

Right click on models folder and LINQ to SQL Classes with name Application, select database and drag n drop tblCustomer on design surface area with this step we completed our prerequisite of our application

Create customer folder under views folder in which we are going to store all customer related methods. Now we going to create CRUD methods for Customer using MVC. First we create controller for customer for this right click on Controllers folder and add controller with name CustomerController. This is one of the most important step while creating MVC Application.

When we create controller Index method created it contains Index method. We use this method to show list of all record from that controller. Add following code in Index method which returns list of customers.

public ActionResult Index()
{
var Customers = from vcustomer in this.dbContext.tblCustomers
select vcustomer;
return View(Customers);
}

Right click on Index method then select Add View menu from pop menu. In Add view window set parameter as shown in the picture below

After clicking on Add button Visual Studio create Index.Aspx page in Views/Customer folder which will be our landing page for Customers. Now we have to add customer menu in master page for this open Site.Master page from Shared folder. In master page add Html.ActionLink for customer as shown below

<ul id="menu">

<li><%= Html.ActionLink("Home", "Index", "Home")%></li>
<li><%= Html.ActionLink("Customer", "Index", "Customer")%></li>
<li><%= Html.ActionLink("About", "About", "Home")%></li>
</ul>

After Adding this compiled and run the web application. In next blog we going to study how to implement CRUD methods for customer object.

How to implement SPCache in SharePoint 2010 ?

2013-02-11T13:28:00.000+05:30

Following code shows implementation of SPCache object in SharePoint 2010.

// Object for Cacheing

public class TestClass
{
public string someData { get; set; }
public TestClass(string myData)
{
this.someData = myData;
}

}

// SPCache Object Settings Cache Parameters

public class MyCache
{
public static SPCacheConfig cacheConfig = new SPCacheConfig();
internal static CacheParameter[] CacheParameters = new CacheParameter[]
{
// DataCache
new CacheParameter(ServiceName,
DataCache,
0xfffff,
PriorityType.High,
new TimeSpan(0,60,0))
};
internal const string ServiceName = "CacheAppStressTest";
internal const string DataCache = "CacheAppStressTest.Data";
}

Create Web part and add following code

public class CustomCache : WebPart
{
Label lblMessage;
Label lblCacheData;
public CustomCache()
{
this.lblMessage = new Label();
this.lblMessage.ID = "lblMessage";
this.lblCacheData = new Label();
this.lblCacheData.ID = "lblCacheData";
}
protected override void CreateChildControls()
{
try
{
byte priority = 0;

MyCache.CacheParameters[0].lifetime = new TimeSpan(0, 1, 0); //Set life time of parameter
MyCache.CacheParameters[0].priority = (PriorityType)priority; // Set priority of paramater
MyCache.cacheConfig.AddCaches(MyCache.CacheParameters);

SPCache.Cache.Put(MyCache.DataCache, new SPCachedObject("Test", new TestClass("some data"), new TimeSpan(1, 0, 0))); // Add cache object into SPCache Collection

TestClass newClass = (TestClass)SPCache.Cache.Get(MyCache.DataCache, "Test");
if (newClass != null)
{
this.lblCacheData.Text = " " + newClass.someData + "";
}
else
{
this.lblCacheData.Text = " Null data";
}
// Remove cache object
SPCache.Cache.Delete(MyCache.DataCache, "Test");
//Display Cache data
this.lblMessage.Text = string.Format("CacheHits={0}\r\nReads={1}\r\nCount={2}\r\nSizeBytes={3}\r\nHitRatio={4}",
SPCache.Cache.TotalCacheHits, SPCache.Cache.TotalReadAttempts, SPCache.Cache.Count, SPCache.Cache.UsedBytes, SPCache.Cache.HitRatio);
MyCache.cacheConfig.RemoveCaches(MyCache.CacheParameters);
}
catch (Exception ex)
{
this.lblMessage.Text = ex.Message;
}
this.Controls.Add(this.lblMessage);
this.Controls.Add(this.lblCacheData);

}
}

Access Business Connectivity Services object using Client Application

2013-02-04T16:51:00.002+05:30

Business Connectivity Service (BCS), enables users to read and write data from external systems - from web services, database, and Microsoft .NET Framework.
Following code snippet shows, how to access BCS object using Client Object Model

We already have BCS list named "Customer", contains columns Name, Address

// Specify your SharePoint Web Url

ClientContext clientContext = new ClientContext("http://contoso:3434");

// Specify SharePoint list name
List list = clientContext.Web.Lists.GetByTitle("Customer");

CamlQuery query = new CamlQuery();

query.ViewXml =
@" <View>
<ViewFields>
<FieldRef Name='Name'/>
<FieldRef Name='Address'/>
</ViewFields>
<Query>
<Where>
<Eq>
<FieldRef Name='Name'/>
<Value Type='Text'>Jhon</Value>
</Eq>
</Where>
</Query>
<RowLimit>100</RowLimit>
</View>";

ListItemCollection listItems = list.GetItems(query);

// Specify which field required to include in list object other wise it throws exception
clientContext.Load(
listItems, items => items.Include(
item => item["Name"], item => item["Address"]));

clientContext.ExecuteQuery();

foreach (ListItem listItem in listItems.ToList())
{
Console.WriteLine("{0} ==> {1}", listItem["Name"].ToString(), listItem["Address"].ToString());
}

An exception occurred when trying to issue security token

2013-01-16T11:15:00.000+05:30

Security Token Service Application Error:

Problems: Unable to Login with Claim base authentication to SharePoint 2010 Site

Errors

An exception occurred when trying to issue security token: The requested service, 'http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc' could not be activated. See the server's diagnostic trace logs for more information.

WebHost failed to process a request.

Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/15688314

Exception: System.ServiceModel.ServiceActivationException: The service '/SecurityTokenServiceApplication/securitytoken.svc' cannot be activated due to an exception during compilation. The exception message is: Method not found: 'System.String System.ServiceModel.Activation.Iis7Helper.ExtendedProtectionDotlessSpnNotEnabledThrowHelper(System.Object)'.. ---> System.MissingMethodException: Method not found: 'System.String System.ServiceModel.Activation.Iis7Helper.ExtendedProtectionDotlessSpnNotEnabledThrowHelper(System.Object)'.

at System.ServiceModel.WasHosting.MetabaseSettingsIis7V2.WebConfigurationManagerWrapper.BuildExtendedProtectionPolicy(ExtendedProtectionTokenChecking tokenChecking, ExtendedProtectionFlags flags, List`1 spnList)

at System.ServiceModel.WasHosting.MetabaseSettingsIis7V2.WebConfigurationManagerWrapper.GetExtendedProtectionPolicy(ConfigurationElement element)

at System.ServiceModel.WasHosting.MetabaseSettingsIis7V2.ProcessWindowsAuthentication(String siteName, String virtualPath, HostedServiceTransportSettings& transportSettings)

at System.ServiceModel.WasHosting.MetabaseSettingsIis7V2.CreateTransportSettings(String relativeVirtualPath)

at System.ServiceModel.Activation.MetabaseSettingsIis.GetTransportSettings(String virtualPath)

at System.ServiceModel.Activation.MetabaseSettingsIis.GetAuthenticationSchemes(String virtualPath)

at System.ServiceModel.Channels.HttpChannelListener.ApplyHostedContext(VirtualPathExtension virtualPathExtension, Boolean isMetadataListener)

at System.ServiceModel.Channels.HttpTransportBindingElement.BuildChannelListener[TChannel](BindingContext context)

at System.ServiceModel.Channels.BindingContext.BuildInnerChannelListener[TChannel]()

at System.ServiceModel.Channels.MessageEncodingBindingElement.InternalBuildChannelListener[TChannel](BindingContext context)

at System.ServiceModel.Channels.BinaryMessageEncodingBindingElement.BuildChannelListener[TChannel](BindingContext context)

at System.ServiceModel.Channels.BindingContext.BuildInnerChannelListener[TChannel]()

at System.ServiceModel.Channels.Binding.BuildChannelListener[TChannel](Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, BindingParameterCollection parameters)

at System.ServiceModel.Description.DispatcherBuilder.MaybeCreateListener(Boolean actuallyCreate, Type[] supportedChannels, Binding binding, BindingParameterCollection parameters, Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, ServiceThrottle throttle, IChannelListener& result, Boolean supportContextSession)

at System.ServiceModel.Description.DispatcherBuilder.BuildChannelListener(StuffPerListenUriInfo stuff, ServiceHostBase serviceHost, Uri listenUri, ListenUriMode listenUriMode, Boolean supportContextSession, IChannelListener& result)

at System.ServiceModel.Description.DispatcherBuilder.InitializeServiceHost(ServiceDescription description, ServiceHostBase serviceHost)

at System.ServiceModel.ServiceHostBase.InitializeRuntime()

at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustServiceHost.InitializeRuntime()

at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)

at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)

at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)

--- End of inner exception stack trace ---

at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)

at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)

Process Name: w3wp

Process ID: 4780

Solution: Uninstall Security Update No. - KB2756920

http://blogs.technet.com/b/praveenh/archive/2013/01/15/issue-found-with-net-framework-3-5-1-security-update-kb2756920.aspx

Hide Sign in as Different User in SharePoint 2010

2013-01-03T17:35:00.000+05:30

Hide sign in as Different User action on welcome menu using customization of welcome control

Open WelCome.ascx file in visual studio. you found this file in controltemplates folder. We want to show only sign out option for welcome menu. Remove menu templates as per your required and save as "Custom_Welcome.ascx"

<%@ 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" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %><%@ Control Language="C#" Inherits="Microsoft.SharePoint.WebControls.Welcome,Microsoft.SharePoint,Version=14.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c" AutoEventWireup="false" compilationMode="Always" %> <SharePoint:PersonalActions accesskey="<%$Resources:wss,personalactions_menu_ak%>" ToolTip="<%$Resources:wss,open_menu%>" runat="server" id="ExplicitLogout" Visible="false"> <CustomTemplate> <SharePoint:FeatureMenuTemplate runat="server" FeatureScope="Site" Location="Microsoft.SharePoint.StandardMenu" GroupId="PersonalActions" id="ID_PersonalActionMenu" UseShortId="true" > <SharePoint:MenuItemTemplate runat="server" id="ID_Logout" Text="<%$Resources:wss,personalactions_logout%>" Description="<%$Resources:wss,personalactions_logoutdescription%>" MenuGroupId="200" Sequence="300" UseShortId="true" /> </SharePoint:FeatureMenuTemplate> </CustomTemplate></SharePoint:PersonalActions><SharePoint:ApplicationPageLink runat="server" id="ExplicitLogin" ApplicationPageFileName="Authenticate.aspx" AppendCurrentPageUrl="true" Text="<%$Resources:wss,login_pagetitle%>" style="display:none" Visible="false" />

Open site master page on page search for register tag of welcome control

<%@ Register TagPrefix="wssuc" TagName="Welcome" src="~/_controltemplates/Welcome.ascx" %>
replace with src="~/_controltemplates/Custom_Welcome.ascx" %>

Refresh the page and get happy...

How to open hyperlinks into modal dialog box in SharePoint 2010

2012-05-15T11:58:00.003+05:30

SharePoint 2010 provides new feature "Modal dialog box". In this blog we shows how to open hyperlinks in modal dialog box using simple jquery selector.

Declaration syntax for modal dialog box is as follows

//Using the DialogOptions class.
var options = SP.UI.$create_DialogOptions();

options.title = "Dialog box title";
options.width = 300;
options.height = 500;
options.url = "PageUrl";

SP.UI.ModalDialog.showModalDialog(options);

//Using a generic object.
var options = {
title: "Dialog box title",
width: 300,
height: 500,
url: "PageUrl" };
SP.UI.ModalDialog.showModalDialog(options);

Now we put above modal dialog syntax in jquery selector

$("[href(selection attributes)'Condition']").click ( function () {
var options = {
title: "Dialog box title",
width: 300,
height: 500,
url: $(this).attr('href')
};
return false;// required to override default behavior of hyperlink tag
});

We have to open link which contains the query string parameters "ShowInDialog=1", then selection condition for it
$("[href*='ShowInDialog=1']")

Attribute for selection
!= is not equal
^= is starts with
$= is ends with
*= is contains

Example for selecting hyper links which contains query string parameter "ShowInDialog=1"
$("[href*='ShowInDialog=1']").click ( function () {

var options = {
title: "Dialog box title",
width: 300,
height: 500,
url: $(this).attr('href')
};
return false;// required to override default behavior of hyperlink tag
});

Modal Dialog in SharePoint 2010

2012-02-01T15:44:00.000+05:30

Modal dialog is new feature provided by SharePoint 2010. SharePoint 2010 uses modal dialog box for add and update items, perform administrator tasks without redirect current page.

To use modal dialog box you have to include client library SP.UI.ModalDialog. syntax for calling modal dialog box is shown below

SP.UI.ModalDialog.showModalDialog({
    url: "Url Of Page",
    title: "Title of Page",
    allowMaximize: true/false,
    showClose: true/false,
    width: in pixel e.g 800,
    height: in pixel e.g 600,
    dialogReturnValueCallback: callbackfunction
    });

Modal dialog box also takes SP.UI.DialogOptions as optional structure, syntax with structure is shown below

var Dialogoptions = SP.UI.$create_DialogOptions();

options.title = "PageTitle";
options.width = 600;
options.height = 800;
options.url = "PageUrl";
dialogReturnValueCallback: callbackfunction ;

SP.UI.ModalDialog.showModalDialog(options);

or you send options using simple generic object

var genericoptions = {
    title: "PageTitle";,
    width: 800,
    height: 600,
   dialogReturnValueCallback: callbackfunction ,
    url: "PageUrl";};

SP.UI.ModalDialog.showModalDialog(options);

//Call back function syntax
function callbackfunction (dialogResult, returnValue) {

}

SPLongOperation error for ItemAdding Event In SharePoint 2010

2012-01-23T13:20:00.000+05:30

We recently upgrade one of our project from SharePoint 2007 to SharePoint 210. In that project we user event handler for list. In ItemAdding event we use to create new site which takes times for creation. So we use SPLongOperation to handle it but in SharePoint 2010 its same code gives error for "Object reference null" for SPLongOperation being statement.
So we had following workaround for this problem.

Create Web Part with following Code and add this web part to publishing Page

protected override void CreateChildControls(){
if (this.Page.Request.QueryString["Processid"] != null)
 {

 using (SPLongOperation ctx = new SPLongOperation(this.Page))
 {
 try
 {
 ctx.LeadingHTML = "Please wait while your operation is being executed.";
 ctx.TrailingHTML = "Site is being created. Please wait....";
 ctx.Begin();

 System.Threading.Thread.Sleep(5000);
 string eid = this.Page.Request.QueryString["Processid"].ToString();
 int count = 1;
 while (true)
 {
 using (SPWeb web = SPContext.Current.Site.OpenWeb(SPContext.Current.Web.ID))
 {
 if (web.Properties[eid].ToString() != "Completed" && count < 18)
 {

 System.Threading.Thread.Sleep(5000);
 count++;
 }
 else
 break;
 }
 }
 ctx.End(this.Page.Request.QueryString["h"].ToString());
 }
 catch (Exception ex)
 {
 this.lbl.Text = ex.Message.ToString() + Environment.NewLine + ex.StackTrace.ToString() ;
 }
 }
 }
}

In event handler modify ItemAdding event as follows

public override void ItemAdding(SPItemEventProperties properties)
 {
 base.ItemAdding(properties);
 string guid
 = string.Format("ProcessId{0}_{1}", DateTime.Now.ToString("MMddyyyy"), Guid.NewGuid().ToString());
 Thread thread = new Thread(() => FunctionName(properties,guid));
 thread .Start();

 properties.Status = SPEventReceiverStatus.CancelNoError;
 properties.Cancel = true;
 SPUtility.Redirect({Url of page on which out put above webpart}, SPRedirectFlags.Default, _currentContext,string.Format ("Processid={0}&h={1}",guid , properties.RelativeWebUrl));
 }

Hope this work for you also

Using PowerShell Command for Visual Upgrade

2012-01-17T18:17:00.000+05:30

Upgrade Visual from SharePoint 2007 to SharePoint 2010 after restoring Content Database on SharePoint 2010 Server.

When we restore content database in SharePoint 2010 from SharePoint 2007, it required to upgrade the Visual to Version 4. Following command will update all the site and sub-sites for provided content database.

$ContentDatabaseName = Get-SPContentDatabase WSS_Content_SharePoint_Database_Restore

$ContentDatabaseName.Sites | Get-SPWeb -limit all | ForEach-Object {$_.UIversion = 4; $_.UIVersionConfigurationEnabled = $false; $_.update()}

How to create workflow in Visio and import it in Sharepoint Designer 2010 - Part 2

2011-12-30T12:58:00.000+05:30

In previous blog we saw how to create and export the workflow diagram in Visio 2010 ( How to create workflow in Visio and import it in Sharepoint Designer 2010 - Part 1 ). In this blog we import workflow file in SharePoint Designer 2010.

Open SharePoint Designer 2010 -> Click on "Open Site" -> In open site window enter site URL on which you want to import the workflow.
Click on "Workflows" in Navigation -> Click on "Import from Visio" button from top ribbon -> In Import workflow from Visio Drawing browse the path of export file and click on Next button.
In this screen Click on List Workflow and from drop down select "Reimbursement Request" list and click on finish.
After click on finish you got following workflow view now we have to set the condition and values for this imported workflow.
1. Click on "Value" in top if statement , here we have to select expense and specifies the limit after which approval is required for it. set the value as shown in fig. below
2. Set approval attributes as shown in fig. below
3. Click on value link after "Is Approved?" from pop up window set approval status field from field from source drop down and set condition equals to approved. If approval status is equal to approved then you have to inform user that his request has been approved by department head. for that set following values as shown in fig. below. and for update item , select current item, add Authorized field and set its values to Yes.
4. Repeat above step for remaining else parts with appropriate messages.
Save current workflow and click on "Check for Errors" button which is on top of ribbon. if workflow complied successfully then pop up message shows "The workflow contains no errors". Go to start options of workflow and check on "Start workflow automatically when item is created." and click on button publish button to publish workflow in selected list.

After this step we had workflow which is published on site, now go to site and add item with Expense amount greater than Rs. 200.

Content type hub problem with Blank Site Template

2011-12-28T12:08:00.000+05:30

As I mentioned in how to deploy content type hub in my previous blog ("Content Type Hubs Publishing in Sharepoint 2010"), after following blog content type is not appearing on site may required to activate the Taxonomy feature on that site, following command required to activate the feature

STSADM -o activatefeature -id 73EF14B1-13A9-416b-A9B5-ECECA2B0604C -url http:// -force

Power Shell Command

Enable-SPFeature -id 73EF14B1-13A9-416b-A9B5-ECECA2B0604C -URL

Hope this work for you also....

Good luck :-)

How to setup content type publishing hub in SharePoint 2010

2011-12-21T17:03:00.000+05:30

What is Content Type Hub ?
Content type hub is new feature of SharePoint 2010 to manage content type centrally (Content Type Gallery) and publish them to subscribed sites.

Prerequisite :

Create two web application on two separate port number. we called site A as publisher and site b as subscribed site.
Create content type on site A called "Content Type Hub Demo" of document base type.

Create service to deploy content type hub

Open SharePoint 2010 Central Administration - > Click on Manage service applications under Application Management section -> Click on New and select Managed Metadata Service
On "Create New Managed Metadata Service" window change following values
Name : Content Type Hub
Database Name : Content_Type_Hub_Database
Use existing application pool: SharePoint Web Service Default
Content Type hub : "Enter the url of web site which going to act as publisher for content type". Click on "Ok" button

How to deploy content type hub ?To deploy content type hub on site you required to activate "Content Type Syndication Hub" feature on publisher site which in Site Collection features.

After activating feature go to content type gallery of site, click on Site Actions -> Site Settings -> under Galleries section you find "Site Content Types" click on it. On site content types page select "Content Type Hub Demo" content type.

In Settings section of Content type Click on "Manage publishing for this content type" and On Content type publishing select "Publish" and click on "OK" button.

After this we required to run Timer jobs manually first time to publish the content type. Go to "SharePoint 2010 Central Administration" -> Click on Monitoring -> Click on Review job definitions.

In Job Definitions run the jobs in following order
1.Content type hub
2.Content Type Subscriber job for publishing site
3.Content Type Subscriber job for subscriber sites.

Go to subscriber site and Content type gallery you find the "Content Type Hub Demo" content type.

How to create workflow in Visio and import it in Sharepoint Designer 2010 - Part 1

2011-12-19T14:20:00.000+05:30

This blog shows how easy to create a workflow in Microsoft Visio 2010 and import it in Sharepoint Designer 2010. This part contains the prerequisites required and how to design workflow in Microsoft Visio 2010. In this blog we create work for "Reimbursement of Expenses", if my expense amount is less then specified limit then request is directly approved otherwise it goes to Department Head for approval.

Prerequisites :

I create custom list called "Reimbursement Request" and added following field into it.

"Description" type of Multiple lines of text.
"Expense Amount" type of Currency.
"Authorized" type of "Yes/No".
"Department Head" type of "person and Group".

Design workflow with Microsoft Visio :

1. Open Microsoft Visio 2010 : Click on Start -> All Programs -> Microsoft Office -> Click on "Microsoft Visio 2010".

2. Create "Microsoft Sharepoint Workflow" : In Template Categories section click on Flowchart -> "Microsoft SharePoint Workflow" and click on Create button as shown in fig. below

3. Create workflow diagram

Each workflow diagram has its start and terminate condition so we put this two condition on drawing area. shown in fig.
Under "Shapes" panel click on "SharePoint Workflow Conditions", drag and drop "Compare data source" control on drawing area. double click on control and change it display text. Click on "SharePoint Workflow Actions" and drag and drop "Start approval process" and "Send an email" as shown in fig. below
Now we have to add condition for Compare data source control, right click on arrow of "Is Expense Amount Required Authorization?" select "Yes" from popup now. click on other arrow and set "No" condition for it. repeat same for "Is Approved?" control.
After setting all condition as shown in fig above click on Process tab from top ribbon and click on "Check Diagram" button. This will validate your workflow diagram and shows if any error before exporting this workflow diagram we have to clear all errors. Once its shows "No issue found" message click on export button and save this drawing as "Visio Workflow InterChange" type. After this step you had workflow ready to use in sharepoint designer 2010.
How to use exported file in "SharePoint Designer 2010" explained in next part to this blog.

Connect Chart Web Part to SQL database in Sharepoint 2010

2011-12-15T15:26:00.000+05:30

1. This blog shows you how to provide data for OOB Charting Web part in Sharepoint 2010. First insert the chart web part into you page as shown in fig. below

2. Create custom web part and specify the database connection as I am retrieving chart data from sql server 2008 database. Copy paste following code into webpart and deploy web part to site collection

[ToolboxItemAttribute(false)]
 [Serializable]
 [AspNetHostingPermission(SecurityAction.Demand, Level = AspNetHostingPermissionLevel.Minimal)]
 [AspNetHostingPermission(SecurityAction.InheritanceDemand, Level = AspNetHostingPermissionLevel.Minimal)]
 public class ChartDataProviderWebPart : WebPart, IWebPartTable
 {

 SqlDataAdapter sda;
 Timer _timer;
 DataTable _table;
 Label _lblMessage;
 string databaseConnectionString = "Data Source=.;Initial Catalog=Demo_Database;user id=username;password=yourpassword;"; // Change setting

 protected override void CreateChildControls()
 {
// Timer control added to refresh chart after every 30 second
 _timer = new Timer();
 this._timer.Interval = 30000;
 this._timer.Tick += new EventHandler<EventArgs>(_timer_Tick);
 this._timer.Enabled = true;
 this.Controls.Add(this._timer);
 this.Controls.Add(this._lblMessage);
 }

 void _timer_Tick(object sender, EventArgs e)
 {
 this._lblMessage.Text = string.Format("Last updated @ {0} ", DateTime.Now.ToString());
 }

 public ChartDataProviderWebPart()
 {
 try
 {
 _table = new DataTable();
 this._lblMessage = new Label();
 this.sda = new SqlDataAdapter("select * from tblData order by name", new SqlConnection(this.databaseConnectionString));
 this.sda.Fill(this._table);
 }
 catch (Exception ex)
 {
 this._table.Columns.Add(new DataColumn("Name"));
 this._table.Columns.Add(new DataColumn("Value"));
 }
 }

 public void GetTableData(TableCallback callback)
 {

 callback(_table.Rows);
 }

 public PropertyDescriptorCollection Schema
 {
 get
 {
 return TypeDescriptor.GetProperties(this._table.DefaultView[0]);
 }
 }

 public bool ConnectionPointEnabled
 {
 get
 {

 object o = ViewState["ConnectionPointEnabled"];
 return (o != null) ? (bool)o : true;
 }
 set
 {
 ViewState["ConnectionPointEnabled"] = value;
 }
 }

 [ConnectionProvider("Table", typeof(DataTableProviderConnectionPoint), AllowsMultipleConnections = true)]
 public IWebPartTable GetConnectionInterface()
 {
 return new ChartDataProviderWebPart();
 }

 }
 public class DataTableProviderConnectionPoint : ProviderConnectionPoint
 {
 public DataTableProviderConnectionPoint(MethodInfo callbackMethod, Type interfaceType, Type controlType, string name, string id, bool allowsMultipleConnections)
 : base(callbackMethod, interfaceType, controlType, name, id, allowsMultipleConnections)
 {

 }

 public override bool GetEnabled(Control control)
 {
 return ((ChartDataProviderWebPart)control).ConnectionPointEnabled;
 }

 }

3. Go to page where you inserted chart web part, insert above deployed webpart on same page. Click on Data & Appearance from chart web part -> Click on Connect Chart To Data

4. After clicking on Connect Chart To Data you got Step by Step Data Connection Wizard

Step 1: Choose Connect to another web part option for this step and click on Next button

Step 2: Connect to another Web Part in drop down you found the name of web part that you deployed now

Step 3: On retrieve data step select Table as source data format in data format dropdown and click on next button

Step 4: On Bind Chart to Data , set Y Field to "Value" and X Field to "Name" as shown in fig. below and click on Finish

This web part refresh after evey 30 second for retriving data from database.

How to programmatically associate a workflow to a list in Sharepoint

2011-12-02T18:43:00.000+05:30

In one of your project we have to attach "Sharepoint approval workflow" to list when feature is activated on the web.

Prerequisite :

SharePoint 2007 Workflows activated on site collection level
Task list of content type Task, for storing task created to users.

private void SetWorkFlow(SPWeb web, string listName)
        {
web.AllowUnsafeUpdates = true;

string workflowAssocName = string.Format("{0} - Sharepoint Approval", listName);
SPWorkflowTemplate workflowTemplate = web.WorkflowTemplates.GetTemplateByName("Approval - SharePoint 2010",
System.Globalization.CultureInfo.CurrentCulture);
SPList myList = web.Lists[listName];

// Try to get workflow history and task list
SPList historyList = web.Lists["Workflow History"];
SPList taskList = web.Lists["Tasks"];

// Create workflow association
SPWorkflowAssociation workflowAssociation = SPWorkflowAssociation.CreateListAssociation(
workflowTemplate, workflowAssocName, taskList, historyList);

// Set workflow parameters
workflowAssociation.AllowManual = false;
workflowAssociation.AutoStartCreate = true;
workflowAssociation.AutoStartChange = false;
workflowAssociation.ContentTypePushDown = false;

// The AssociationData property represents for the settings that user see in 2nd screen when creating workflow in SharePoint UI
var associationDataXml = XElement.Parse(workflowAssociation.AssociationData);

// Update modifed xml segment back to WorkflowAssociation object
workflowAssociation.AssociationData = Add_Association_Data(web.ParentWeb, associationDataXml);

// Add workflow association to my list
myList.WorkflowAssociations.Add(workflowAssociation);

// Enable workflow
workflowAssociation.Enabled = true;
myList.Update();

web.Update();
web.AllowUnsafeUpdates = false;
}

   private String Add_Association_Data(SPWeb oWeb, XElement associationDataXml)
        {
            String sDate = String.Empty;
            XNamespace dNamespace = @"http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields";
            XNamespace pcNamespace = @"http://schemas.microsoft.com/office/infopath/2007/PartnerControls";
            XNamespace dfsNamespace = @"http://schemas.microsoft.com/office/infopath/2003/dataFormSolution";
            XNamespace MyNamespace = @"http://schemas.microsoft.com/office/infopath/2003/myXSD";
            XNamespace XsiNamespace = @"http://www.w3.org/2001/XMLSchema-instance";

            XElement propertiesWrapper = associationDataXml.Element(dfsNamespace + "dataFields").Element(dNamespace + "SharePointListItem_RW");
            propertiesWrapper.SetElementValue(dNamespace + WORKFLOW_SETTINGS_CANCELONREJECTION, true);
            propertiesWrapper.SetElementValue(dNamespace + WORKFLOW_SETTINGS_CANCELONCHANGE, true);
            propertiesWrapper.SetElementValue(dNamespace + WORKFLOW_SETTINGS_APPROVEWHENCOMPLETE, true);
            propertiesWrapper.SetElementValue(dNamespace + WORKFLOW_SETTINGS_ENABLECONTENTAPPROVAL, true);
            propertiesWrapper.SetElementValue(dNamespace + WORKFLOW_SETTINGS_EXPANDGROUPS, false);

            // Reviewers is Approvers in UI
            XElement xAssignement
                = associationDataXml.Element(dfsNamespace + "dataFields").Element(dNamespace + "SharePointListItem_RW").
                Element(dNamespace + "Approvers").Element(dNamespace + "Assignment");

            string ApprovalGroup = "Managers";
            xAssignement.Element(dNamespace + "Assignee").Add(
                new XElement(pcNamespace + "Person",
                      new XElement(pcNamespace + "DisplayName", ApprovalGroup),
                      new XElement(pcNamespace + "AccountId", ApprovalGroup),
                      new XElement(pcNamespace + "AccountType", "SharePointGroup")
                )
            );

            return associationDataXml.ToString();
        }

Hope this will work for you also.............

Create TreeView Structure From Data Table in ASP.Net

2011-07-28T12:48:00.000+05:30

One of my friend want to convert Datatable to Tree Structure, hope this will help you.

class Program

{

static void Main(string[] args)

{

try

{

DataTable dt = new DataTable();

dt.Columns.Add(new DataColumn("Id", Type.GetType("System.Int32")));

dt.Columns.Add(new DataColumn("Name"));

dt.Columns.Add(new DataColumn("ParentNodeId", Type.GetType("System.Int32")));

DataRow dr = dt.NewRow();

dr[0] = "1";

dr[1] = "Number 1";

dr[2] = "0";

dt.Rows.Add(dr);

dr = dt.NewRow();

dr[0] = "2";

dr[1] = "Number 2";

dr[2] = "1";

dt.Rows.Add(dr);

dr = dt.NewRow();

dr[0] = "3";

dr[1] = "Number 3";

dr[2] = "2";

dt.Rows.Add(dr);

dr = dt.NewRow();

dr[0] = "4";

dr[1] = "Number 4";

dr[2] = "1";

dt.Rows.Add(dr);

new CreateTreeNode(dt, "Id", "Name", "ParentNodeId");

Console.WriteLine("Table Created...");

}

catch (Exception ex)

{

Console.WriteLine(ex.Message.ToString());

}

Console.ReadKey();

}

public class TreeNode

{

public int Id { set; get; }

public string Name { get; set; }

public int ParentId { get; set; }

public List ChildeNodes { get; set; }

public TreeNode()

{

this.Id = this.ParentId = 0;

this.Name = string.Empty;

this.ChildeNodes = new List();

}

public TreeNode(int TreeNodeId, string TreeNodeName, int ParentNodeId)

: base()

{

this.Id = TreeNodeId;

this.Name = TreeNodeName;

this.ParentId = ParentNodeId;

}

public class CreateTreeNode

{

List _nodeList;

DataTable _dataTable;

string _nodeColumn;

string _displayNodeColumn;

string _parentNodeColumn;

CreateTreeNode()

{

this._nodeList = new List();

this._dataTable = new DataTable("TreeView");

}

public CreateTreeNode(DataTable dataTable, string NodeColumn, string DisplayNodeColumn, string ParentNodeColumn)

: base()

{

this._dataTable = dataTable;

this._nodeColumn = NodeColumn;

this._displayNodeColumn = DisplayNodeColumn;

this._parentNodeColumn = ParentNodeColumn;

this._nodeList = CreateTreeView(0);

int i = 0;

i++;

}

List CreateTreeView(int parentNodeId)

{

List nodeList;

DataRow[] SelectedRow = this._dataTable.Select(string.Format("{0}={1}", this._parentNodeColumn, parentNodeId));

TreeNode currentNode;

if (SelectedRow.Length <= 0)

return new List();

else

nodeList = new List();

foreach (DataRow currentRow in SelectedRow)

{

currentNode = new TreeNode();

currentNode.Id = Convert.ToInt32(currentRow[this._nodeColumn].ToString());

currentNode.Name = currentRow[this._displayNodeColumn].ToString();

currentNode.ParentId = Convert.ToInt32(currentRow[this._parentNodeColumn].ToString());

currentNode.ChildeNodes = CreateTreeView(currentNode.Id);

nodeList.Add(currentNode);

}

return nodeList;

}

Are you making these 3 common ASP.NET AJAX mistakes?

2011-07-27T16:04:00.000+05:30

I found the very usefull link for those who working with AJAX Controls in ASP.Net

http://encosia.com/are-you-making-these-3-common-aspnet-ajax-mistakes/

How to disable multiple upload button for Document List in Sharepoint 2010

2011-07-26T13:13:00.000+05:30

Open upload.aspx file in Visual Studio, upload.aspx file found this file in "14\TEMPLATE\LAYOUTS" folder.
Search for "if (hideLink)" statement , you have to set hideLink variable to true for hiding the multiple upload button.

hideLink =yourJavaScriptFunction();

if ( hideLink)

...
3. replace yourJavaScriptFunction with your javascript function which returns bool value.

How to Create Event Handler In Sharepoint ?

2011-07-21T14:27:00.000+05:30

Open Visual Studio 2010.
On the File menu -> New and then click on Project.
In project type, select Event Receiver.
Enter Name of Event Receiver , click on Ok button.
Now you get Sharepoint Customization Wizard, Choose Deploy as a Sandboxed solution, click on Next.
In Choose Event Receiver Settings window, Select List Item Events from What type of event receiver do you want? dropdown.
In What item should be the event source ? dropdown, choose type of List on which you want Event Receiver.
Next Choose event on which you want to write code and click on finish
Event Receiver file is created and method for selected event is appeared.
Press F5 for deploy this solution.