Difference between Target Audience and Attendees in SharePoint

Difference between Target Audience and Attendees in SharePoint
Target audience

  Target audience is a group of people.

             In Target audience we can display content such as list or library items and entire web parts to a group of people. If you want to present information to particular group of people.

Attendees

  Attendees are individual users.

Example:
  • "Target Audience" means to whom a particular event is scheduled.
  • "Attendees" means people who need to attend the event.
  •  "Target Audience" may be 100 but it is not that all 100 need to attend the meeting out of hundred there may be 75 who has to attend the meeting.

How to create Calculated Fields in SharePoint List

Calculated Field

                   Using calculated columns we can automatically generating data, adding days to a date column to calculate an expired or due date column, Number or Currency columns to get a total…


        In list, I want to create field “SP2013”, in 2013 I want to show year (yyyy). Now we are going to create calculated field for SP2013.  Navigate to list settings in any custom list, click on create column. Type your Column Name “Year” and select “Calculated” column and type  formula  “"SP"& (TEXT([Created],”yyyy”))” as shown in fig below.



Some Date and Time Formulas


"SP"& (TEXT([Created],”mmmm dd, yyyy”))                                                      October 17,2012


"SP"& (TEXT([Created],”yy”))                                                                                     SP13


"SP"& (TEXT([DateTimeField],”hh:mm:ss”))                                                           SP12:00:05


"SP"& (TEXT([Created],”dddd”))                                                                               SPWednesday


"SP"& (TEXT([Created],”mmmm”))                                                                              SPOctober

In my Article we can check to create Calculated Fields in SharePoint List Schema.

insert data using stored procedure in c#

insert data using stored procedure in c#
In this article i wll explain how to  insert data using stored procedure in c#.

 I am creating a table in sqlsever.
USE [dotnetdb]
GO

/****** Object:  Table [dbo].[Employee]    Script Date: 12/25/2013 14:25:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Employee](
      [EmpId] [nvarchar](50) NOT NULL,
      [EmpName] [nvarchar](50) NOT NULL,
      [EmpAddress] [nvarchar](50) NOT NULL,
      [EmpDesignation] [nvarchar](50) NULL
) ON [PRIMARY]

GO

For this table  I am creating a Stored procedure as shown.

USE [dotnetdb]
GO

/****** Object:  StoredProcedure [dbo].[SP_InsertEmpinfo]    Script Date: 12/25/2013 14:27:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create procedure [dbo].[SP_InsertEmpinfo]
(
@EmpId nvarchar(50),
@EmpName nvarchar(50),
@EmpAddress nvarchar(50),
@EmpDesignation nvarchar(50)
)

As Begin

Insert into Employee (EmpId,EmpName,EmpAddress,EmpDesignation) values (@EmpId,@EmpName,@EmpAddress,@EmpDesignation)
end

GO


Now I am designing UI.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="AspExample.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <div>
    <label>EmpId</label>
    <asp:TextBox ID ="txtempid" runat ="server"></asp:TextBox>
    </div>
    <div>
    <label>EmpName</label>
    <asp:TextBox ID ="txtempname" runat ="server"></asp:TextBox>
   
    </div>
    <div>
    <label>EmpAddress</label>
    <asp:TextBox ID ="txtempaddress" runat ="server"></asp:TextBox>
   
    </div>
    <div>
    <label>EmpDesignation</label>
    <asp:DropDownList ID ="ddlempdes" runat = "server">
    <asp:ListItem>Select</asp:ListItem>
    <asp:ListItem>SE</asp:ListItem>
    <asp:ListItem>TL</asp:ListItem>
    <asp:ListItem>PL</asp:ListItem>
    </asp:DropDownList>
   
    </div>
    <div>
    <asp:Button ID ="btnsubmit" Text ="Submit" runat ="server"
            onclick="btnsubmit_Click" />
    </div>
    </div>
    </form>
</body>
</html>

In code behind I am implementing the logic as shown below.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace AspExample
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection("Data Source=Chinnu;Database=dotnetdb;User Id=sa;Password=password123;");
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void btnsubmit_Click(object sender, EventArgs e)
        {
            SqlCommand cmd = new SqlCommand("SP_InsertEmpinfo", con);
         cmd.CommandType = CommandType.StoredProcedure;

         cmd.Parameters.Add("@EmpId", SqlDbType.NVarChar).Value = txtempid.Text;
         cmd.Parameters.Add("@EmpName", SqlDbType.NVarChar).Value = txtempname.Text;
         cmd.Parameters.Add("@EmpAddress", SqlDbType.NVarChar).Value = txtempaddress.Text;
         cmd.Parameters.Add("@EmpDesignation", SqlDbType.NVarChar).Value = ddlempdes.SelectedValue;
         con.Open();

         cmd.ExecuteNonQuery();

         con.Close();  

        }
    }
}

In web.config give the database connection.

<connectionStrings>
    <add name="Connstring" connectionString="Data Source=DotNetSharePoint;Database=Chinnu;User Id=sa;Password=Password123;" providerName="System.Data.SqlClient" />
  </connectionStrings>






PowerShell Scripts in SharePoint

PowerShell Scripts in SharePoint

What is PowerShell?

It is a Extendable and scripting language can be used to manage and administer server environments in SharePoint. Using Poweshell we can do tasks easier.

Some PowerShell Scripts in SharePoint.


How to remove SPWebApplication using powershell script in SharePoint 2013


How to get a list of site collection with template for a web application



How to get a list of site collections without template names for a web application



How to get a list of site collections without template names for a web application 



Approve masterpage using PowerShell in SharePoint



How to Export particular Group in Term Store Management in SharePoint 2013 



How to import group to Term Store Management using PowerShell Script in SharePoint 2103



How to create Lookup Field List using Powershell Script in SharePoint 2013 



How to create List using Powershell Script in SharePoint 2013 



How to Remove particular zone



How to Remove Application Pool in SharePoint using power shell



How to deploy wsp in sharepoint 2013 using powershell



Delete App pool in Sharepoint Using PowerShell


How to send email using PowerShell in SharePoint



How to send email with attachment in powershell



How to connect sqlserver using powershell


Activating and Deactivating Features in a SharePoint Site Collection Using Power Shell


How to Create a Site Collection using Power Shell


How to delete list items using Power Shell


How to configure SharePoint Outgoing Email Settings using powershell


How to download WSP file Central Admin using PowerShell


How to download all WSP files from Central Admin using PowerShell


Copy Files between SharePoint Document Libraries Using Power Shell


How to create managed path in SharePoint using PowerShell   





What is the difference between Office 365 and Windows Azure?

What is the difference between Office 365 and Windows Azure?

     Before that we have know about few points.

What is Cloud?
Whatever we develop the application through the internet is called cloud.

What is Cloud Computing?
The term Cloud Computing and working in cloud refer to performing computer tasks using services delivered entirely over the Internet.
Services provided over the cloud computing
SAAS: Software Application As a service.
IAAS: Infrastructure As a service.
PAAS: Platform As a service.

Difference between office 365 and windows azure.

Office 365: Is a SAAS Software Application As a service. Which provides online versions of office suites includes Outlook, PowerPoint, word, Excel, Lync and OneNote

SAAS: Software Application As a service.
Software as a service is a way of delivering application over the internet as a service.Insted of installing and maintaining software you can simply access it via the internet. It manages access to the application including security, availability and performance, sometimes we can also call web based software.


Windows azure: IAAS and PAAS
IAAS: Infrastructure as a Service is the virtual delivery of computing resources in the form of hardware, networking and storage services. It is also refereed some times as Hardware as a service

PAAS: Plat form as a service A software distributed model in which hosted application are made available to customers over the internet. In PAAS services having Application services, Operations services, Platform services.

How to get a list of site collection for a web application using PowerShell Script

How to get a list of site collection for a web application using PowerShell Script
How to get a list of site collection with template for a web application

       The following PowerShell  script can be used to get a list of site collections with template for a web application.

Get-SPSite -WebApplication http://c4968397007/-Limit All |
Select -ExpandProperty AllWebs |
ft url, Title,WebTemplate, Created -auto |
out-string -width 1024 > c:\sites\sitetemplate.txt

How to get a list of site collections without template names for a web application

     This script will get only list of site collections without template names for a web application.

function GenerateAllSitecollections ($url)
{
    try
      {
         $Site=Get-SPSite $url        
         $spWebApp = $Site.WebApplication
         $TotalList = @()
          write-host "Below is the list of all site collections for a web application" + $spWebApp + "….." -foregroundcolor red
         foreach($allsites in $spWebApp.Sites)
         {
           $list =  $allsites.url
                   $listtemplatename = $allsites.WebTemplate
           write-host $list –foregroundcolor  blue   
                   write-host $listtemplatename -foregroundcolor blue  
         }                      
      }
   catch
      {
          write-host "Unable to Extract Site collection List in web application" -foregroundcolor red
          break
      }
} 

GenerateAllSitecollections  -Url " http://c4968397007/" > c:\sites\sitecollections.txt

Approve masterpage using PowerShell in SharePoint

Approve masterpage using PowerShell  in SharePoint
           I have a problem with my custom masterpage approve, i have edited my masterpage, save the page and check-in the masterpage but i con't able to approvel the masterpage. To solve this issue i use one PowerShell Script.

 The following PowerShell Script will help you to approve the masterpage in SharePoint.

$SPWeb = Get-SPWeb "http://localhost/site/mysite"
$file = $SPWeb.GetFile("_catalogs/masterpage/v4_my.master")
$file.CheckIn("")
$file.Publish()

insert data into SharePoint list using c#.

insert data into SharePoint list using c#.
In this Article I will explain how to insert data into SharePoint list using C#.
I am designing a UI with all the fields in Button Click I am writing this logic.

ClientInformation is my list name,Is already created in SharePoint Site.
Once we deploy we can able to insert this data in to list.

protected void btnsubmit_Click1(object sender, EventArgs e)
{
SPSite site = SPContext.Current.Site;
SPWeb web = site.OpenWeb();
SPList list = web.Lists["ClientInformation"];
SPListItem listitem = list.Items.Add();
listitem["ClientName"] = txtclientname.Text;
listitem["ClientLocation"] = txtclientlocation.Text;
listitem["Address"] = txtclientaddress.Text;
listitem["ContactPerson"] = txtcontactperson.Text;
listitem["Email"] = txtEmailId.Text;
listitem.Update();


}

SharePoint 2013 list Error "The server was unable to save the form at this time. please try again."


  While working with simple custom list,we tried to  add the data in to the list,suddenly we  got an error saying that "The server was unable to save the form at this time. please try again." as shown in fig below.



To solve this issue we have to restart "SharePoint Search Host Controller",  its working now. I was able to add items in list.


 For reference check the following links.                                                                  
                                                            
http://sharepointerthilosh.blogspot.in/2013/03/the-server-was-unable-to-save-form-at.html
http://onceinawhilescribble.blogspot.in/2013/09/when-creating-folder-in-library-server.html
     




     

how to create custom master page in sharepoint 2010 using visual studio

how to create custom master page in sharepoint 2010 using visual studio

In this Article I will explain how to create and deploy master page using visual studio 2010.
I am created an Empty solution with name MasterPageTest as shown Below.
 Now right click on the solution add new item Module as shown below

 Now we can able to see the txt file
              Now I am rename sample.txt as SampleMaster.Master.
              After completing these steps.
              Go to site setting->MasterPage->

             Select the V4 master page Download a copy in to your system.
            Copy that code and paste in to SampleMaster.Master.
             In Element.xml we have to modify the code like this

<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
<Module Name="TestExample" Url="_catalogs/masterpage">
<File Path="TestExample\SampleMaster.Master" Type="GhostableInLibrary" Url="TestExample/SampleMaster.Master" IgnoreIfAlreadyExists="TRUE" />
</Module>
</Elements>
          I am adding the H1 tag DotNet SharePoint Site in my Master Page.

           Deploy the Solution,After Deploying Successfully.

            Go to site setting → Galleries->
                                         
                     We can able to see the Module name with Pending Status  

                  Click on that Module name select Approved option Click ok  

      We have active two features,One is in Site Setting->Site Collection administration ->Site         Collection features.
                             

     In Site Actions->Manage Site Features.

                                                                        

  
         After Activating go to Look and Feel ->MasterPage
        Select our master we deployed from VS2010  
                             
        After Selecting master page at site master page and system master page Click ok .

       Finally we can able to see my master page .











How to get image names inside a folder and move names to text file in c#

How to get  image names inside a folder and move names to text file in c#
       In this article i am going to explain how to get image names inside a folder and move names to text file in c#.
             I am having 2000 images(.jpg) in image folder and want to get all the image names, that stores in one text file. The following code will help you to get all image names which stores in one text file.


string[] array1 = Directory.GetFiles(@"C:\Images\", "*.jpg");
            Console.WriteLine(array1.Count().ToString());
            int count = 1;
            using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"C:\Imgs.txt"))
            {
                foreach (string name in array1)
                {
                    string[] spltname = name.Split('\\');

                    Console.WriteLine(spltname[spltname.Length-1]);
                    file.WriteLine(count.ToString()+","+spltname[spltname.Length - 1]);
                    count++;
                }
            }