Enable "Master Page" in a team site

We cant see "Master Page" in Look and Feel section

 

Enable "Site Collection" feature

Enable "Site" feature

 

Now we can see "Master Page" under "Look and Feel" section

Download SharePoint 2010 Pre-Requisites

Microsoft SQL Server 2008 Native Client	Download Here
Hotfix for Microsoft Windows (KB976462)	Download Here
Windows Identity Foundation (KB974405)	Download Here
Microsoft Sync Framework Runtime v1.0 (x64)	Download Here
Microsoft Chart Controls for Microsoft .NET Framework 3.5	Download Here
Microsoft Filter Pack 2.0	Download Here
Microsoft SQL Server 2008 Analysis Services ADOMD.NET	Download Here
Microsoft Server Speech Platform Runtime (x64)	Download Here
Microsoft Server Speech Recognition Language – TELE(en-US)	Download Here
SQL 2008 R2 Reporting Services SharePoint 2010 Add-in	Download Here

Microsoft Office 2010 Filter Packs for SharePoint

The Microsoft Filter Pack is a single point-of-distribution for Office IFilters. IFilters are components that allow search services to index content of specific file types, letting you search for content in those files. They are intended for use with Microsoft Search Services (Sharepoint, SQL, Exchange, Windows Search). 

The Filter Pack includes:

* Legacy Office Filter (97-2003; .doc, .ppt, .xls)
* Metro Office Filter (2007; .docx, .pptx, .xlsx)
* Zip Filter
* OneNote filter
* Visio Filter
* Publisher Filter
* Open Document Format Filter

SharePoint 2010 People Picker Programatically

PeopleEditor peoplePick = new PeopleEditor();

        protected override void CreateChildControls()
        {
           
            peoplePick.AllowEmpty = false;
            peoplePick.AllowTypeIn = true;
            peoplePick.BrowseButtonImageName = "Search";
            peoplePick.CheckButtonImageName = "Validate User";
            peoplePick.ErrorMessage = "No Names Found";
            tdPeoplePicker.Controls.Add(peoplePick);
            //this.Controls.Add(peoplePick);
            base.CreateChildControls();
        }

    protected void btnSave_Click(object sender, EventArgs e)
        {           
            foreach (string ent in peoplePick.CommaSeparatedAccounts.Split(','))
            {
                if (ent.Length > 0)
                {
                    PeerReviewGroup_Employee objPeerEmp = new PeerReviewGroup_Employee();
                    objPeerEmp.EmpID = Utility.GetNullableInt(GetSelectedUserIDsByName(ent));
                    objPeerEmp.GroupID = int.Parse(ddlPeerGroup.SelectedValue);

                    PeerReviewGroup_EmployeeService.Save(objPeerEmp);
                }
            }
           
        }

How to kill a remote session using command

Step 1. Gain enough privilege to kill RDP connection on the server.
net use \\servername_or_IP /USER:username “password“

Step 2. List the connection to a particular server and get session ID.
query session /server: servername_or_IP

Step 3.  Reset the session which you don’t need using ID of the session got from previous step

reset session [sessionID] /server:servername_or_IP

Configure Drop-off Library in SharePoint 2010

Sometimes we need to have a common place to upload documents by a clerk & store data in correct data repository without his/her intervention. we can have a "Drop Off Library" and created "Rule", then documents will be stored relevant document library. we don't have to give permission for different users to upload documents to different libraries. It is with SharePoint 2010 :)

Finally we can see, the uploaded document is stored in "SDB Quotations" library. No copy is maintained in "Drop Off Library" . It is simple :)

SharePoint 2010 Recycle bin settings

There are 2 types of recycle bin in SharePoint. Even user deletes an item it will be stored in "Recycle Bin" of admin's. We can set a time period to keep those files in Admin's recycle bin. We can give a quota to recycle bin of normal users as well as admins.

It is also possible to set maximum file size that can be stored in SharePoint. Since all data stored in DB, it is recommended to store medium size files in SharePoint.

Configuring SharePoint 2010 in a Farm environment for Development

(1)    Creating hyper-v machines

a.       Create a hyper-V machine with Windows server 2008 R2

b.      After installation is completed install service pack(s) if any

c.       Go to à /Windows/System32 àSearch “sysprep.exe”

d.      Run it  and select “Shutdown options” in the dropdown

e.      Get a copy of .vhd file & save it for future use as a BASE DISK

(2)    Configure a new “AD server” using BASE DISK

(3)    Create a new “SQL server” using BASE DISK

(4)    Add “SQL server” to AD

(5)    Configure SQL server 2008 R2 64 bit

a.       Install it with native mode

b.      Add “AD admin” user group when installing SQL

(6)    Install latest service pack (if any)

(7)    Create “SharePoint server” using BASE DISK

(8)    Adding server to AD

(9)    Check network configuration of ALL servers

a.       All servers in 1 domain

b.      IP address in static mode

c.       DNS of servers match with IP of AD server IP

(10)Disable firewall in all servers before link each servers

(11)Install SharePoint foundation 2010 pre-requisites

a.       Web Server (IIS) role

b.      Application Server role

c.       Microsoft .NET Framework version 3.5 SP1

d.      SQL Server 2008 Express with SP1

e.      Microsoft Sync Framework Runtime v1.0 (x64)

f.        Microsoft Filter Pack 2.0

g.       Microsoft Chart Controls for the Microsoft .NET Framework 3.5

h.      Windows PowerShell 2.0

i.         SQL Server 2008 Native Client

j.        Microsoft SQL Server 2008 Analysis Services ADOMD.NET

k.       ADO.NET Data Services Update for .NET Framework 3.5 SP1

l.         A hotfix for the .NET Framework 3.5 SP1 that provides a method to support token authentication without transport security or message encryption in WCF.

m.    Windows Identity Foundation (WIF)

(12)Run 10 step SharePoint technology wizard

(13)Install TFS

a.       Use a domain admin account to install TFS

b.      Use “Network Service” as service account when configure TFS

c.       RAM in TFS server should be > 2 GB

d.      Firewall should be disabled

(14)Accounts that used

a.       SQL == ESPMS\admin

b.      SharePoint install = ESPMS\administrator

c.       SharePoint wizard == ESPMS\spfarmadmin

Complex LINQ query with outer joins and customized columns

using (VonQuestDBDataContext context = new VonQuestDBDataContext())

            {

                var lines =

                    from P in context.VQPlayers

                    join T in context.VQPlayerTippings on P.VQPlayerID equals T.VQPlayerID into T_t

                    from T in T_t.DefaultIfEmpty()

                    join MT in context.MatchTeams on T.MatchTeamID equals MT.MatchTeamID into T_mt

                    from MT in T_mt.DefaultIfEmpty()

                    join G in context.VQGames on P.VQGameID equals G.VQGameID into T_g

                    from G in T_g.DefaultIfEmpty()

                    join Te in context.Teams on MT.TeamID equals Te.TeamID into T_te

                    from Te in T_te.DefaultIfEmpty()

                    join U in context.Users on P.UserID equals U.UserID into T_u

                    from U in T_u.DefaultIfEmpty()

                    join Mate in context.Matches on MT.MatchID equals Mate.MatchID into T_Mate

                    from Mate in T_Mate.DefaultIfEmpty()

                    join R in context.Rounds on Mate.RoundID equals R.RoundID into T_r

                    from R in T_r.DefaultIfEmpty()

                    where (G.VQGameID == vqGameID && R.RoundID==roundID

                    orderby P.VQPlayerID

                    select new { User = U.UserName, MatchID = Mate.MatchID == null ? "" : Mate.MatchID.ToString(), ChosenTeam = Te.TeamName == null ? "(NONE)" : Te.TeamName, };

                dgvTippings.DataSource = lines;

                dgvTippings.Columns[0].HeaderText = "User Name";

                dgvTippings.Columns[1].HeaderText = "Match ID";

                dgvTippings.Columns[2].HeaderText = "Chosen Team";

            }

Change the query string values in C#

// reflect to readonly property

PropertyInfo isreadonly = typeof(System.Collections.Specialized.NameValueCollection).GetProperty("IsReadOnly", BindingFlags.Instance | BindingFlags.NonPublic);

// make collection editable

isreadonly.SetValue(this.Request.QueryString, false, null);

this.Request.QueryString.Remove("playermode");

this.Request.QueryString.Add("playermode", "editinitialselection");

// make collection readonly again
isreadonly.SetValue(this.Request.QueryString, true, null);