Javascript to disable all ASP:ImageButton

if you want to disable all <ASP:ImageButton type controls using Javascript, you have to keep in mind that browser renders the controls this way

<input type="image" name="ctl00$btnUserHistory" id="btnUserHistory" title="User Activities" src="/Img/userhistory.gif" />

You see ctl00$ in the name as the button is inside a ContentPlaceHolder, so catch all inside or not write this function

function disableButton() {
        //Disable All Image Buttons       
        var ButtonsColl = document.getElementsByTagName('input');
        for (i = 0; i <= ButtonsColl.length - 1; i++) {
            if (ButtonsColl[i].getAttribute('type') == 'image') {
                ButtonsColl[i].disabled = true;
            }
        }
    }

Convert SSL Certificate .cer to .pfx

If you were like me working on Azure projects and suddenly was required to upload your SSL certificate and hit the dead end trying to figure out how to convert the file to .pfx, you have come to the right place, follow these simple steps and you'll be good to go.

PowerShell Script
$c = New-Object System.Security.Cryptography.X509Certificates.X509Certificate2("c:\mycert.cer")
$bytes = $c.Export("Pfx","password")
[System.IO.File]::WriteAllBytes("c:\mycert.pfx", $bytes)

and just incase if you got the error cannot find type [System.Security.Cryptography.X509.....

Try running this to see if you have the System.dll loaded (should be by default):
[AppDomain]::CurrentDomain.GetAssemblies() |
    Where {$_.Location -match '\\System\\'}

If it is loaded then this command should show the X509Certificate2 type:
[AppDomain]::CurrentDomain.GetAssemblies() |
Where {$_.Location -match '\\System\\'} |
%{$_.GetExportedTypes()} | Where {$_.Name -match 'X509Cert'}
If the System.dll isn't loaded (which would be odd) try loading it:
Add-Type -AssembyName System

Changing License option of Windows Server

Just incase if you have installed the Windows Standard Server, and wanted to know how to convert the license to Enterprise here is the command line:

DISM /online /Set-Edition:ServerEnterprise /ProductKey:xxxxx-xxxxx-xxxxx-xxxxx-xxxxx

MS Backup failed to complete creation of shared protection point

if your windows 2008 R2 backup is failing because shadow copy of disks takes too long and timeout, follow the instructions below and set the time accordingly.


Windows Server Backup is timing out during shadow copy creation since it is taking more than 10 minutes.
You can try increasing the timeout value to 20 minutes and see if that fixes this issue?

This involves updating a registry key. Hence please do this carefully.

- Run regedit.exe and navigate to L"HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\SPP"

- Create a new Registry value of type DWORD with name "CreateTimeout"

- Change value to 12000000(2*10*60*1000 = 20 mins) in decimal

Re-run backup and check if it succeeds now.

Creating Windows Gadgets Project in Visual Studio 2010

If you were trying to find how to create a windows gadgets project in visual studio you have come to the right place.

Well its much simpler than you thought.

1. Create a CAB Project. Select File -> New -> Project, and pick CAB Project in Other Project Types
    -> Setup and Deployment -> Visual Studio Installer
    Type the Project Name you want, in my scenario I have given MyNewCabProject and Press OK

2. Select the project name in the Solution Explorer and select the PostBuildEvent

3. Copy these lines into the Post-Build Even Command Line, replacing MyNewGadgetName with the name of your gadget.

set GadgetName="$(ProjectDir)$(Configuration)\MyNewGadgetName.gadget"
copy /y "$(BuiltOuputPath)" %GadgetName%
%GadgetName%

Now, when the project builds, it creates the .CAB file, copies it to a .gadget file and then runs the gadget to install it.

Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’

A number of people have hit this issue and so it deserves a quick walkthrough of why it (unfortunately) can happen and how you fix it.



The error occurs when you try to select a Document Library of type PowerPivot Gallery (sometimes referred to as Report Gallery). After installing Power Pivot for SharePoint, all new site collections you create have the option to create a new document library of this type and if you use the PowerPivot Site template when creating the site collection, it automatically adds a library of this type (that is the main thing we do in this template). The ability to add this type of library in all new site collections is there because we defined the library in a feature which is subsequently stapled to all sites. This means it is automatically activated on all site collections. The problem is that the page which is loaded when you click on the library as its default view uses an ASP.Net control whose code behind is found in a dll which is not being found.

So when does this happen? Every case I have seen so far, this occurs when the user creates a new Web Application and does not deploy the WebApp solution to the new Web Application. Because of how MS reference the classes for our pages, we need to have the associated assembly in the <vdir>\bin directory.

This assembly is Microsoft.AnalysisServices.SharePoint.Integration.dll. The dll is “pushed” to the web applications on every WFE in the farm via the SharePoint solution infrastructure.

Ignoring any of the questions around “how should we have done this to avoid this error” .. to fix this situation, you simply need to deploy the web app solution to the Web Application you just created. To do this, go first to the System Settings page in Central Admin

Under Farm Management, select Manage farm solutions.

Click on the powerpivotwebapp.wsp solution to see its properties

On the properties page, you will see the “Deployed To” list and notice that your new web application is not on this list. Select the “Deploy Solution” link at the top of this page

You can now chose to deploy the solution to the new Web Application you have created (and you can chose to do it “Now”). After this, the bits will be pushed to all machines in the farm and you can use the PowerPivot Gallery in your new site collections.  One thing to note (since I got burned by this) … instinct is, after this is done, to just go back to the error page and hit refresh thinking that it should be fixed now. The error page, though, is an actual error page and when you hit refresh, all you are doing is reloading the error page. To actually reload the PowerPivot Gallery, use the back button in your browser or click on the “Go back to site” link in the error page.

CSharp.Net SharePoint List of Document Libraries using Client Context

This code will only return Document Libraries which are based on Template 101 ancestral type.


ClientContext clientContext = new ClientContext("http://mysharepoint");
Web oWebsite = clientContext.Web;
ListCollection collList = oWebsite.Lists;
clientContext.Load(collList);
clientContext.ExecuteQuery();
foreach (List oList in collList)
{
if ((oList.BaseType == BaseType.DocumentLibrary) && (oList.BaseTemplate == 101))
   {
     Do your actions here with oList.Title, oList.Title
   }
}

Get a list of all Triggers in a SQL Database

SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S1.deltrig > 0 THEN 'Delete' WHEN S1.instrig > 0 THEN 'Insert' WHEN S1.updtrig > 0 THEN 'Update' END 'TriggerType' FROM sysobjects S1 JOIN sysobjects S2 ON S1.parent_obj = S2.[id] WHERE S1.xtype='TR'
The above doesn't correctly identify INS, UPD and DEL. Try:

SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S2.deltrig = s1.id THEN 'Delete' WHEN S2.instrig = s1.id THEN 'Insert' WHEN S2.updtrig = s1.id THEN 'Update' END 'TriggerType' , 'S1',s1.*,'S2',s2.* FROM sysobjects S1 JOIN sysobjects S2 ON S1.parent_obj = S2.[id] WHERE S1.xtype='TR'

Display / Show PDF icon in Sharepoint / MOSS

1. Copy the .gif file that you want to use for the icon to the following folder on the server, as appropriate for your version of SharePoint:
   SharePoint Portal Server 2003 - Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Template\Images
   SharePoint Server 2007- Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Image
   SharePoint Server 2010 - Drive:\Program Files\Common Files\Microsoft Shared\Web server extensions\14\Template\Images
2. Stop IIS at a command prompt by running IISReset /stop
3. Edit the Docicon.xml file to include the .pdf extension. To do this, follow these steps:
   1. Start Notepad, and then open the Docicon.xml file. The Docicon.xml file is located in one of the following folders on the server:
      SharePoint Portal Server 2003 - Drive:\Program Files\Common Files\Microsoft Shared\Web server extensions\60\Template\Xml
      SharePoint Server 2007- Drive :\Program Files\Common Files\Microsoft Shared\Web server extensions\12\Template\Xml
      SharePoint Server 2010- Drive:\Program Files\Common Files\Microsoft Shared\Web server extensions\14\Template\Xml
   2. Add an entry for the .pdf extension. For example, add a line that is similar to the following to the Docicon.xml file, where NameofIconFile is the name of the .gif file:
      <Mapping Key="pdf" Value="NameofIconFile.gif"/>
   3. On the File menu, click Save, and then quit Notepad.
4. Start IIS at a command prompt by running IISReset /start

Calculate Working days in a Month

Dim stDate As Date = New Date(Year(dtDate), Month(dtDate), 1)
Dim enDate As Date = New Date(Year(stDate), Month(stDate), DateTime.DaysInMonth(Year(stDate), Month(stDate)))
While stDate < enDate
    If stDate.DayOfWeek <> DayOfWeek.Saturday AndAlso stDate.DayOfWeek <> DayOfWeek.Sunday Then
        intReturnValue += 1
    End If
    stDate = stDate.AddDays(1)
End While
Return intReturnValue

How to create threads with .net and Azure Web Role

Dim t As New Threading.Thread(AddressOf ThreadTask)
t.IsBackground = True
t.Start()

and then create your ThreadTask

Private Sub ThreadTask()
'do your routine here
End Sub

Best way to Zoom map to include all Pushpins

add the following to your map function

var locs = new Array();
/* Repeat the next 2 lines of code as neccessary */
var loc = new VELatLong(<latitude>, <longitude>);
locs.push(loc);
/* End Repeat */
map.SetMapView(locs);

Writing to Azure Local Storage

You will need to modify ServiceDefinition.csdef add the following lines

<LocalResources>
<LocalStorage name="LocalTempFolder" cleanOnRoleRecycle="false" sizeInMB="5" />
</LocalResources>

and then you can access the path this way in your code

Dim localResource As LocalResource = RoleEnvironment.GetLocalResource("LocalTempFolder")
Dim pathToReadWriteFolder = localResource.RootPath

Check if SQL View Exist

IF OBJECT_ID ('_YOUR_VIEW_NAME', 'V') IS NOT NULL DROP VIEW _YOUR_VIEW_NAME';

Javascript Popup window causes parent font size increase?

If you are usnig Javascript popup window and its disturbing your parent font sizes use the ScriptManager.RegisterStartupScript instead.

ScriptManager.RegisterStartupScript(Page, Page.GetType(), "newWindow", "window.open('MyPage.aspx?ID=" + MyID + "','_blank','status=1,toolbar=0,menubar=0,location=1,scrollbars=1,resizable=1,width=30,height=30');", true);
   

SQL Azure DATETIME Functions

Microsoft SQL has always included a number of date and time functions.  These results of these functions were always based on the operating system for the machine the SQL server was running on.  But what results will you get when you’re dealing with SQL Azure?

The server(s) are all virtual.

They are all based on UTC, Coordinated Universal Time.  Yes, I know the acronym should be CUT.  Just go to Wikipedia if you want to try and make sense of this.

Since all these functions will run based on UTC, you’ll always get the same results, no matter which data center you choose to be your primary.

The table below shows the results from the following query run against a SQL Azure instance hosted in North Europe on 20th June 2011 07:08:53 UTC.

SELECT
    SYSDATETIME() as SYSDATETIME,
    SYSDATETIMEOFFSET() as SYSDATETIMEOFFSET,
    SYSUTCDATETIME() as SYSUTCDATETIME,
    CURRENT_TIMESTAMP as currenttimestamp,
    GETDATE() as getdate,
    GETUTCDATE() as getUTCdate;

Query
SYSDATETIME() 2011-06-20 07:08:53.1026073
SYSDATETIMEOFFSET() 2011-06-20 07:08:53.1026073 +00:00
SYSUTCDATETIME() 2011-06-20 07:08:53.1026073
CURRENT_TIMESTAMP 2011-06-20 07:08:53.113
GETDATE() 2011-06-20 07:08:53.113
GETUTCDATE() 2011-06-20 07:08:53.100

If you are like me, whenever you deal with international users, you already changed your servers to UTC, so taking this into consideration for SQL Azure should be nothing new.  If you’re not used to this.  Perhaps now is the time to consider the benefits to having your server use UTC, store UTC + offsets in your tables, and allow users to run with multiple time zones.

It sure makes scheduling easier that way.  Or at least it beats trying to figure out what time to hold a meeting between London the US and Mexico, both before and after Daylight Savings time kicks in!

Windows Azure Reporting missing .dll

I deployed my project successfully to Windows Azure, but got a surprise when I ran reports, they gave error mentioning a missing assembly Microsoft.ReportViewer.ProcessingObjectModel.dll

now I new how to add references to Microsoft.ReportViewer.Common.dll and Microsoft.ReportViewer.WebForms.dll but I couldn't find the missing one anywhere, but with a help from a colleague here is the workaround.

how did I get the third assembly, Microsoft.ReportViewer.ProcessingObjectModel.dll?

Apparently this assembly was found only in the GAC. Here is how you copy the file in the GAC :

1. Open command prompt (run as Adminsitrator)
2. cd C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.ProcessingObjectModel
3. do dir.
4. You see either one or both of the following folder:
   8.0.0.0__b03f5f7f11d50a3a
   9.0.0.0__b03f5f7f11d50a3a
   10.0.0.0__b03f5f7f11d50a3a
5. cd to one of them, and do dir.
6. You should see the Microsoft.ReportViewer.ProcessingObjectModel.dll assembly.
7. You can perform copy operation to your preferred destination folder.

MsgBox or MessageBox Error on Windows Azure

Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.
so if you hit the error above, you have used MsgBox or MessageBox dialogue boxes to confirm the user click.

well the solution is simple use Ajax ConfirmButton 

see the link below for syntax:
http://www.asp.net/AJAX/AjaxControlToolkit/Samples/ConfirmButton/ConfirmButton.aspx

The report definition for report 'path' has not been specified

So I guess you hit the error like it did, reports were working fine in your local project, but when uploaded to windows azure they stopped working.

The full errormessage is:
The report definition for report 'path' has not been specified. Could not find file 'path'.

This error might occur when you try to run a local report (rdlc).

The solution is to set the property "Build Action" of the rdlc to "Content". Now your installer will copy the physical rdlc.

you have to mark all .rdlc files in your project as Content.

SSRS 2008 Tablix control Repeat Column Headers does not work

If you faced the issue which I have faced, that you created your nice looking report, and next thing you realise the Column headers do not repeat, no matter what you did was not good enough to fix it.

Here is the solution:

Select the Tablix that you want to repeat column headers for by clicking on it.

At the bottom of the screen, find the "Row Groups" and "Column Groups" section.

Click the small drop-down-arrow on the right side of that section, and select the Advanced Mode.

Now you'll see additional lines called (static) in rows and columns groups.

In the "Row Groups" section, locate the top-outermost "static" row and click on it.

In the properties pane, you need to set the following properties:

KeepTogether = True
KeepWithGroup = After
RepeatOnNewPage = True

All of these properties must be set for this to work properly.

Good luck!

MS SQL Create Clustered Index on All Tables

I was creating Windows Azure project, and was faced when uploading the database to SQL Azure, that many of the tables didn't have Clustered Indexes, thought of saving some time by writing a script.

This script will create Clustered Index on all tables which do not have clustered index.


DECLARE @table_name VARCHAR(50); -- table name 
DECLARE @col_name VARCHAR(50); -- column name 
DECLARE @idx_name VARCHAR(256); -- name for index 
DECLARE @cmd1 NVARCHAR(256); -- command syntax

DECLARE db_cursor CURSOR FOR 
SELECT     sys.sysobjects.name AS tbName, sys.syscolumns.name AS colName, 'idx_' + sys.sysobjects.name + '_' + sys.syscolumns.name as idxName
FROM         sys.sysobjects INNER JOIN
                      sys.syscolumns ON sys.sysobjects.id = sys.syscolumns.id INNER JOIN
                      sys.systypes ON sys.syscolumns.xtype = sys.systypes.xtype LEFT OUTER JOIN
                      sys.indexes ON sys.sysobjects.id = sys.indexes.object_id
WHERE     (sys.sysobjects.xtype = 'U')  AND (sys.systypes.name = 'int') AND (sys.syscolumns.colid = 1) AND
                      (sys.indexes.index_id = 0)
ORDER BY tbName;

OPEN db_cursor;  
FETCH NEXT FROM db_cursor INTO @table_name, @col_name, @idx_name;  

WHILE @@FETCH_STATUS = 0  
BEGIN  

SET @cmd1 = 'CREATE CLUSTERED INDEX ' + @idx_name + ' ON ' + @table_name + '(' + @col_name + ');'

EXECUTE sp_executesql @cmd1

       FETCH NEXT FROM db_cursor INTO @table_name, @col_name, @idx_name;
END  

CLOSE db_cursor; 
DEALLOCATE db_cursor;

SQL Find tables without Clustered Indexes

USE AdventureWorks ----Replace AdventureWorks with your DBName
GO

SELECT DISTINCT [TABLE] = OBJECT_NAME(OBJECT_ID)
FROM SYS.INDEXES
WHERE INDEX_ID = 0
AND OBJECTPROPERTY(OBJECT_ID,'IsUserTable') = 1
ORDER BY [TABLE]
GO

Create SSL test Certificate

Open a Visual Studio Command Prompt

Change your active directory to the location where you wish to place your certificate

Enter the following command

makecert -r -pe -n "CN=AzureSSL" -sky 1 "azuressl.cer" -sv "azuressl.pvk" -ss My

after the process has succeeded

Now enter the following command

pvk2pfx -pvk "azuressl.pvk" -spc "azuressl.cer" -pfx "azuressl.pfx" -pi password1

and you are good to go, you have your test certificate

SQL Search for a String in all Tables

Declare @TN as varchar(200), @CN as varchar(200), @myValue varchar(30), @SQL as nvarchar(1000) 
, @SN as varchar(200), @Exact_Match bit 
  
Create Table #myTable (Table_Name varchar(200), Column_Name varchar(200), Number_Of_Rows int) 
  
-- Replace @myValue with the value you're searching for in the database 
Set @myValue = 'mySearchValue'  
-- 0 for LIKE match, 1 for exact match 
Set @Exact_Match = 0     
  
Declare myCursor Cursor For 
Select T.Table_Name, C.Column_Name, T.Table_Schema 
From INFORMATION_SCHEMA.TABLES T Inner Join INFORMATION_SCHEMA.COLUMNS C  
On T.Table_Schema = C.Table_Schema And T.Table_Name = C.Table_Name 
Where T.Table_Name Not In ('dtproperties') And Table_Type = 'Base Table' 
And C.Data_Type In ('varchar','char','nvarchar','nchar','sql_variant') 
--And C.Data_Type In ('text','ntext') 
--And C.Data_Type In ('tinyint','int','bigint','numeric','decimal','money','float','smallint','real','smallmoney') 
--And C.Data_Type In ('datetime','dmalldatetime') 
-- Fields not searched: image, uniqueidentifier, bit, varbinary, binary, timestamp 
Open myCursor 
Fetch Next From myCursor Into @TN, @CN, @SN 
While @@Fetch_Status <> -1 
Begin 
        If @Exact_Match = 0 
                Set @SQL = N'Insert Into #myTable Select ''' + @SN + '.' + @TN + ''', ''' + @CN + ''', Count(*) From [' + @SN + '].[' + @TN + '] Where [' + @CN + '] Like ''%' + @myValue + '%''' 
            Else 
                Set @SQL = N'Insert Into #myTable Select ''' + @SN + '.' + @TN + ''', ''' + @CN + ''', Count(*) From [' + @SN + '].[' + @TN + '] Where [' + @CN + '] = ''' + @myValue + '''' 
        --Print @SQL 
        Exec sp_executesql @SQL  
        Fetch Next From myCursor Into @TN, @CN, @SN 
End 
Close myCursor 
Deallocate myCursor 
Select * From #myTable Where Number_Of_Rows > 0 Order By Table_Name 
Drop Table #myTable

SSRS 2008 Report String Filter with LIKE operator

goto the Filters in Tablix or Group,
Add the filter,
select Expression as your Fieldname to be filtered on,
select operator LIKE
in value when you click fx button it will show you options in new window
click parameters and select the parameter you created in the report.
you'll see =Parameters!ParameterName.Value
change that to = "*" & Parameters!ParameterName.Value & "*"

SSRS 2008 Paging shows Question mark (?)

Yes I got confused as well as to what this suddenly a new thing in SSRS 2008 and how to solve it, I even thought its a bug, but guess what, its a feature Microsoft has introduced question mark is there because report did not render all the pages and only current page worth of records were processed, it is called On Demand Report Processing.

Yes I do understand the potential of massive performance gains but lets be honest whats the point of showing Page 1 of 2? its not really helpful.

Here we go, you will have to add a little piece of code in your report, so add a textbox in your header or footer containing =Globals!TotalPages, please note that its only allowed in the header or footer, and then you'll see that report will show current number of pages.

 

Appraisal vs Resignation

A newly joined trainee asks his boss "what is the meaning of appraisal?"
Boss: "Do you know the meaning of resignation?"
Trainee: "Yes I do"

Boss: "So let me make you understand what a appraisal is by comparing it with resignation"

Comparison study: Appraisal and Resignation Appraisal

In appraisal meeting they will speak only about your weakness, errors and failures.
In resignation meeting they will speak only about your strengths, past achievements and success.

In appraisal you may need to cry and beg for even 10% hike.
In resignation you can easily demand (or get even without asking) more than 50-60% hike.

During appraisal, they will deny promotion saying you didn't meet the expectation, you don't have leadership qualities, and you had several drawbacks in our objective/goal.
During resignation, they will say you are the core member of team; you are the vision of the company how can you go, you have to take the project in shoulder and lead your juniors to success.

There is 90% chance for not getting any significant incentives after appraisal.
There is 90% chance of getting immediate hike after you put the resignation.

Trainee: "Yes boss enough, now I understood my future. For an appraisal I will have to resign..!!

Create Azure asp.net site using Web Role

Create new project using Cloud Template (Windows Azure Project)

Press OK wizard will show you different types of roles, seleect ASP.NET Web Role and add

Press OK

Wizard has created a Project which has Azure Cloud Web Role

When you press F5 or start debug, you'll notice Windows Azure Emulator on your taskbar.

Right click and select Show Compute Emulator UI

You'll be able to see your project being executed

Not much to do here :) just add your files and you are good to go.

Create Event Handler in SharePoint with Visual Studio 2010

Working with the new Visual Studio 2010 has become so easy that even I can write my own event handlers within no time. Traditionally you'll go thru alot of pain of writing classes, creating features, and then deploying and activation of those features.

here you go in simple steps:

first create new project, by selecting the SharePoint Event Receiver project type.

Enter the site for debugging your code and select deploy as a farm solution

Select the List Item Events type, for Announcements (e.g.) for an item is being deleted

Write your code to handle whatever you want to achieve.

You can build the project, or just simply deploy it to your site if you are sure there are no errors.

Now sit back and relax Visual Studio 2010 will do all the work for you, and deploy the project into correct areas and do whatever is required to be done such as snk, .wsp, web.config, feature activation etc etc.

Now the moment of truth, i'll try to delete an announcement from my site 

and there you go the code has worked, (i don't know how hahaha)

if you notice in your project you had an xml file Elements.xml it has a ListTemplateID="104", here is the list of all id(s) which you might need.

100   Generic list
101   Document library
102   Survey
103   Links list
104   Announcements list
105   Contacts list
106   Events list
107   Tasks list
108   Discussion board
109   Picture library
110   Data sources
111   Site template gallery
112   User Information list
113   Web Part gallery
114   List template gallery
115   XML Form library
116   Master pages gallery
117   No-Code Workflows
118   Custom Workflow Process
119   Wiki Page library
120   Custom grid for a list
130   Data Connection library
140   Workflow History
150   Gantt Tasks list
200   Meeting Series list
201   Meeting Agenda list
202   Meeting Attendees list
204   Meeting Decisions list
207   Meeting Objectives list
210   Meeting text box
211   Meeting Things To Bring list
212   Meeting Workspace Pages list
301   Blog Posts list
302   Blog Comments list
303   Blog Categories list
1100   Issue tracking
1200   Administrator tasks list

GUID Generation

If you want to create a GUID for your project follow the procedure.

1. Open the Visual Studio .NET Command Prompt.
   
   In the Program Group for Visual Studio .NET, point to Visual Studio .NET Tools and choose Visual Studio .NET Command Prompt. A command prompt will be displayed. This special command prompt window allows you to access tools for Visual Studio.
2. Launch the GUID Generator.
   At the command prompt, enter the following:
   
   guidgen
   
   The Create GUID utility will appear.

3. Specify the type of GUID to generate.
   The Create GUID utility can generate GUIDs in several forms. For Business Portal integrations, GUIDs must be in the Registry format.
   
4. Generate and copy the GUID.
   To generate a new GUID, click New GUID. To copy the GUID to the clipboard to use in your integration, click Copy.