cannot be opened because its project type (.csproj) is not supported by this version of the application.

Go to Start> All Programs > Visual Studio 2008 > Visual Studio Tools > Click Visual Studio 2008 Command Prompt. Type the below command and press enter.

devenv.exe /resetskippkgs

SQL Delete current database

I need to delete my current database which I am using it , I googled around and found this answer:

http://sqlserver2000.databases.aspfaq.com/how-do-i-drop-a-sql-server-database.html

ALTER DATABASE myDataBase
    SET SINGLE_USER
    WITH ROLLBACK IMMEDIATE

DELETE DATABASE myDataBase 

Password protect your outlook

This link guides you, how to protect your Outlook with password :

http://www.groovypost.com/howto/password-protect-outlook-pst-file/ 

Biztalk System.Exception assembly location

C# difference between StringBuilder and String Object

The most common operation with string is concatenation, and this has to be performed very efficiently.
When we use String objects to concatenate two strings , then a new copy of string object is created in memory by adding two objects , and the old string object is deleted.

So we use StringBuilder to do it in a effective way, here the concatenation is done on the exsisting  string, hence the insertion is faster. Concatenation is done using Append() method

C# difference between XmlDocument.Load() and XmlDocument.LoadXml()

XmlDocument.Load() is used to load a stream, or from xml file path.
XmlDodument.LoadXml() literally loads content of xml.

C# convert document to string type.

Hi Guys,
There was a situation in my project where I have to convert a xml document to string type, initially I though it is very difficult, and later I felt  it is a cake-walk actually!, the below code snippet shows how to achieve it:

• First you create a XmlDocument object, then you load the content of the xml document file into the object , where 'file' is the path of the xml file.
• Create a stringwriter , and save the contnet of xmldocument object into the string writer 'sw'
• Convert the string writer 'sw' to string and store it in a string variable.

C# Shallow Copy and Deep Copy

http://www.codeproject.com/Articles/28952/Shallow-Copy-vs-Deep-Copy-in-NET 

Difference between null and String.Empty

1. string statement=null : means no object exists; null is not a value, it is a state indicating that object value is unknown or does not exists.

2. string statement = String.Empty : use of string.Empty doesn't create any objects  while "" creates a string object. So using string.Empty is better than using "" because every time you use "", it creates a new string while string.Empty just reference s string in memory that is created by default.

Understanding Reflection and static constructor

Hi .net newbies,
This post is mostly for you !!, to understand what  Reflection and static constructor really mean ,and when are they used in  .net projects.

You would have learnt what does .net reflection and static constructor mean , 

You may say reflection is :  The process of obtaining information about the assemblies and the types defined within them ,and creating and invoking and accessing type instance at run time and

You may say static constructor is used to initialize any static data or to perform a certain action that needs to be performed once.

So when do you use Reflection or static constructor, the below picture answers the question:

WCF as Windows Services Step by Step example

Hi Guys, in this post I will be explaining how to create a simple WCF service and host it as a 'Windows Service'.

Lets create a simple Windows Service which has a OperationContract which will add numbers and return it

Step 1: Create a simple WCF service library
Step 2: Create a simple Windows Services in which you will host the service
Step 3: Install the Windows Service
Step 4: Consume the Windows Services in a Windows Form Client.

Step 1: Create simple WCF Service library:

1. Open Visual Studio 2010 , Create new project and choose Windows Service Library named as Wcf_WindowsService_Add

2. Delete these files: App.config, IService1.cs, Service1.cs, and create your own WCF Service, Right click your project and create new item - > WCF Service name it as WindowsServiceAdd.cs

                             

3. In app.config files you can see two endpoints with bindings wsHttpBinding and mexHttpBinding and with abase address

4. Open  IWindowsServiceAdd.cs  Interface remove Dowork() Contract and your Contract with name Add()

5.  Open  WindowsServiceAdd.cs  remove DoWork() and define your Add() OperationContract :

6. Build your project , now your WCF Service library dll is ready to use.


Step 2: Create a simple Windows Services in which you will host the service:




1. Right Click your solution and create new project. -> Windows -> Windows Services.

                              

2. Delete Program.cs and Service1.cs and create your own Service , by right clicking the project add new item -> Windows Service

                          

3. Click 'click here to switch to code view' , and modify the code as shown below to add a Service Host and methods to stop and start the services ,and add System.ServiceModel to your project , and your Service Library dll too

4. Add Program.cs file

5.Build this project . now it is ready to be installed in your machine

Step 3: Install the Windows Service 


1. Inorder to install the service we need Installer class, so add new installer class:

2.Goto Start - > All programs -> Visual Studio 2010 - > Visual Studio Tools -> Visual Studio command prompt. Goto to  path of your serviceAdd.exe ,  and install it using ' installutil serviceAdd.exe

3. You can see your service in Service Console

Step 4: Consume the Windows Services in a Windows Form Client.


1. Start your service , Create a new Windows Form project, refer your WCF hosted as Windows services ( http://localhost:8732/Design_Time_Addresses/Wcf_WindowsService_Add/WindowsServiceAdd/ ) to this project. add a  lable and a button, double click the button and and add the bellow code , and run your project :

2. Build and Run your Windows Form to consume the service

Orchestration Dehydration & Rehydration

When many long-running business processes are running at the same time, memory and performance are potential issues. The orchestration engine addresses these issues by "dehydrating" and "rehydrating" orchestration instances.

Dehydration is the process of serializing the state of an orchestration into a SQL Server database. Rehydration is the reverse of this process: deserializing the last running state of an orchestration from the database. Dehydration is used to minimize the use of system resources by reducing the number of orchestrations that have to be instantiated in memory at one time.

The orchestration engine might determine that an orchestration instance has been idle for a relatively long period of time. It calculates thresholds to determine how long it will wait for various actions to take place, and if those thresholds are exceeded, it dehydrates the instance. This can occur under the following circumstances:

• When the orchestration is waiting to receive a message, and the wait is longer than a threshold determined by the engine.
• When the orchestration is "listening" for a message, as it does when you use a Listen shape, and no branch is triggered before a threshold determined by the engine. The only exception to this is when the Listen shape contains an activation receive.
• When a delay in the orchestration is longer than a threshold determined by the engine.

The engine dehydrates the instance by saving the state, and frees up the memory required by the instance. By dehydrating dormant orchestration instances, the engine makes it possible for a large number of long-running business processes to run concurrently on the same computer.

You can set 12 properties to configure how dehydration works in BizTalk Server. The topics in this section list and describe these properties and their default values, and discuss how various values affect dehydration behavior.

The orchestration engine can be triggered to rehydrate an orchestration instance by the receipt of a message or by the expiration of a time-out specified in a Delay shape. It then loads the saved orchestration instance into memory, restores its state, and runs it from the point where it left off. For more information about using shapes in orchestrations, see Orchestration Shapes.

An orchestration can be configured to run on more than one server. After an orchestration instance has been dehydrated, it can be rehydrated on any of these servers. If one server goes down, the engine continues to run the orchestration on a different server, continuing from its previous state. The engine also takes advantage of this feature to implement load balancing across servers.

Biztalk : Moving simple file from one folder to another folder

We can easily move files from one folder to another destination folder using Biztalk Server Administrator console. You need to use the filters to achieve this.

read more :  http://bryantlikes.com/pages/463.aspx 

SQL Constraints

Constraints limit the type of  data that can go into the table.
The following are the constraints:

1. NOT NULL
2. UNIQUE
3. PRIMARY KEY
4. FOREIGN KEY
5. CHECK
6. DEFAULT

SQL Joins

Hi newbies,
Want to learn SQL joins at a glance!!, here you go... SQL joins is Venn diagram representation:
A very nice picture given in codeproject.

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

What are EXD files

EXD is control information cache file . It is a type of file that contains your most recently used information of a computer object , which in this case is a control

read more

SharePoint 2010 export list to powerpoint

How to export your SharePoint list date  to power point?
Hmm mm.... nope...  Import your SharePoint list data from powerpoint  :-)

1)  Write a vba macro for PowerPoint
2) Where you  call the SharePoint service to get the SharePoint list data to it.

OSI Model

http://home.earthlink.net/~tt4titans/id13.html
http://www.cse.iitk.ac.in/users/dheeraj/cs425/lec01.html
http://www.roseindia.net/technology/networking/osi.shtml

How to turn on Telnet client on your machine?

Here are the steps by which you can turn on the telnet client:
Goto Control panel ->     Programs and features ->      Turn Windows feature ON or OFF ->                                            Check Telnet Client ->     OK

HTTP Protocol

Nice tutorial on HTTP protocol:

Read here..

SharePoint 2010 Form based authentication web service

http://www.codeproject.com/KB/sharepoint/SharePointWSAccess.aspx 

SharePoint Why Site Templates?

Say you need to create similar sites in SharePoint (be 50 - 100), where all will have 100 lists, 100 document libraries, 100 pages...etc , so each time you create a site , you have to create all the 100 things again and again , in these situations you can create a single site template with all the 100s only once , which can be inherited by other sites of same category.

Guidelines for Templates and Definitions

http://msdn.microsoft.com/en-us/library/dd586628(v=office.11).aspx 

Difference between Site Definition and Site Template

Site Definition:

• Site Definition defines a unique type of SharePoint site, they are by default installed in windows SharePoint Services.
• Site Definitions are Team Site,Blank Site, and Document Workspace, Basic Meeting WorkSpace, Blank Meeting Workspace, Decision Meeting Workspace, Social Meeting WorkSpace.
• Each site definition emerges through a combination of multiple files that are placed in  Local_Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\ subdirectories on one or more front-end Web servers during installation of Windows SharePoint Services.
• Site definition files include core schema XML files, .aspx pages, document template files (.dot, .htm, and so on), and content files (.gif, .doc, and so on).

 Site Template:

•  Are Snapshot of a site at any point of time.
•  Here files are in database whereas in site definition they are on disk.
•  Site templates can be created from Web UI by site owners , Site Definition requires admin access to server for deploying.
•  Custom Site templates can be modified without affecting existing sites that have been created from the templates , modifying the site definition might break existing site.  

Difference between Site Definition and Site Template