About Me

My photo
a Dynamic and Energetic guy.....

Tuesday, April 18, 2017


Yammer and SLACK are two different technologies that we use for communication within ORGANIZATION / COMMIUNITY. Though Yammer is OLDER than Slack, we can see many similarities between these 2 products.
In simple terms “Yammer is “the enterprise social network”, and Slack is “a messaging app for teams”.
First we can identify similarities,
1)     Private message between members of the company
2)     Can create sub communities (GROUPS in YAMMER / CHANNELS in SLACK)
3)     Can share images/ videos
4)     Can join new groups / can lock
5)     Can integrate with other APIs
6)     Mobile APPS available
Yammer is,
1)     Enterprise Social Network
2)     Facebook for your company
3)     Can share posts
4)     Can follow / LIKE
5)     Can start conversations
6)     Consume information @ leisure
7)     Can use non-essential information, with interest
8)     Always having suggestions
9)     Suited for higher number of employees

1)     Made for messaging only
2)     Get direct attention to message
3)     Messages creating under one section (Topic)
4)     Alerting immediately
5)     Essential information only
6)     Powerful SEARCH includes messages / conversations / content of documents
7)     Suited fro SMS

We have to decide the exact requirement and choose the correct technology.

Tuesday, January 31, 2017

Retrieving SPList Data From SharePoint Online Site using CSOM

using Microsoft.SharePoint.Client;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Security;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace SPOnlineDataAccess
    public partial class Form1 : System.Windows.Forms.Form
        public Form1()

        private void LoadDefaultValues()
            txtSiteUrl.Text = "https://abc.sharepoint.com/sites/testsite";
            txtListName.Text = "OnlineList";
            txtUserEmail.Text = "user1@xyz.com";
            txtPassword.Text = "pass@123qaz";

        private void btnLoad_Click(object sender, EventArgs e)
            DataTable dtResults = ReadSPList();
            dataGridView1.DataSource = dtResults;

        private DataTable ReadSPList()
            using (ClientContext clientContext = GetContextObject())
                    DataTable dtListData = new DataTable();
                    //Creating DataTable Columns
                    dtListData.Columns.Add("Title", typeof(String));
                    dtListData.Columns.Add("Designation", typeof(String));
                    dtListData.Columns.Add("EmpID", typeof(String));

                    //Getting Data From SharePoint
                    Web web = clientContext.Web;
                    clientContext.Load(web, website => website.ServerRelativeUrl);

                    //Read SPList called "OnlineList"
                    List myList = web.Lists.GetByTitle(txtListName.Text);

                    // This creates a CamlQuery that has a RowLimit of 1000, and also specifies Scope="RecursiveAll"
                    // so that it grabs all list items, regardless of the folder they are in.
                    CamlQuery query = CamlQuery.CreateAllItemsQuery(1000);
                    ListItemCollection items = myList.GetItems(query);

                    // Retrieve all items in the ListItemCollection from List.GetItems(Query).

                    for (int count = 0; count < items.Count; count++)
                        DataRow dr = dtListData.NewRow();
                        dr["Title"] = items[count]["Title"].ToString();
                        dr["Designation"] = items[count]["Designation"].ToString();
                        dr["EmpID"] = items[count]["EmpID"].ToString();

                    return dtListData;
                catch (Exception ex)
                    return null;

        private ClientContext GetContextObject()
            string siteUrl = txtSiteUrl.Text;
            string userName = txtUserEmail.Text;
            string password = txtPassword.Text;
            SecureString _password = GetPasswordFromInput(password);

            ClientContext context = new ClientContext(siteUrl);
            context.Credentials = new SharePointOnlineCredentials(userName, _password);
            return context;

        private void Form1_Load(object sender, EventArgs e)

        private SecureString GetPasswordFromInput(string password)
            //Get the user's password as a SecureString
            SecureString securePassword = new SecureString();
            char[] arrPassword = password.ToCharArray();
            foreach (char c in arrPassword)

            return securePassword;


My Masters