Query SharePoint List - SPQuery vs SPSiteDataQuery vs CrossListQueryInfo

There are three different classes you can use to query SharePoint list:-

1.       SPQuery

Used for query a data from a specific list and also used for join two lists.

Use full Links:-

·         http://sharepointfordeveloper.blogspot.in/2011/10/step-by-step-spquery-list-joins.html#!/2011/10/step-by-step-spquery-list-joins.html

·         http://mysharepointwork.blogspot.in/2010/04/spquery-examples.html

2.       SPSiteDataQuery

Adding webpart Propert using editor part and fetching list item title with styling

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.WebControls;

using Microsoft.SharePoint;

using ZS.CodeChallenge.V1.common;

using System.Web;

using Microsoft.SharePoint.WebPartPages;

Catching and logging error in Custom code(ULS logging)

using System;

using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint.Administration;

 namespace CommonCode

{
    public class ULSLogging : SPDiagnosticsServiceBase

    {

        public static string DiagnosticAreaName = "CodeChallege LOG";

        private static ULSLogging _Current;

        public static ULSLogging Current

        {

       

log off other user from server

1. First open Command prompt as Administrator.
2. Type command >QUSER(this will give you Session Id of all logged In Users)
3. Type command>Logoff {Sessoin ID} (It will log off user from server)

Read SecureString from user in Powershell

$aa=Read-Host "enter:" -AsSecureString


Example from powershell:-

PS C:\Users\username> $aa=Read-Host "enter:" -AsSecureString
enter:: ***

Changing application pool identity in SharePoint 2010

Changing application pool id in IIS is not at all recommended way of changing App pool identity in SharePoint 2010.

If you directly change App Pool Identity in IIS, SharePoint will not understand it and will be still referring to older ID.

To change the identity for an application pool, log into Central Administration and follow these steps:

1.      Go to Security and under General Security, click Configure Service Accounts.

2.      Select the application pool from the components drop-down

3.      Select the managed account that you want to use as the identity for this application pool, or register a new managed account in SharePoint 2010, using the Register a new managed account link.

4.      Click the OK button.

5.      You’ll be warned that this action requires an IIS reset on all servers, click OK.

6.      Perform iisreset /noforce on all WFE servers in the farm.

Microsoft Certified Technology Specialist in SharePoint Application Development : 070-573

Hey All...

This is my first post for the year 2013 and likes to share the experience about clearing 70-573 today.
It was very good learning experiences to prepare and get certified in exam. I explored many different things in SharePoint and learnt standard practices for SharePoint. Take this exam as a detailed learning step in SharePoint.

Find below details of exam:-
Total Questions asked :  44
Total marks for exam : 1000
Passing Score: 700
Total time: 90 mins
Fees : Rs. 4520/-(80$)
Language: C# and VB (need to be selected before staring the exam)



Few Links which I would like to share which can be used for preparing 70-573 certification:

http://blog.beckybertram.com/Lists/Posts/Post.aspx?ID=91
http://spmatt.wordpress.com/2011/12/08/how-i-passed-70-576/
http://spmatt.wordpress.com/2012/03/28/how-i-passed-70-573/
http://blog.beckybertram.com/Lists/Exam%2070573%20Study%20Guide/AllItems.aspx


Video:-
http://www.youtube.com/watch?v=fEtOf7Hq4yw
http://www.youtube.com/watch?v=RI9PIFI5ypM
http://www.youtube.com/watch?v=G9yuGQN8LZ0


Love SharePoint….