When we want to run a task (like sending emails or deleting the list items etc. . . ) in Daily basis or in Hourly basis then we can use a Timer job to this task .To see the timer job you can move to the Central Administrations then click on the operations tab, then in the Global Configuration section you can see the Timer job status and timer job definition. In timer job definition you can get the details of the timer job i.e. the title , the web application to which it is attached and the schedule type i.e. Daily, Weekly or hourly basis. To get the status of the timer job go to the timer job status, here you can view status. http://www.mindfiresolutions.com/How-to-create-a-Custom-Timer-job-in-SharePoint-957.php[^]

Cheers, Eliza

You can use migrate to sharepoint 2010 : Any organization can make the mistake of assuming that one enterprise level collaboration platform would be suitable for all the needs of its people. Organizations should know that because the nature of the projects vary within a company, different IBUs (Independent Business Units) might have different needs and hence their level of acceptance to one common collaboration org-wide platform would vary. If one project has a focus on usability reporting, the might have on document collaboration and still others would have different specific needs. That's why SharePoint 2010 is an unfinished product. It allows you to meticulously observe your needs and then assess what customizations are needed in the product more to make it more acceptable in your company. And this process is the most painstaking of all activities. You might be already hosting your portal in SharePoint or you may not have used SharePoint at all, if you want to take advantage of what SharePoint 2010 can offer to your business, one thing you must invest on – understanding the needs of your business. As your business evolves, your needs evolve too. Capturing all those needs and transforming them into reality is what SharePoint 2010 promises. http://www.mindfiresolutions.com/Sharepoint-Consulting-Company.htm[^]

Cheers, Eliza

In some cases we need to add documents to the doument library programatically, the code snippet below demonstrates how to add a document to the document library . using (SPSite objSite = new SPSite("urlAddress")) { objSite.AllowUnsafeUpdates = true; using (SPWeb oSPWeb = objSite.OpenWeb()) { oSPWeb.AllowUnsafeUpdates = true; //Test1 is the document library SPList docLibrary = oSPWeb.Lists["Test1"]; http://www.mindfiresolutions.com/Programatically-adding-a-document-to-document-library-in-SharePoint-709.php[^]

Cheers, Eliza

For instance, let us take a State List which holds all the states of India. States are grouped under different zones i.e. North, South, East & West. If I need to retrieve all the States for North zone then my SP Query would look somewhat like, SPQuery stateQuery = new SPQuery(); stateQuery.Query = "<Where><Eq><FieldRef Name=\"Zone\"/><Value Type=\"Text\">North</Value></Eq></Where>"; SPListItemCollection stateCol = StateList.GetItems(stateQuery); In the code above the StateCollection object gets populated with the States only related to North zone. You can then bind this collection to a GridView or DataList or any other similar controls to view the actual values. http://www.mindfiresolutions.com/Sharepoint-SPQuery-30.php[^]

Cheers, Eliza

For instance, let us take a State List which holds all the states of India. States are grouped under different zones i.e. North, South, East & West. If I need to retrieve all the States for North zone then my SP Query would look somewhat like, SPQuery stateQuery = new SPQuery(); stateQuery.Query = "<Where><Eq><FieldRef Name=\"Zone\"/><Value Type=\"Text\">North</Value></Eq></Where>"; SPListItemCollection stateCol = StateList.GetItems(stateQuery); In the code above the StateCollection object gets populated with the States only related to North zone. You can then bind this collection to a GridView or DataList or any other similar controls to view the actual values. http://www.mindfiresolutions.com/Sharepoint-SPQuery-30.php[^]

Cheers, Eliza

Below is code snippet in c#.net for fetching all the attachements for a specific list item. try { // Set the Site Url SPSite objSite = new SPSite("http://Testsite/"); using (SPWeb objWeb = objSite.OpenWeb()) { objWeb.AllowUnsafeUpdates = true; // Get the List SPList objList = objWeb.Lists["MyList"]; // Get the item by ID SPListItem objItem = objList.GetItemById(1); // Get the attachments of the item SPAttachmentCollection objAttchments = objItem.Attachments; // Iterate the attachments foreach (string fileName in objItem.Attachments) { // Perform action on the extracted attachment } http://www.mindfiresolutions.com/Adding-an-Attachment-to-a-List-Item-Programmatically-in-SharePoint-478.php[^]

Cheers, Eliza

ASP.net Ajax Control Toolkit Color Picker Extender have a SampleControlID property, that shows the selected color's hexadecimal color code value for further use. But some time for better ui visibility need, if you don't want that hexadecimal color code to appear in the same control, then here is the way to do that. In this sample code below: I used a TextBox (txtColor) as ColorPickerExtender's SampleControlID and TargetControlID. I used a ImageButton(ibtnCollorPicker) with ColorPickerExtender's PopupButtonID. Now, when I click on the ibtnCollorPicker, this will show the colorpicker. Any color selection done, will show the hexa value in the txtColor. Method 1: (Mostly Used By Developers) On color selection, the selected color of color picker becomes the both the fore color and background color of the textbox. So since the hexa value does not appear directly. <asp:TextBox ID="txtColor" runat="server"></asp:TextBox> <asp:ImageButton ID="ibtnCollorPicker" runat="server" ImageUrl="~/Images/color_button.png" ToolTip="Pick Color"></asp:ImageButton> <cc:ColorPickerExtender ID="txtColor_ColorPickerExtender" runat="server" http://www.mindfiresolutions.com/Hiding-hexadecimal-color-code-in-ColorPickerExtenders-Sample-Control-679.php[^] TargetControlID="txtColor" SampleControlID="txtColor" OnClientColorSelectionChanged="changeColor" PopupButtonID="ibtnCollorPicker"> </cc:ColorPickerExtender> function changeColor(sender) { sender.get_element().style.color = sender.get_selectedColor(); } It works fine but it has a small issue. After selection, if you highlight textbox text with the help of mouse, then the hexa value will appear again. Method 2 contains solution of this.

Cheers, Eliza

Following is the code sample used to display the outlook folder dialog using VB.NET [VB.NET CODE STARTS] Dim objOutlook As Object Dim objOlNamespace As Object Dim objOlFolder As Object objOutlook = CreateObject("Outlook.Application") ' create outlook application object at the run time objOlNamespace = objOutlook.GetNamespace("MAPI") objOlFolder = objContactsNS.PickFolder ' displays the folder dialog [VB.NET CODE ENDS] http://www.mindfiresolutions.com/Open-Outlook-folder-dialog-and-select-folder-using-VBNET-896.php[^]

Cheers, Eliza

1.Are all the conditional paths reachable? 2.Are all the individual conditions in a complex conditions separately evaluated? 3.If there is a nested IF statement, are the THEN and ELSE parts appropriately delimited? 4. In the case of a multi-way branch like SWITCH/CASE statement, is a default clause provided? Are the breaks after each CASE appropriates? 5.Is there any part of code that is unreachable? 6.Are there any loops that will never execute? 7.Are there any loops where the final condition will never be met and hence cause the program to go into an infinite loop? 8.What is the level of nesting of the conditional statements? Can the code be simplified to reduce complexity? http://www.mindfiresolutions.com/Code-Review-Checklist-238.php[^]

Cheers, Eliza

For instance, let us take a State List which holds all the states of India. States are grouped under different zones i.e. North, South, East & West. If I need to retrieve all the States for North zone then my SP Query would look somewhat like, SPQuery stateQuery = new SPQuery(); stateQuery.Query = "<Where><Eq><FieldRef Name=\"Zone\"/><Value Type=\"Text\">North</Value></Eq></Where>"; SPListItemCollection stateCol = StateList.GetItems(stateQuery); In the code above the StateCollection object gets populated with the States only related to North zone. You can then bind this collection to a GridView or DataList or any other similar controls to view the actual values. Note: - Each tag must be properly ended / closed. - Eq stands for Equal. One cab also use NEq for not equal conditions. - FieldRef holds the column name on which we want to run the query. In our case it is Zone. - Value holds the parameter for the query column. In our case it is North. - Can use / surround column name with / tags to have the corresponding NULL condition checks. http://www.mindfiresolutions.com/Sharepoint-SPQuery-30.php[^]

Cheers, Eliza

We all know Math.Round() basically rounds a particular decimal value. But if we look into this method closely it rounds the value to the nearest even value. For example if we do Math.Round(2.5,0) it will return 2. But we may expect 3 intead of 2. In that case we can use MidPointRounding parameter of Math.Round() method. Math.Round can also take a parameter known as MidPointRounding which helps us to select the Rounding option. That means whether we want to round towards even number or to the number away from zero. For example, when someone do the rounding of 8.5 . MidpointRounding will help to specify whether rounding will be towards the even number (8) or it will be away from zero (9). http://www.mindfiresolutions.com/MidPointRounding-for-MathRound-method-in-Net-Application-293.php[^]

Cheers, Eliza

All of us must have come across the fact that some set of codes are specific to a particular OS only and incompatible with others. In some instances they may also lead to system crashes. In such cases we need to track and identify the OS first and then proceed accordingly. So, here is how you can write a program in VB6.0 that can run in different Windows operating systems. http://www.mindfiresolutions.com/Determining-host-operating-system-using-VB-6-189.php

Cheers, Eliza

If we write in the same way as above for the hashtable then we would not get the desired values. Hashtable ss = new Hashtable(); ss["key1"] ="india"; ss["key2"] = "bharat"; foreach (object gg in ss) { Console.WriteLine("Key value is " + gg); Console.Read(); } Here we get System.Collections.DictionaryEntry and System.Collections.DictionaryEntry as output instead of the value pairs stored in the hashtable. In this case we can help of DictinaryEntry object for iterating the hashtable. foreach(DictionaryEntry gg in ss) { Console.WriteLine("Key and value are " + gg.Key + " " + gg.Value); Console.Read(); } A DictionaryEntry object is simply a container containing the Key and Value . http://www.mindfiresolutions.com/How-To-Iterate-the-Hashtable-in-C-311.php[^]

Cheers, Eliza

When we add a customized checkbox column to a datagrid in .net (windows application) , the default property allows to check or uncheck the column using a double click. On the first click it selects the column and on the second click the column is either checked or unchecked. To change this default property, we need to handle the click event on grid and modify the selected cell value. For more details.Please check the link below. http://www.mindfiresolutions.com/Checkbox-Column-In-Datagrid-857.php[^]

Cheers, Eliza

Compute is one of the methods of DataTable class. This method computes an expression on the current rows that pass the filter criteria. Syntax Object DataTable.Compute(string expression , string filter) Expression - The expression to compute. Filter - The filter to limit the rows that evaluate in the expression. This method's return type is System.Object. So, you have to cast it with appropriate data type. The following operations can be passed through as expression parameter. Sum -> Sum Average -> Avg Minimum -> Min Maximum -> Max Count -> Count Statistical standard deviation ->StDev Statistical variance -> Var http://www.mindfiresolutions.com/DataTable-Compute-Method-628.php[^]

Cheers, Eliza

SharePoint provides options to create sites with different types of locales available out of the box. Suppose we have a SharePoint site built using the English locale and we want to change the existing site to some other locale then this can be achieved using the following piece of code. Changing the locale of the site helps display the date and number formats with their respective decimal and group separators. http://www.mindfiresolutions.com/Changing-SharePoint-site-locale-programmatically-834.php[^]

Cheers, Eliza

There are four steps to it, which are defined below: Step 1: Click on External Data ribbon, go to the "Import" section and click on XML file option. Step 2: Use the browse option to go to the location where the XML file is located from which data needs to be imported. Click Open and then OK. Step 3: Access will scan through the file and display the structure of the table to be created. The Import Options includes the following options, namely Structure Only / Structure & Data / Append data to existing table. In our process we will choose the option of both structure and data. Step 4: If you plan to import the same file agian in the future then you can check the box "Save Import Steps". Now you can double click on the table that is created and would be able to see the structure and the data in it i.e. imported from the XML file. Eliza http://www.mindfiresolutions.com/[^]

Cheers, Eliza

We can use SharePoint API as well as SharePoint List web reference to update List Items. Using API it is quite straight forward as we can directly assign a DateTime object against a DateTime field in SharePoint list. But with List web reference it is not that straight forward as we need to first convert the DateTime object into the SharePoint DateTime formatted string and then assign it to the specific field. http://www.mindfiresolutions.com/lp/sharepoint-development.htm[^]

Cheers, Eliza

First of all we need to know a little on SharePoint lookup fields before proceeding further. Lookup fields are the reference fields created in any SharePoint list or library which provides a mapping between columns from another list i.e. it is just like a foreign key which helps build relationship between lists. While developing custom solutions there is often a need to retrieve data from a list or update data in a list but it's a bit different when the task is performed for a lookup field. Generally lookup data are stored as ID - Name pair separated with some special characters (i.e. ID;#Name). http://www.mindfiresolutions.com/lp/sharepoint-development.htm[^]

Cheers, Eliza

These are the steps to solve the above mentioned problems: 1) Copy the .MSI file to the root directory of your main hard drive (i.e. C:\). 2) Open Windows Notepad. 3) Copy this text into windows notepad: msiexec /i C:\program_name.msi (You can write the total path of your .msi file in the system, after msiexec /i.) 4) Replace the text "program_name" in the code that you copied with the actual name of the .MSI file . 5) Click File -> Save As... Instead of saving it as a .txt file, change the file name to installer.bat. Save the file to your desktop. 6) On your desktop, right click on the file and select Run as Administrator. This will run the .msi file properly to install the application in the system. Thanks Eliza http://www.mindfiresolutions.com/[^]

Cheers, Eliza