Tuesday, December 18, 2012

Attach and Detach SQL server database 2005 to 2008 R2

It is going on

Thursday, November 1, 2012

Opening WebPart Maintenance Page

Shortcut to open Instead of going to the Edit Properties form of the page, we can easily open the WebPart Maitenance page by just adding the following query string to the page URL
?contents=1
So, if your page URL is 'http://kar/pages/default.aspx' then after appending the query string it should look like ' http://rams/pages/default.aspx?contents=1'

Using this approach, we can open the webpart maintenance page for all the forms pages (like /pages/forms/allitems.aspx?contents=1).

But its not safe to remove or add any webparts in these pages, as they may effect the normal funcitonality.

This approach works on both MOSS 2007 and SPS 2010.

Tuesday, October 30, 2012

Copy from One database table data to anoother database table data MS SQL Query

insert into StarDB.dbo.Associate1 select * from StarDB_Production.dbo.Associate1

Wednesday, October 24, 2012

ASP.Net Tab Container Control

Wednesday, September 12, 2012

How to find the Infopath user's available in that group via Dataconnection

It is Process

Query for SQL 2008

It is Process

How to set email or name in the Sharepoint List of the People or Group field

It is Process....

Tuesday, August 7, 2012

How to load sharepoint List data values in to the User control Dropdown box via Sharepoint Object Model

Sharepoint Object Mode

How to retrieve People Picker AD id and Display name to store in the SQlL Server Databases

Wednesday, July 18, 2012

Convert Infopath Default date to DD-MM-YYYY HH:MM:SS

You can display custom infopath Date Time from Infopath Default date Time.

The IP Fx formula is:

concat(substring(TestDate, 9, 2), "-", substring(TestDate, 6, 2), "-", substring(TestDate, 1, 4), " ", substring(TestDate, 12, 8))

Friday, June 29, 2012

MS SQL Server Connection String

SQl Server Connection String

Sharepoint Event receiver for SP List

Sharepoint Event Viewer and Receiver

Friday, May 25, 2012

Sharepoint 2007 Timer Job Development and Deployment Steps

Sharepoint Timer 2007

Sharepoint 2007 Timer Job

Create Timer job solution File.

1.Create C# project Library
2.Create Timer.CS, TimerInstaller.CS, Feature.xml, manifest.xml files
3.Copy existing code and past it in the proper files
4.Set strong name
5.Build DLL
6.Copy DLL id in the feature file
7.Build WSP and following deploying procedures.

Deployment Timer Jobs:

1. C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES 1.1 Create a folder " KarNet.TimerJob " 1.2 Copy the files "Feature.xml" & "Manifest.xml"
2. Run the install.bat file to deploy the Solution file. 2.2 before that edit the file to point to correct SharePoint site, by changing the "TargetUrl".
2.3 stsadm -o installfeature -name KarNet.TimerJob -force
3. Copy the KarNet.TimerJob.DLL to GAC.
4. Activate the Site Collection feature to enable the custom Timer
5. Restart the Timer Service in services.
6. Create a Folder in C:\ as "KarNetLog"
7. Share the folder and allow "everyone" full access.

Activate Feature manually

C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o deactivatefeature -name KarNet.TimerJob -url "http://KarNet-46b4a490b"
C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o uninstallfeature -name "KarNet.TimerJob"
C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o installfeature -name KarNet.TimerJob -force
C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o activatefeature -name "KarNet.TimerJob" -url "http://KarNet-46b4a490b
"

Timer .cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;
using System.Diagnostics;
using Microsoft.SharePoint.Workflow;
using System.IO;
using Microsoft.SharePoint.Utilities;
using System.Collections.Specialized;

using System.Text.RegularExpressions;

namespace HRction.TimerJob
{
    public class Timer : SPJobDefinition
    {
        public Timer()
            : base() { }

[Persisted]
        private string siteToPerformJob;

public Timer(string jobName, SPService service, SPServer server, SPJobLockType targetType)
            : base(jobName, service, server, targetType)
        {
        }

public Timer(string jobName, SPWebApplication webApplication, SPSite site)
            : base(jobName, webApplication, null, SPJobLockType.Job)
        {
            this.Title = "HR.TimerJob";
            this.siteToPerformJob = site.Url;
        }

public override void Execute(Guid contentDbId)
        {
            try
            {

//System.Diagnostics.Debugger.Break();

//System.Diagnostics.Debug.Assert(false);
                //System.Diagnostics.Debug.WriteLine(SPContext.Current.Site.WebApplication.Name);

// get a reference to the current site collection's content database
                SPWebApplication webApplication = this.Parent as SPWebApplication;
                //LogMessage("Welcome " + webApplication.Name, EventLogEntryType.Information);
                //SPContentDatabase contentDb = webApplication.ContentDatabases[contentDbId];

//SPList taskList = contentDb.Sites["FEDemo"].RootWeb.Lists["Tasks"];

// create a new task, set the Title to the current day/time, and update the item
                //SPListItem newTask = taskList.Items.Add();
                //newTask["Title"] = DateTime.Now.ToString();
                //newTask.Update();

//int ID = 0;

DateTime ActionDate;

string IsError = "";
                string strWFStatus = "";

string strActionDate = "";

string strItemID = "";
                string strDivAction = "";
                string strAction = "";                
                string strWfStarted = "";

string siteURL = "";

string CC = "";
                string Body = "";
                string TO = "";

string HRction_Mail_Group = "";
                string GetHRctionEmail = "";

StringDictionary headers = new StringDictionary();
                headers.Add("content-type", "text/html");

if (this.siteToPerformJob != null)
                {
                    ////siteURL = this.siteToPerformJob + "/wss"; //need to enable for client deployment
                    siteURL = this.siteToPerformJob + "/"; //need to enable for client deployment
                    using (SPSite currentSite = new SPSite(siteURL))
                    {
                        //LogMessage("SPSite - " + currentSite.Url, EventLogEntryType.Information);
                        currentSite.AllowUnsafeUpdates = true;
                        currentSite.CatchAccessDeniedException = false;
                        using (SPWeb AnetWeb = currentSite.OpenWeb())
                        {
                            AnetWeb.AllowUnsafeUpdates = true;
                            //LogMessage("AnetWeb - " + AnetWeb.Url, EventLogEntryType.Information);
                            ////SPList BGOperatorReminder = AnetWeb.Lists["BGOperatorReminder"];
                            SPList ActionList = AnetWeb.Lists["HRList"]; //- for Production

foreach (SPListItem item in ActionList.Items)
                            {

strItemID = item["ID"].ToString();
                                LogMessage("Item ID " + item["ID"].ToString(), EventLogEntryType.Information);
                                strActionDate = item["ReminderDate"].ToString().Replace("datetime;#", ""); // For Production
                                ////LogMessage("strActionDate " + strActionDate, EventLogEntryType.Information);
                                ActionDate = Convert.ToDateTime(strActionDate, System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat);
                                //LogMessage("ActionDate " + ActionDate.ToString(), EventLogEntryType.Information);
                                LogMessage("Reminder Date " + ActionDate.AddDays(-1).Date, EventLogEntryType.Information);
                                
                                strDivAction = item["Action"].ToString();
                                ////LogMessage("strDivAction " + strDivAction, EventLogEntryType.Information);
                                strAction = Regex.Replace(strDivAction, "<[^>]*>", string.Empty);

strWFStatus = item["WFStatus"].ToString();
                                strWfStarted = item["WFStarted"].ToString();
                                //LogMessage("strAction " + strAction, EventLogEntryType.Information);
                                //LogMessage("Reminder " + item["Reminder"], EventLogEntryType.Information);
                                //LogMessage("Added By " + item["AddedBy"], EventLogEntryType.Information);
                                //LogMessage("WF Status " + item["WFStatus"], EventLogEntryType.Information);
                                //LogMessage("WFStarted " + item["WFStarted"], EventLogEntryType.Information);

if (item["Reminder"].ToString() == "True")
                                {
                                    if (ActionDate.AddDays(-1).Date == DateTime.Today.Date && item["WFStatus"].ToString() == "Pending") // for Production  (&& InFavourOf != "The Controller of Immigration")
                                    {
                                        if (item["WFStarted"].ToString() == "No")
                                        {

using (SPSite site = new SPSite(siteURL))
                                            {
                                                using (SPWeb web = site.OpenWeb())
                                                {

SPGroup gp = web.Groups["HRAction"];
                                                    if (gp != null)
                                                    {
                                                        foreach (SPUser usr in gp.Users)
                                                        {
                                                            if (usr.Name != "System Account")
                                                            {
                                                                if (HRAction_Mail_Group == "")
                                                                    HRAction_Mail_Group += usr.Name;
                                                                else
                                                                    HRAction_Mail_Group += ", " + usr.Name;

if (GetHRActionEmail == "")
                                                                    GetHRActionEmail += usr.Email;
                                                                else
                                                                    GetHRCActionEmail += "," + usr.Email;
                                                            }
                                                        }
                                                    }

}
                                            }

TO = GetHRActionEmail;
                                            if (TO.Length > 0)
                                            {

headers.Add("from", item["FromEmail"].ToString());
                                                
                                                Body = Body + "<table dir='ltr' cellspacing='0' designtimesp=23183> <tr designtimesp=23184><td designtimesp=23185> </td></tr>";
                                                                                                Body = Body + "<tr designtimesp=23186><td designtimesp=23187> The HR Competitor Action status as follows:</td></tr>";
                                                Body = Body + "<tr designtimesp=23188><td designtimesp=23189> </td></tr><tr designtimesp=23190><td designtimesp=23191> </td></tr>";
                                                Body = Body + "<table  dir='ltr' cellspacing='1' cellspacing='1' border='1' designtimesp=23192><tr designtimesp=23193><th designtimesp=23194> Name</th><th designtimesp=23195> Name</th><th designtimesp=23196> Name </th><th designtimesp=23197>Action</th></tr>";
                                                Body = Body + "<tr designtimesp=23198><td designtimesp=23199><p align='Center' designtimesp=23200>" + item["PropertyName"].ToString() + "</p></td><td designtimesp=23201><p align='Center' designtimesp=23202>" + item["Name"].ToString() + "</p></td><td designtimesp=23203><p align='Center' designtimesp=23204>" + item["AssociateName"].ToString() + "</p></td><td designtimesp=23205><p align='Center' designtimesp=23206>" + strAction + "</p></td></tr></table></td></tr>";
                                                Body = Body + "<tr designtimesp=23207><td designtimesp=23208> </td></tr>";
                                                Body = Body + "<tr designtimesp=23209><td designtimesp=23210> </td></tr><tr designtimesp=23211><td designtimesp=23212> </td></tr><tr designtimesp=23213><td designtimesp=23214>Best regards,</td></tr><tr designtimesp=23215><td designtimesp=23216> Admin Team</td></tr></table>";

//headers.Add("cc", CC);
                                                headers.Add("to", item["ToEmail"].ToString());
                                                headers.Add("subject", "HR Status  : " + item["AssociateName"].ToString());

SPUtility.SendEmail(AnetWeb, headers, Body);

headers.Clear();

item["WFStatus"] = "Completed";
                                                item["WFStarted"] = "Yes";
                                                item.SystemUpdate();

CC = "";
                                                Body = "";
                                                TO = "";

HRAction_Mail_Group = "";
                                                GetHRActionEmail = "";

}

}
                            // INITIEAL FOR LOOP CLOSED

}
                        // SP WEB IF LOOP CLOSED

// item.SystemUpdate();

/// # endregion

}
                    // SP SITE URL LOOP CLOSED

}

// SP TIMER JOB IF LOOP CLOSED

//LogMessage("Updated", EventLogEntryType.Information);
            }

// TRY LOOP CLOSED

catch (Exception ex)
            {
                LogMessage(" Error " + ex.Message + " Trace " + ex.StackTrace, EventLogEntryType.Error);
            }
        }

// EXCECUTE DB ID LOOP CLOSED

protected static string StartWorkflow(SPListItem wfListItem, string workflowName, string SiteURL)
        {
            SPWorkflowAssociationCollection wfAssocs = wfListItem.ParentList.WorkflowAssociations;
            SPWorkflowAssociation activeWorkflowAssoc = null;
            string errorMessage = string.Empty;

foreach (SPWorkflowAssociation wfAssoc in wfAssocs)
            {
                if (wfAssoc.Name.Equals(workflowName))
                {
                    activeWorkflowAssoc = wfAssoc;
                    break;
                }
            }

// if the workflow exists, start the workflow 
            SPWorkflow activeWorkflow = null;
            if (activeWorkflowAssoc != null)
            {
                try
                {
                    using (SPSite currentSite = new SPSite(SiteURL))
                    {
                        activeWorkflow = currentSite.WorkflowManager.StartWorkflow(
                        wfListItem,
                        activeWorkflowAssoc,
                        "<Data DESIGNTIMESP=23217></Data>");
                    }
                }
                catch (Exception ex)
                {
                    errorMessage = "error " + ex.Message;
                }
            }
            else
            {
                errorMessage = "error No WF Found";
            }
            return errorMessage;
        }

//kcline
        private static void Log(String logMessage, string LogType, TextWriter w)
        {
            w.Write("\r\nLog Type :{0} ", LogType);
            w.WriteLine("\r\n{0} {1}", DateTime.Now.ToLongTimeString(),
                DateTime.Now.ToLongDateString());
            //w.WriteLine("  :");
            w.WriteLine("   - {0}", logMessage);
            w.WriteLine("-------------------------------");
            // Update the underlying file.
            w.Flush();
        }

//kcline
        private void LogMessage(string message, EventLogEntryType type)
        {
            string FilePath = "C:\\HR Log"; //SPDiagnosticsService.Local.LogLocation.ToString();
            string FileName = "";
            bool EndSlash = false;
            if (FilePath.EndsWith("\\"))
                EndSlash = true;

if (Directory.Exists(FilePath))
            {
                if (EndSlash == false)
                    FileName = FilePath + "\\" + " HR-Timer.log";
                else
                    FileName = FilePath + "HR-Timer.log";

string LogType = "";
                using (StreamWriter w = File.AppendText(FileName))
                {
                    LogType = type.ToString();
                    Log(message, LogType, w);
                    //ka line// Close the writer and underlying file.
                    w.Close();
                }
            }
        }

}
}

TimerInstaller.cs

using System;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

namespace HRction.TimerJob
{
    class TimerInstaller : SPFeatureReceiver
    {
        const string JOB_NAME = "HRAction.Timer";

/// <summary>
        /// Occurs after a Feature is installed.
        /// </summary>
        /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param>
        public override void FeatureInstalled(SPFeatureReceiverProperties properties)
        {
        }

/// <summary>
        /// Occurs when a Feature is uninstalled.
        /// </summary>
        /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param>
        public override void FeatureUninstalling(SPFeatureReceiverProperties properties)
        {
        }

/// <summary>
        /// Occurs after a Feature is activated.
        /// </summary>
        /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param>
        public override void FeatureActivated(SPFeatureReceiverProperties properties)
        {
            // register the the current web
            SPSite site = properties.Feature.Parent as SPSite;

// make sure the job isn't already registered
            foreach (SPJobDefinition job in site.WebApplication.JobDefinitions)
            {
                if (job.Name == JOB_NAME)
                    job.Delete();
            }

// install the job
            Timer AnetTimerFBG = new Timer(JOB_NAME, site.WebApplication, site);

SPMinuteSchedule schedule = new SPMinuteSchedule();
            schedule.BeginSecond = 0;
            schedule.EndSecond = 59;
            schedule.Interval = 5;
            AnetTimerFBG.Schedule = schedule;

//schedule.BeginHour = 12;
            //schedule.BeginMinute = 30;
            //AnetTimerFBG.Schedule = schedule;
            //AnetTimerFBG.Update();

AnetTimerFBG.Update();
        }

/// <summary>
        /// Occurs when a Feature is deactivated.
        /// </summary>
        /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param>
        public override void FeatureDeactivating(SPFeatureReceiverProperties properties)
        {
            SPSite site = properties.Feature.Parent as SPSite;

// delete the job
            foreach (SPJobDefinition job in site.WebApplication.JobDefinitions)
            {
                if (job.Name == JOB_NAME)
                    job.Delete();
            }
        }
    }
}

Feature.xml

manifest.xml

ASP.Net Server side POP UP message box displayed

The below code is working in the server side of the ASP.Net code, You have to modify only the panel name based on you form
System.Web.UI.ScriptManager.RegisterClientScriptBlock(panel1, Page.GetType(), "strscript", "alert('Record Successfully Updated.')", true);

Saturday, March 31, 2012

Error: InfoPath cannot load the view... unsupported HTML such as framesThe following HTML tag is not supported:'comment'

It may have a corrupted form.

Infopath forms (in 2007 anyway) are actually just Microsoft CAB files. Youcan rename a form from .xsn to .cab and then open it using any aplicationthat understands cab files.

There are a number of files in each CAB file, but the ones you areinterested in are probably the *.XSL (there is one for each InfoPath "View"plus some extras) and the manifest.xsf file which is like the "table ofcontents".WARNING!!! DANGER WILL ROBINSON!!! etc etcThis isn't for the faint-of-heart, but you did say you were desperate...
You may have to run through a combination of:

1. Renaming the .XSN to .CAB
2. Expanding the .CAB file
3. Hacking either the individual xsl views and/or the manifest.xsf to removethe offending view(s)
4. Repacking the CAB file
5. Renaming back to .XSN
6. Open in Infopath, hope error is gone

This has only happened to me once - I ended up having to delete theoffending view and recreate it. To find out which view was broken, I had todelete each view, reopen, repeat until I found out which of the views wasbroken. Worked for me (we had about 30 very complex views) and saved a wholelot of time.

Repacking the extracted files of infopath back to .xsn

Right-click on the manifest.xsf, select Design, save as xsn.

Wednesday, February 29, 2012

Populate Dynamic Dropdown values based on Radio button in the Infopath form 2007

The below Dataconnection name is TestConn.Create dataconnection in the Infopath form

the List GUIid is {46A48934-00D5-4914-8EF2-E012AD40343C}

http://star:111/sites/pf/_vti_bin/owssvr.dll?Cmd=Display&List={46A48934-00D5-4914-8EF2-E012AD40343C}&XMLDATA=TRUE&noredirect=true

set the dataconnection in the VSTA code

First write the code in the button changed event
--------------------------------------------------------
XPathNavigator root = MainDataSource.CreateNavigator();
// Get the value for the selected department string Filter = "HC";
// Clear the last selected value in the Months drop-down list box root.SelectSingleNode("//my:Months", NamespaceManager).SetValue("");
// Retrieve the data connection bound to the HC radio button FileQueryConnection con = (FileQueryConnection)DataConnections["TestConn"];
// Change the location of the data connection to point the XML file // returned by the owssvr.dll with a filter on department con.FileLocation = @"http://star:111/sites/pf/_vti_bin/owssvr.dll" + "?Cmd=Display&List={46A48934-00D5-4914-8EF2-E012AD40343C}" + "&XMLDATA=TRUE&FilterField1=FName&FilterValue1=" + Filter;
// Query the data connection to fill the Months drop-down list box with items con.Execute();

---------------------------------------------------
Second write the code in the button changed event
----------------------------------------------------
XPathNavigator root = MainDataSource.CreateNavigator();
// Get the value for the selected department string Filter = "NI";
// Clear the last selected value in the Months drop-down list box root.SelectSingleNode("//my:Months", NamespaceManager).SetValue("");
// Retrieve the data connection bound to the NI radio button FileQueryConnection con = (FileQueryConnection)DataConnections["TestConn"];
// Change the location of the data connection to point the XML file // returned by the owssvr.dll with a filter on department con.FileLocation = @"http://star:111/sites/pf/_vti_bin/owssvr.dll" + "?Cmd=Display&List={46A48934-00D5-4914-8EF2-E012AD40343C}" + "&XMLDATA=TRUE&FilterField1=FName&FilterValue1=" + Filter;
// Query the data connection to fill the Months drop-down list box with items con.Execute();

Monday, January 9, 2012

Ajax User Control page upload in the sharepoint web parts

solutions:In few it is possible to insert script manager from within control, unfortunately in many cases the control may not be able to insert the script manager early enough in the page lifecycle depending on how the control is used . You need to add script manager in master page and remove Steps:
Open SPD , Open your Site, navigate to Catalog-> MasterpagesSelect your master page & checkout.Edit your master page in SPD.

Save , CheckIn , Publish

Sharepoints Solutions

Pages