Sharepoint Conference Keynote Video

Watch Video of Sharepoint 2009 Conference

Steve Ballmer Keynote on Sharepoint 2010

Watch Video: Jeff Teper presentation on Sharepoint 2010

Sharepoint 2010 Video Tutorial

Video tutorial for sharepoint 2010.

Video for Create External Content Types using SharePoint Designer 2010
The External Content Types section within SharePoint Designer lets us define connections to Line of Business data that we have access to as a developer, designer or admin of that site. Once the connection is defined, business analysts can use that connection to create what’s called External Lists which shows the content of what the connection is attached to (for example a table in a database).

Video for Navigational components of SharePoint Designer 2010
SharePoint Designer 2010 is the premier tool to configure and customize SharePoint 2010. It has evolved from SharePoint Designer 2007 with a totally new look and feel to it. This video shows how you can navigate around the SPD 2010 environment.

Video for Creating SharePoint 2010 site components
This video shows how to create components of a SharePoint 2010 site such as Lists, Libraries and Subsites.

Video for Create and Manage SharePoint Content using SharePoint Designer 2010
Using SharePoint Designer 2010, it is very easy to create SharePoint 2010 components. This video shows how easy it is and how much faster you can create the objects in this environment compared to using the browser to manage your sites.

Video for What's new in InfoPath 2010 - Walkthrough
A walkthrough of what's new in Microsoft InfoPath 2010. Features such as Page and Section Layouts, Controls and the Ribbon interface are explored in tihs video.

Video for Configuring SharePoint security using SharePoint Designer 2010
SharePoint security can be managed easily using either the browser or SharePoint Designer. This video shows how you can manage it using SharePoint Designer 2010.

Video for Explore InfoPath 2010 Controls
This video explores the various controls which are present in InfoPath 2010. Many have been carried over from InfoPath 2007, but some are brand new in this version of InfoPath.

Video for XSLT List View web parts and Conditional Formatting
XSLT List View web part is a new type of web part that lets you manipulate data in a flexible manner using SharePoint Designer. A designer can easily connect to a variety of data sources to display data as needed and also setup any required conditional formatting of data. The best part about this setup is that a member of the site who is later using this data through the browser can easily interact with the views of this data or create additional views.

Video for Configuring Rules in InfoPath 2010
Use the Rules functionality in InfoPath 2010 to apply formatting, validate data, hide controls and also execute actions. Once a Rules is implemented, it can be easily copied and reused for other fields as well. Also, the Form Load event configuration is shown in this video.

Convert System.Drawing.Color to HTML color

Simple utility code syntax for converting System.Drawing.Color to HTML color

/*

Runtime whenever you are trying to access color, it is easy to assign known colors, but if you want to assign HTML Color name runtime you can use ColorTranslator.FromHtml method instead of Color.KnownColor name.

*/

tdRecord.BackColor = System.Drawing.Color.Yellow;

tdRecord.BackColor = System.Drawing.ColorTranslator.FromHtml("#ecf5f8");

SharePoint Development Virtual Lab

A SharePoint Developer Introduction - Page Branding

After completing this lab, you will be better able to work with masterpages, work with styles sheets, create themes, and utilize features and feature stapling.

Register yourself for Sharepoint Development virtual lab

DataView.Table - Problem to Persist Sort or Filter View

I was trying to Sort data with DataView and was trying to convert Dataview to table. I have notice even though view is sorted, when you try to convert it to table it would return only default sort.

Example:

//I was trying to perform something as following

DataTable dtGrid = GetData();

DataView dvSort = new DataView(dtGrid);

dvSort.Sort = "CreationDate DESC";

dtGrid = dvSort.Table; //Will Not Persist Sort Order

In above example even though view is in sorted order, when i tried to convert it to table it would return only default view. In order to get Sorted view (Persist Sort order) instead of using DataView.Table you should use DataView.ToTable() method

So if you changed above code with following it would start working as expected.

DataTable dtGrid = GetData();

DataView dvSort = new DataView(dtGrid);

dvSort.Sort = "CreationDate DESC";

dtGrid = dvSort.ToTable(); //Persist Sort Order

Internal server error 500 while running asp.net application

I was getting "Internal server error 500" while running asp.net application.


Cause of Error Code 500
500 Internal Server Error is a general error code and does not reveal any informatino about the actual cause. You need to check the log files for more information i.e. (Event log - Eventviewer). You can also find more details for exact cause of error by disabling "Show friendly HTTP error messages" in your browser.

Solution of Error
Ones you have cause of error, solution would be simple. There could be different error for you, but for me this error was occurring because of following reason.

Event message: Unable to make the session state request to the session state server. Details: last phase='Sending request to the state server', error code=0x80072749, size of outgoing data=0

Exception type: HttpException
Exception message: Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same. If the server is on a remote machine, please ensure that it accepts remote requests by checking the value of HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\aspnet_state\Parameters\AllowRemoteConnection. If the server is on the local machine, and if the before mentioned registry value does not exist or is set to 0, then the state server connection string must use either 'localhost' or '127.0.0.1' as the server name.

Now,

After checking "Services" in Administrative tools of control panel I found that "Asp.net State Service" was not installed.

I have tried to reinstall asp.net state service again using following command.

c:\Windows\Microsoft.NET\Framework64\v2.0.50727>aspnet_regiis -i

ones asp.net state service is installed you need to start the service and change the start up type option to automatic. Finally my asp.net application started working again.

More details for Win Vista Users

If you are running into above error, than try to check following.

1. Check whether IIS is Installed on your machine? (In Run dialogbox type: Inetmgr)

To Install IIS on Win Vista.

Control Panel > Programs and Features > Turns Windows features on or off

Select Ineternet Information Services from popup dialog and press ok button.

2. Open Services and check whether "Asp.net State Service" is installed? (In Run dialogbox type: services.msc)

To install asp.net state service. run following command from your command prompt and make sure that you are pointing to correct directory.

c:\Windows\Microsoft.NET\Framework64\v2.0.50727>aspnet_regiis -i

ones asp.net state service is installed you need to start the service and change the start up type option to automatic. Finally my asp.net application started working again.

Restore failed for Server 'my-pc\sqlexpress'

Recently I have upgraded my laptop from 32 bit to 64 bit OS. Most of the thing work good except restoring of Database from my old laptop.

Following is Error I was receiving

===================================
Restore failed for Server 'my-pc\sqlexpress'. (Microsoft.SqlServer.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()
===================================

System.Data.SqlClient.SqlError: Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dailyfreecode_DATA.mdf" failed with the operating system error 5(Access is denied.).

(Microsoft.SqlServer.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)

Cause of Error

When you switch from 32 bit to 64 bit, mostly your "Program Files" folder would get changed to "Program Files (x86)" so it is obvious that path of database on old pc doesn't match on new PC and so you would get access denied error. Error is specific to incorrect path while restoring.

Note: Incase if you are creating New database, it is very less likely that you would receive this error.

Solution

Change the path of following two files to appropriate path, while restoring.

1. dbname.mdf file

2. dbname_log.ldf file

More details

Generally you would find that your database files resides in following folder (i.e. Above 2 files)

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

But with new change i found that on my PC it was trying to store on following path

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\MSSQL\Data

So after changing path appropriately i found that i could able to restore my database.