Blog of Rajesh Meenrajan - MCSD.NET /MCTS SharePoint

Whassup with SharePoint 2010 Development!

2009-10-28T10:39:00.003-04:00

Some of the key SharePoint 2010 Development Feature that I saw:

1. SharePoint Import SharePoint Solution Package Template for Visual Studio 2010: You can import and redeploy WSP packages using the this.

2. WCF & REST SERVICES support. ASMX is still supported so that migration from 2007 to 2010 for your custom web service shouldn't be a problem.

3. BDC is now BCS (Business Connectivity Services) and it is no more READ-ONLY from the LOB applications(database/web service). YOU CAN NOW WRITE to your LOB app from within SharePoint.

4. SAY NO MORE TO CAML using LINQ to SharePOint: You can use EntityList object and get your data and bind it to any control/ web part etc.

5. Deployment of WSP without FARM ADMIN intervention. For example, web parts can be created, deployed and activated in partial trust mode and you don't have to begging your Admin to deploy it in the Farm so that you can add web part on your blah blah blah site.

6. Workflows used to be at Web Application Level in 2007. Now, you can build workflow at the site-level.

7. SharePoint Object Model worked well for on the same server based solutions. But with client object model you can access data from just about anywhere.

8. Now entities(with parent child relationship) can be deleted in cascading fashion.

9. VS 2010 will be able to debug, apply breakpoints for Custom SharePoint Development.

10. Timer Job Overhauled. You can assign a timer job to any/(any number of) server in the farm. From Central Admin you can run the timer job at will( Option: Run Now). Detailed report on the job status, history as well as Progress bar showing the jobs which are running.

11. Windows SharePoint Service 3.0 is now Windows Foundation (Thanks to WCF)

And Much more to come as I explore!

HTH

Code Sample to update document & their metadata & delete document using SharePoint Web Service

2009-10-08T12:06:00.000-04:00

Microsoft has either limited documentation on this in their msdn site.

Try to have the Method ID unique. ID attribute in each “Method” element uniquely identifies the specific update so that errors and return values can be properly identified.

Note: You need to specify the Field Name ‘ID’ to delete the document as well as the URL path to the document. This you have to programmatically find and use it in the Web Service client.
Important: Make sure you do not have %20 (percentage20)replacing the whitespaces in the URL. CAML doesn’t like it.
This is INCORRECTLY documented in the Microsoft site. So be very careful and accurate in building the XML.
The returnNode.InnerText in this case resulted in HEX return value "0x000000000x000000000x00000000" for all the three updates we made through the XML markup. You may have to parse and split this string to identify whether there is a failure. For example 0x000000000x000000000x81020030 means that the first to update has passed successfully and third has failed.

HTH
Rajesh

Custom SharePoint Web Service error

2009-09-30T16:41:00.000-04:00

Error:

The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'NTLM'.The remote server returned an error: (401) Unauthorized.
If the service is defined in the current solution, try building the solution and adding the service reference again.

Analysis:

The WEb Service Consumer was built using .NET 3.5. When add service reference is used, it automagically puts in the unwanted xml security tags in the app.config/web.config. This is the culprit.

Solution:

Replace the security markup in config file as shown below:

SharePoint Security - Best Practices ???

2009-09-11T19:50:00.000-04:00

Error:

Access denied.

Build a custom multiple upload webpart. When documents with metadata was about to be uploaded sporadically access denied error occurred for certain users even when the account used is a contributor. When MOSS 2007 was released before SP2 was applied, the best practices was to run the code with RunWithElevatedPriviledges. But this doesn't work after MOSS SP2 applied. In our case, we were using Windows 2003 64-bit SP2, ASP.NET 3.5, WSS 3.0 SP2.

Solution/WorkAround:

SharePoint - Linq To SQL Can't live without App.config or Web.config

2009-08-03T16:37:00.003-04:00

I was trying to develope a SharePoint Timer Job which will be deployed as a feature. That means, the wsp file would not have a web.config or an app.config file. This means a showstopper for using Linq to SQL within SharePoint when you want the timer job to pull data from another data source other than Sharepoint. What I wanted was that the timer job should be able to get the configuration information from the web.config file and then use linq without the usage of the settings& app.config file that was generated when I "add new item"( Linq to sql classes) in the visual studio project. In order to dynamically load the connection string for the database, the configuration file should live inside the project which is not possible for a SharePoint Feature project.

This is a step back in Linq Usage within SharePoint. I heard Microsoft is building new LINQ for SharePoint functionality which might solve the problem in MOSS 2010.

SharePoint - Standard Edition error when accessing all the links under Central Administration -> Application Management

2009-07-13T15:54:00.002-04:00

SQLException while Executing the cache invalidation simple timer job. We will not abort the job, and will retry in 60 seconds: System.Data.SqlClient.SqlException: The stored procedure 'proc_ar_GetCacheInvalidationCountersWithCount' can’t be found

StackTrace:

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
System.Data.SqlClient.SqlDataReader.get_MetaData()
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior)
Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command)
Microsoft.Office.Server.ApplicationRegistry.Infrastructure.CacheInvalidationStateTracker.CheckStatus(Object stateInfo)

RESOLUTION:

Rebooting the development box solved the problem.

Nice try Microsoft....but still....bing sucks!!!

2009-06-26T21:32:00.002-04:00

Try this one if you have a blog. When I do a google search with my first and last name the my blog get listed as the first URL suggestion. I tested searching in Yahoo, Altavista, Lycos, AOL and they concurred that my blog as the first suggested link. But in bing search, not only that I lost first position in the search result, my blog was COMPLETELY AVOIDED in the search result. I wonder it because blogspot belong to google? I hope atleast in future Microsoft Bing don't bring in a biased result :)
(Please note: I'm not against Microsoft in any way as I use, build, & support Microsoft's Platforms and Products!!! I only feel that they CANNOT compete with GOOGLE in search engines). Atleast in OS business Windows we can say Windows is second to MAC but not with their search. Oh, BTW, I also say their Maps for Driving Direction is far better than any other competitors (mapquest, yahoo, google etc) as it is accurate in calculating the Travel Time. If you follow google to go to your office you may end up going late by 10 minutes ;)

SharePoint - spfield item update of Metadata properties

2009-05-02T17:06:00.000-04:00

When do you use field internal name and the display name?

You have to generally use the display name of the field in SharePoint list/document library whenever you need to update an item. Use display name when the field display name matches internalname as well as if the field display name has white spaces in it. If there are no whitespaces but the the display name is different from the internal name of the field now yes use the internal name to update the item in the list/document library.

This is aworkaround for MOSS SP2 updated systems as SharePoint is not consistent with either of the name usage. See the last few lines of the code on how to do this.
(Note additional code is required if your datatype is datetime, number etc. Here it is assumed all the metadata properties are text. In those cases use something like: properties.Add(field.Title, Convert.ToDateTime(item.Value));
properties.Add(field.InternalName, Convert.ToDateTime(item.Value));

SharePoint SDK 1.5 Update

2009-04-30T22:34:00.000-04:00

Wassup with the BDC Application Definition Editor ?
Lots of Developers (SharePoint BDC) had problems with BDC Application Definition Editor which came along with SharePoint SDK 1.3. It was buggy and it worked with SQL 2000 but not with SQL Server 2005. The problem was the Tables and Views that BDC access should be a .dbo object.

Now this seem to have been fixed in the newly named editor, Application Definition Editor. You may see while installing SharePoint SDK it would show as Version 1.4 ;)
Now, the BDC Metaman is going get a hit as this tool is what we want and its free :)

SharePoint Designer is FREE!!!!

2009-03-31T20:34:00.001-04:00

You can download from the following link:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42

SharePoint - Telerik dll copy problem - ASP.NET 3.5

2009-03-27T11:44:00.000-04:00

"Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified."

I accidently copied the older version of the Telerik from the Bin folder.

Solution:

You have to copy from the Bin35 folder

SilverLight vs JQuery in SharePoint

2009-03-27T00:13:00.001-04:00

Just like most of the so called SharePoint MVP,say Sahil Malik, I'm not so dumb to passionately follow a product and say hey thats cool :). These dumb MVP do not get involved in outright projects from scratch to finish. They just make u scratch ur head after u believed their words :). One such dumbest thing is to use SilverLight within SharePoint sites which I saw Sahil Malik was boasting of too much! These guys what they do is learn at the expenses of their clients and just walk away to another company. As an architect/developer or Senior Consultant you have to be aware of what is the smartest way to achieve the desired result using a specific

Problem:

1. You must have all users to download SilverLight to work on their browser.
2. You cannot have some of the controls in HTML and other stuffs in SilverLight. Better write everything in SilverLight. Otherwise, as a designer you may not get the layouts you want as well as problems with Z-Index.
3. Oh yeah, the learning curve is very high and though you may use SilverLight plugins nailing down bugs will give you headache. You may have to higher SilverLight person who knows nothing about SharePoint :)
4. SilverLight 1.0 -> 2.0-> 3.0 is disparate. Lots of versions and changes within 2 years. I see people who invested money on 1.0 now needs more money to upgrade to newer version.

Why JQuery?
1. Simplicity of the plugins that are available.
2. An experienced Javascript person can easily understand the code very well. No learning curve here.
3. Hey it is free and you can do minor tweak when needed.
4. Javascript has been used now for over a decade and easy to handle problems find resources to solve problem.
5. Lot of stuff SilverLight boast of, can be done with JQuery.

But, this does not mean green flag to JQuery either. JQuery is also evolving but you have more control being used to Javascript. One thing that comes to my mind is that SharePoint is not conformant to XHTML standards. This means that Microsoft Employees are still ignorant of building Tabless Master Pages, User Controls, Web Parts etc. They rely on Tables to create the layout of the Master pages/page layouts/ASPX pages. You will be in trouble in you replace all the tables tag to div in SharePoint. JQuery in this area may be a trouble.

I have built really cool sites with JQuery but there is one thing to note, the more JS script used on a page, the performance can go bad. This is because some of the free controls you get on the internet may have badly written loops which would affect you page loading time. So you have the knife in ur hand, handle it with care. Try to be creative, like rounded corner, box shadows, fish eye, tabbed pages, carousel and so on. Try to balance out what need to be accomplished in a given time, which is the best route for the best result and are there any compromise in scalability and portability? Sky is the limit for JQuery!

VSeWSS 1.3 CTP released!

2009-03-10T10:26:00.002-04:00

Now you can generate the code for the publishing sites as well. This is really cool!
Here is the download link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=B2C0B628-5CAB-48C1-8CAE-C34C1CCBDC0A&displaylang=en

UPDATE:
Screencast is found at:

http://channel9.msdn.com/posts/kirke/SharePoint-for-Developers-Part-1-Introducing-VSeWSS-13/

The Web Application at could not be found. Verify that you have typed the URL correctly.

2008-12-13T17:28:00.000-05:00

The Web Application at "http: site path " could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

Resolution:

Make sure the following are correct in your setup:

· The user has permissions to access the Windows SharePoint Services site or the SharePoint Server 2007 site through which the code iterates.

· The user is a server farm administrator.

· The user has Read and Write permissions on the content database.

· The user is a site collection administrator.

Custom SharePoint Workflow error

2008-11-17T12:08:00.002-05:00

Problem:

Value cannot be null.
System.InvalidOperationException: The event receiver context for Workflow is invalid. at Microsoft.SharePoint.SPEventReceiverDefinition.ValidContext() at Microsoft.SharePoint.SPEventReceiverDefinition.ValidReceiverFields() at Microsoft.SharePoint.SPEventReceiverDefinition.GetSqlCommandToAddEventReceivers(IList`1 erds) at Microsoft.SharePoint.Workflow.SPWinOESubscriptionService.CommitNewSubscriptions(Transaction txn, IList`1 erds)
WinWF Internal Error, terminating workflow Id# fbe7818d-a189-4b0e-bd4d-2b801715590d
Cause:

This is caused when the TaskID may not be assigned a guid correctly.

Resolution:

Assign

taskID = Guid.NewGuid();

In my case, I accidently used taskID = new Guid();

Similarly this can happen with TaskProperties, BeforeProperties, AfterProperties, CorrelationToken.

stsadm restore error "Exception from HRESULT: 0x80040E2F"

2008-10-31T15:38:00.000-04:00

stsadm: Exception from HRESULT: 0x80040E2F Callstack: at Microsoft.SharePoint.Library.SPRequest.GetAllWebsOfSite(String bstrUrl, Object& pvarWebs, Object& pvarWebIds, Object& pvarParentWebs, Object& pvarLangs, Object& pvarTitles) at Microsoft.SharePoint.SPSite.SPWebCollectionProvider.GetWebsData(String[]& strNames, String[]& strServiceRelUrls, Guid[]& guidWebIds, Int32[]& nLanguages, String[]& strTitles, String[]& strDescriptions, String[]& strCreationTimes, String[]& strModifiedTimes, Boolean[]& bUserIsWebAdmins, Int32[]& nWebTemplates, Int16[]& nProvisionConfigs, Int16[]& nMeetingCounts) at Microsoft.SharePoint.SPWebCollection.EnsureWebsData() at Microsoft.SharePoint.SPWebCollection.Undirty() at Microsoft.SharePoint.SPBaseCollection.System.Collections.IEnumerable.GetEnumerator() at Microsoft.SharePoint.Administration.SPSiteCollection.LogSiteRestoreToChangeLog(SPSite site) at Microsoft.SharePoint.Administration.SPSiteCollection.Restore(String strSiteUrl, String strFilename, Boolean bOverwrite, Boolean hostHeaderAsSiteName) at Microsoft.SharePoint.StsAdmin.SPAdminRestore.RunSiteCollectionRestore(StringDictionary keyValues) at Microsoft.SharePoint.StsAdmin.SPAdminRestore.Run(StringDictionary keyValues) at Microsoft.SharePoint.StsAdmin.SPStsAdmin.RunOperation(SPGlobalAdmin globalAdmin, String strOperation, StringDictionary keyValues, SPParamCollection pars)

Resolution:

The sharepoint backup was taken on the site when users are accessing the sites. The workaround is to take the backup from production sharepoint content database and follow the process mentioned in:
Restore from Production to a new farm

Or
You have to lock down the sharepoint database so that no user can access the site and this could cause outage of the sites.

"unable to write data to the transport connection an established connection was aborted by the software in your host machine

2008-10-30T15:12:00.001-04:00

I had a powershell script that send out an email using SMTP on remote server. I got the following error(s):

No connection could be made because the target machine actively refused it

Or

unable to write data to the transport connection an established connection was aborted by the software in your host machine

As shown in the image, unblock the "Prevent mass mailing worms from sending mail". This fixed the problem created by Mcafee. [OR] You can also click on the edit button and you can add the list of processes to excluded from this "sending mail" rule. I added gpowershell.exe and telnet.exe to this list and it worked gr8

Custom SharePoint Feedback workflow using Infopath

2008-10-22T19:38:00.002-04:00

I read books on the building custom sharepoint workflow from the MVPs and their examples are rather simple and not complex. In my case, I wanted to build a Custom InfoPath-based Feedback workflow (not the MOSS out-of-the box one) which has multiple tasks assigned to each one of the managers in the company who will in turn approve based on certain conditions. There is no one simple example out there yet. So I spent couple of days and found my solution to do the same. Nowadays, the Microsoft documentation is very very limited and they rely on these stupid MVPs and their solutions are retarded( on the MSDN sites) as they r not a really practical examples. I would show u how I built the custom SharePoint workflow( see the picture). All you need is the conditionactivitygroup, ReplicatorActivity, SequentialActivity along with the usual workflow task toolbox items.

Buzz me if you need more help on this.

MCTS - Windows Sharepoint Services 3.0 Application Development

2008-09-11T17:38:00.000-04:00

After, registering the MCTS 70-541, becose of the Second Shot Voucher from prometric, I took the test carefree and passed the exam, today. Thought for a while, that I wasted my second-shot voucher though! :) This is my first Technologist Specialist Certification since my MCSD.NET certification. Here is the link that I got for the second shot registration:
http://www.prometric.com/microsoft/2ndchance.htm?s=MCP

Use the voucher number, when you register for the test.

Good luck!

HTTP 401.1 - Unauthorized: Logon Failed - SharePoint Windows 2003 SP1 IIS 6.0 Host Header Problem

2008-08-31T12:47:00.000-04:00

Follow the rabbit and you'll be able to fix this problem:

http://support.microsoft.com/default.aspx/kb/896861

SharePoint Error

2008-08-14T13:45:00.000-04:00

File Not Found. at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at System.Web.Configuration.CompilationSection.LoadAssembly(String assemblyName, Boolean throwOnFail)
at System.Web.UI.TemplateParser.LoadAssembly(String assemblyName, Boolean throwOnFail)
at System.Web.UI.TemplateParser.AddAssemblyDependency(String assemblyName, Boolean addDependentAssemblies)
at System.Web.UI.TemplateParser.ProcessDirective(String directiveName, IDictionary directive)
at System.Web.UI.BaseTemplateParser.ProcessDirective(String directiveName, IDictionary directive)
at System.Web.UI.TemplateControlParser.ProcessDirective(String directiveName, IDictionary directive)
at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding)

In the EVENT LOGGER this is what I saw:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Web Controls
Event ID: 7043

Description:
Load control template file /_controltemplates/xxxxxx.ascx failed: Could not load file or assembly xx.xx.xxx.xxxxx, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c8ecfa5d627828fe' or one of its dependencies. The system cannot find the file specified.

RESOLUTION:

In the Visual Studio IDE, change the public key tokens to the compiled dll's token. You may encounter when importing a project from another developer and the public key token is changed etc. So, replace it all the files where the old public key token is being used. Definitely you may have to look at the manifest.xml.

Sharepoint Timer Job - System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'proc_putobject', database

2008-08-01T16:36:00.001-04:00

This error is caused mainly due to the WSS_Content_Application_Pools account that is being used when you update the timer job from your code. This account don't have the Farm Administrator priviledge which is expected and adding the account. (Note: you may go to the Task Manager, and find the w3wp.exe process that is running and see what account it has been using to figure out what was the account used to run the job.update(). Otherwise, you can also, do a SQL Trace on your Sharepoint Configuration Database and find the account used to process proc_putobject procedure).

This will solve the problem and your timer job can be updated, deleted or added.
But you may end up with the caching exception when the FeatureActivated which you may ignore as your job has run successfully.

"Exception in RefreshCache. Exception message :Access to the path 'C:Documents and Settings\All User\Application Data\Microsoft\Sharepoint\Config\e182c711-9e68-4ba8-9c55-a95a8e505752\cache.ini' is denied."

This is due to the fact that WSS_WPG has only Read Access in the above file path. When you have the Sharepoint SP1 installed make sure you do it correct. You may have to grant it Local Launch and Local Activation permissions when SP1 is installed.

Similar issue is mentioned in kbb:

http://support.microsoft.com/kb/926959

Sharepoint Event Receiver - Firing twice or may be more

2008-07-23T15:29:00.000-04:00

Problem scenario:

You have a list and it has a column which takes value from the choice you make( a dropdown). Now you want have a custom Event Receiver on this itemupdated and override the itemupdated method in your Event Handler code. What might happen in your code when the choice is selected, you have to reset to the default value of the choice. Now this will inturn fire another event that the item has been updated.

Solution:

In your event handler code, disable the event firing. Here is the snippet:

this.DisableEventFiring();
_ListItem.Update();
this.EnableEventFiring();

This would avoid event from firing when the item is updated. Again enable it, so that you fire an new event when the item has changed.

Thats my 2 cents!

GACUTIL.EXE Where is it in Visual Studio 2008?

2008-07-14T11:39:00.001-04:00

In VS 2005, I used to find it under:
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\

But, in VS 2008, I can't find it under:
C:\Program Files\Microsoft Visual Studio 9\SDK\v2.0\Bin\
or
C:\Program Files\Microsoft Visual Studio 9\SDK\v3.5\Bin\

Resolution:

Microsoft "Smart" guys came up with a very smart idea and puts it here:

C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin

Code Snippet for archiving the documents to Record Center using Record Center Web Service

2008-07-09T15:41:00.000-04:00

Here is a sample of how to do it:

RecordCenterService.RecordsRepository objRecRepository = new RecordCenterService.RecordsRepository();

objRecRepository.PreAuthenticate = true;
objRecRepository.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
objRecRepository.Url = _Global.ExportComplance_RecordCenter_Library_URL;
RecordCenterService.RecordsRepositoryProperty[] repositoryProperties = new RecordCenterService.RecordsRepositoryProperty[1];
repositoryProperties[0] = new RecordCenterService.RecordsRepositoryProperty();
repositoryProperties[0].Name = "Created By";
repositoryProperties[0].Type = "Text";
repositoryProperties[0].Value = _CertificateFormListItem["Created By"].ToString();

byte[] doc = _CertificateFormListItem.File.OpenBinary();

string resultString = objRecRepository.SubmitFile(doc, repositoryProperties,
"Export Compliance Certification Form",
_CertificateFormListItem.Url,
_CertificateFormListItem.Web.CurrentUser.LoginName);

Report Center - Archive Record Management in Sharepoint

2008-07-09T15:32:00.000-04:00

Using Sharepoint 2007 there one piece developers should be aware it configuring the Record Routing Correct in Record Center. Record Routing type has a title that has to be **EXACTLY** same as the name of the Content Type of the source Document Library.

This is a required setting that has to be done even whether you are using Sharepoint Object Model or the Record Center Web Service in your code.

How to setup search box for just Single document library

2008-07-08T15:10:00.000-04:00

Here are the steps that you need to follow:

1. Go to "Site Actions"->"Site Settings" ->under "Site Collection Administration"
-> "Search Scopes".

2. Click on "New Scope" and fill in a title name. Try to use the same name of the Document library to be consistent. Click "OK"

3. Next you are going to add a new rule. Copy the URL of your document library the document library you wish to search. Your Site Collection > Site Settings > Scopes
-> under the "Rules" section click on "New Rule". Select "Web Address" and paste the URL of your document library. Click "OK".

4. Your Site Collection > Site Settings > Scopes > Click on "New Display Group" and provide a title name, preferably your doc lib name. In the "Scopes" section select the scope you created in Step 2 and hit OK. Now, the server will start recognizing the new scope and the display group, so wait until it gets completed.

5. ON the page where you want the search to be done on the document library, from Site Actions->Edit Page -> Add a Web Part. Check the "Search Box" web part and click "Add".

6. In the page edit mode, under the "Search Box" web part click on the "edit" -> "Modified Shared Web Part".

7. Under "Miscellaneous" -> uncheck "Use site level defaults". Under "Scope Display Group" in the text box give "exactly" the same name that you used in 4 and then hit OK.
8. Exit Edit Mode.

Steps to cleanup orphaned sites in Sharepoint 2007

2008-06-23T17:43:00.001-04:00

stsadm -o databaserepair -url -databasename WSS_Content_d4c3181eded14166b2df2ed59d06825d

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o enumsites -url http://vmvsp14spdev7:47227/sites

se="WSS_Content_d4c3181eded14166b2df2ed59d06825d" StorageUsedMB="2.7" StorageWar
ningMB="0" StorageMaxMB="0" />
wner="CTNTMASTER\u04476" ContentDatabase="WSS_Content_d4c3181eded14166b2df2ed59d
06825d" StorageUsedMB="0.2" StorageWarningMB="0" StorageMaxMB="0" />
"0.4" StorageWarningMB="80" StorageMaxMB="100" />
"0.4" StorageWarningMB="80" StorageMaxMB="100" />
"0.4" StorageWarningMB="80" StorageMaxMB="100" />
ageUsedMB="0.1" StorageWarningMB="0" StorageMaxMB="0" />

xMB="0" />
ondaryOwner="CTNTMASTER\u24065" ContentDatabase="WSS_Content_d4c3181eded14166b2d
f2ed59d06825d" StorageUsedMB="228" StorageWarningMB="0" StorageMaxMB="0" />

sedMB="20.2" StorageWarningMB="0" StorageMaxMB="0" />
"426.9" StorageWarningMB="0" StorageMaxMB="0" />

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o preparetomove -ContentDB vmvsp14spdev7:WSS_Content_d4c3181eded14166b2df2ed
59d06825d -Site http://vmvsp14spdev7:47227/sites/InternationalHint

Operation completed successfully.

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o deletecontentdb -url -d
atabaseserver vmvsp14spdev7 -databasename WSS_Content_d4c3181eded14166b2df2ed59d
06825d

Operation completed successfully.

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o addcontentdb -url -data
baseserver vmvsp14spdev7 -databasename WSS_Content_d4c3181eded14166b2df2ed59d068
25d

Operation completed successfully.

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o restore -url -filename
%BAK_FILEPATH%

Operation completed successfully.

Provisioning Site Pages Problem on WSS Sites

2008-06-11T01:08:00.000-04:00

I got the following problem when deploying a solution in SharePoint:

Code-blocks are not allowed in this file.

Solution:

What this means is that the aspx you may have been trying to add to the site has the scripts that may execute when the page is requested. So in order to allow those server-side scripts to execute you have to edit the web.config of the web application. In the web.config file look for the tag SharePoint and then the tag PageParserPath :

<PageParserPath VirtualPath="/pages/test.aspx" CompilationMode="Always" AllowServerSideScript="true" />

Feature Stapling for your Site Definition

2008-04-27T12:27:00.000-04:00

What is Feature Stapling?

You develope bunch of features. You want to run multiple sites that run with either out-of-the-box Site Definition or your own custom Site Definition. Now, you want to associate a bunch of features to all these multiple sites. It's tedious process to go and update each one of the site collections that you have created with the new features which is a overkill( even though you may use STSADM command). If it is a Custom Site Definition you can directly have the Features listed in the SiteFeatures and WebFeatures tag of your Onet.xml file. But, what abt say out of the box Site Definitions or cases where you do not want features directly associated in your custom site definition. Now there is a concept of Feature Stapling where you create a Feature and associate all the features you want to be attached to your site definition. To do this, in your element Manifest file you will have the have the tag FeatureSiteTemplateAssociation Id=YourFeatureGUID TemplateName="YourSiteDefinitionName#ConfigurationIDSetInYourSiteDefinition"

ConfigurationIDSetInYourSiteDefinition is a number that you set in your Site Definition usually 0,1,2,3 based on default site, blog, wiki that you may define on your custom site definition.

VERY VERY IMPORTANT:
If you already have that is using the Site Definition what if a do a feature stapling now? It wont work.
It would work for subsequent sites that will be newly created. To workaround to make the features to work you have to stsadm command to install those missing features separately.
So what is the advantage here: If you add those features within the Site Definition(SiteFeatures & WebFeatures) then you cannot deactivate them as they are part of the site definition. If it a feature stapled feature, yes you can deactivate some and activate some depending on your needs and your customization.

Code Snippet: Using Sharepoint OM to archive documents to Record Center based on Status - Complete

2008-04-02T15:51:00.000-04:00

SPList _CertificateList = _Web.Lists[new Guid(_Global.ExportCompliance_CertificateForm_GUID)];

foreach (SPListItem _CertificateFormListItem in _CertificateList.Items)
{
string Status = _CertificateFormListItem["Status"].ToString();

if (Status != null && Status == "Complete")
{
//Archive the Document to the record center.

SPDocumentLibrary doclib = _Web.Lists[new Guid(_Global.ExportCompliance_CertificateForm_GUID)] as SPDocumentLibrary;

SPFile objSPFile = doclib.GetItemByUniqueId(_CertificateFormListItem.UniqueId).File;

string resultString;
retString = objSPFile.SendToOfficialFile(out resultString);

if (retString == OfficialFileResult.Success)
{
//Now delete the document from the source (export compliance) library

_CertificateFormListItem.Delete();

}

//EventLog.WriteEntry("Application", " writing the file to the file path mentioned\n");

//Delete the document from this library as it is archived.
}

Comparision of Sharepoint - Reporting Services Native & Integration Mode

2008-02-05T17:32:00.000-05:00

Native Mode:

* You have the advantage of creating linked reports, sub reports
* You can have both time driven as well as data driven subscription working
* Report Manager is accessible
* Reports are deployed in Report Server

Integration Mode:

* Data Driven subscription is not supported.
* Report Library is a possible which helps in managing reports within Sharepoint and hence you don't have to go separately to Report Server to manage reports
* Manage subscriptions within Sharepoint Server
* Report Manager will be disabled and wont work

These are some of the salient features that you have to remember before you decide which mode you have to deploy Reporting Services for Sharepoint Integration.

SharePoint List WEB Service GetListItems -bug

2008-01-28T10:17:00.000-05:00

Problem:

According to http://msdn.microsoft.com/en-us/library/lists.lists.getlistitems.aspx
A ViewFields element that specifies which fields to return in the query and in what order, and that can be assigned to a System.Xml.XmlNode object.

But it returns all the items in the XML format. This is a bug...
Also, I hate the way the fields are renamed to ows_fieldName.. It is not easy to use the web service to extract the data as this may require lots of parsing.

Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B) (rsRPCError)

2008-01-27T11:04:00.000-05:00

This error means that your Reporting Servers configuration for the Encryption key has been messed up. From the Reporting Server Configuration Manager you have to restore the encryption key. If you have lost it( it is always good to have a backup) then you may have to delete those databases(reportserver & reportservertempdb). Then you have to delete the reportserver and reports site on IIS. Then you have to start over the configuration again.

No webtemp configuration for sitedefinition 'CustomSiteDefinition' was found.

2008-01-26T22:29:00.000-05:00

I was using WSPBuilder to build a custom Site Definition. I got the following error:

No webtemp configuration for sitedefinition 'CustomSiteDefinition' was found.

Reasons:

I had a typo on the WEBTEMP*.xml. This file has to match with the site template name

For example in your
if you specify the Template Name as CustSiteDef, then you webtemp xml file( found under Template\1033\XML) should have to be WEBTEMPCustSiteDef.xml

Make 100% sure that there is no typo.

LINQ Deferred & Immediate Execution - Interesting Features

2008-01-07T22:22:00.000-05:00

Look at the following code for Deferred Execution:

// Sequence operators form first-class queries that
// are not executed until you enumerate over them.

int[] numbers = new int[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };

int i = 0;
var q =
from n in numbers
select ++i;

// Note, the local variable 'i' is not incremented
// until each element is evaluated (as a side-effect):
foreach (var v in q) {
Console.WriteLine("v = {0}, i = {1}", v, i);
}
}

Immediate Execution:

// Methods like ToList() cause the query to be
// executed immediately, caching the results.

int[] numbers = new int[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };

int i = 0;
var q = (
from n in numbers
select ++i )
.ToList();

// The local variable i has already been fully
// incremented before we iterate the results:
foreach (var v in q) {
Console.WriteLine("v = {0}, i = {1}", v, i);
}

//The value of i will be always 10 when it is written to console

The evaluation version of Microsoft Office SharePoint Server 2007 for this server has expired.

2007-12-16T16:10:00.000-05:00

You have Enterprise Version of MOSS and still get this error. There would be nothing that is in SharePoint Log or Event Log. So what was the problem. WSS_Admin_WPG & WSS_WPG should include both the Application Pool identity of SSP site should be added to these Group.

Then machine sure your registry path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0 has rights for the WSS_Admin_WPG & WSS_WPG.

Form Authentication in MOSS 2007 & WSS 3.0

2007-12-15T19:13:00.000-05:00

Microsoft has recently released a "CLEAR" documentation how to use Form authentication in Sharepoint sites:

Here are the following links:

Form Authentication MOSS 2007 - Part 1

Form Authentication MOSS 2007 - Part 2

Form Authentication MOSS 2007 - Part 3

'Edit Document' requires a Windows SharePoint Services-compatible application

2007-12-03T16:21:00.000-05:00

When you edit an Microsoft Office document in a document library you end up with an error:

"'Edit Document' requires a Windows SharePoint Services-compatible application"

Solution:

http://support.microsoft.com/kb/833714

Infopath Publish Form Template Error: "The following URL is not Valid"

2007-11-24T13:41:00.000-05:00

Problem:

Whenever you publish a form (knowingly or unknownly) you need to have a root site at the web application level. If you have a site collection say:

http://yourserverName/sites/TestInfopath

Then you should have a root site that need to be existing as:

http://yourserverName/

If this is not existing then, when you publish the form template to the above sample site collection, you will end up seeing the following error message that makes you feel nuts!

"The following URL is not valid: http://yourserverName/sites/TestInfopath"

To create the site:
Go to Central Administration -> Application Management -> Create Site Collection -> Web Site Address -> (LEAVE IT EMPTY)

This will create you the root site.

Now try again publishing, viola, you would see the error message is gone!

I hope I saved you some Development time a you owe me one :)

Process Oriented Developement with MOSS 2007

2007-11-10T19:49:00.000-05:00

Is it possible to use MOSS 2007 with Process Oriented Developement strategy. Very few people understand about this as we have Developers who gives to code to QA and then finally deploying the build in Production. Currently I have scene bad architecture when people deploy Sharepoint in their company. Everything is applied in production. When you use, Form Services & Sharepoint Designer you don't know what the developer is deploying in Production.

I use a different strategy. I use Features and solutions (wsp) to deploy whatever the change that is required in Production. I have a development environment in VM which I test and our QA does the same in QA environment before it is being applied to the Production.

The following is the links for how to use Features and Solutions to achieve this:

Solutions

Features

Interprocess communication in .NET 3.0

2007-10-05T19:34:00.000-04:00

With version 2.0 I have to have 2 channels (ipcchannel/tcpChannel) to have to bidirectional communication between two applications. With Version 3.0 now I could use one channel for bidirectional communication. I have code developed in VS 2008 Beta. I'll post my code sample written in C# if you require.

Stumped by Sharepoint Document Library BUG - Additional Column Settings with Default Value

2007-09-30T16:50:00.000-04:00

I was stumped today by a wierd behavior of Sharepoint when a new Document is added to the Document Library. In my scenario, for my content type, I have a Choice Column which has the Additional Column Settings to take a default value when it is found empty during submission of the document. But, when a value for the column is provided during the submission of the document, the default value overrides the submitted value and hence the problem.

This is a problem with the current version of WSS 3.0. There is no fix, but there is a workaround:

Instead of creating a new document by going to Document Library -> New, create the document first on your location machine. Then, Upload the document to the document library. This will eliminate the default value problem.

For more information follow the KBB:

http://support.microsoft.com/kb/932922/en-us

Sharepoint Scope of a Timer Job

2007-08-28T16:38:00.001-04:00

Problem:

Element of type 'Receivers'are not supported at the 'Site' Scope'. This feature could not be installed.

Solution:

If you are creating a custom WSS timer job, you need make sure that you have to deploy the Feature either at the Farm Level or at the WebApplication level as the phrase time schedule applies to all the Web Sites on a particular Web Application. Otherwise, the feature though activated, will not add the entry to the Timer Job Definition.

Thatz my 2 cents!

FileNet Repository Session

2007-07-07T21:56:00.000-04:00

FileNet Capture professional session can be created only once. I was creating a Multithreaded application that process, fax email messages, create, Link and lock batches and inject documents into workflow queue and sents alert message. The way I have architectured the C# windows solution was to have one thread that handles all the filenet related connections and rest of the other threads doing jobs other than related to FileNet Capture & IDM Desktop. Make sure you use STA thread that connects to FileNet Repositories and sessions.

SharePoint OM - fun stuff

2007-07-04T16:36:00.000-04:00

How can I create a SiteCollection using SharePoint Object Model?
(Note: I assume you run this piece of code as admin)

Creating a Site Collection:

//SharePoint OM method
SPSite site = new SPSite(strServerPath);
SPSiteCollection siteCollection = site.WebApplication.Sites;
// one = Site url
// two = Title
// three = Description
// four = Web template
// five = Owner login
// six = Owner name
// seven = Owner email
siteCollection.Add(one,two,three, 1033, four,five, six, seven);

OR

//Sharepoint Web Service Method
AdminService.Admin objAdmin = new AdminService.Admin();
objAdmin.Credentials = System.Net.CredentialCache.DefaultCredentials;
objAdmin.CreateSite((YOURSiteCollPath + ("/" + YOURSiteName)),YOURTitle,
YOURDescription,1033,
YOURTemplate,
YOUROwnerLogin,
YOUROwnerName,
YOUROwnerEmail,
"", "");

Note: add the following webservices:
http://YOURSeRVERName:[central admin sites port]/_vti_adm/Admin.asmx
http://YOURSERVERName:[web app site port]/_vti_bin/Sites.asmx

Creating a site:

//using OM

SPSite site = new SPSite(strSitePath);
// Add the new site (web)
// ----------------------
// Step 3: Add the site collection
// one = Site collection url
// two = Site (web) url
// three = Title
// four = Description
// five = Template
SPWeb web = site.AllWebs.Add(
two,
three,
four,
(uint)1033,
five,
false,
false);

OR

using SharePoint Web Services:

MyWebService.Service objWebService
= new MYWebService.Service();
objWebService.Credentials = System.Net.CredentialCache.DefaultCredentials;
objWebService.CreateWeb(
YOURSiteCollPath,
YOURWebName,
YOURTitle,
YOURDescription,
YOURTemplate);

MyWebService is http://YOURServerName:[web app sites port]/_vti_bin/Sites.asmx

FileNet & Multithreading

2007-06-06T19:43:00.000-04:00

When I called FileNet support, they said they can't suport .NET Multithreading in FileNet Panagon Capture 3.3 and FileNet Imaging Services 4.2. They started marketing me FileNet Web Services. I have used STA thread instead of MTA thread and it worked like a charm and I have replaced the custom VB 6.0 with my C# application which process fax, email messages and creates image files to inject into the Workflow queue.

Thats my 2 cents....

Rajesh MCSD.NET

How to remove Web parts that Creates Error on a Page in WSS 3.0 / WSS 2.0

2007-05-10T13:58:00.000-04:00

Example Error Message: An unexpected error has occurred

Resolution:
On the browser URL, say you are in default.aspx page, then add "?Contents=1" after default.aspx and you will be redirected to the Web Part Maintenance page. Select the offending web part and then delete it.

You page is now safe ;)

Sharepoint Error: Sql Reporting Services to Native Mode from Integration Mode

2007-05-05T19:02:00.000-04:00

The following parser error occured to me:

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.

The reason being is that web.config file of the web application is not updated when you revert back to native mode.
Look for the sessionState tag and partitionResolverType option empty instead of "Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server".

This would fix the problem. The rollback doesn't take care of this.

Running Side by side VS 2K3 & 2K5 -"Error while trying to run project: Unable to start debugging on the web server "

2007-02-01T11:51:00.000-05:00

This is because IIS targets ASP.NET Version 2.0 by default, even for VS.NET 2003 projects.

Open your Internet Information Services manager->[your machine]->Web Sites-> Default Web Site node ->virtual folder of your web project. Right Click on it -> select Properties ->select the ASP.NET tab page. Make sure the correct version ASP.NET Version is selected from the dropdown in my case it was 1.1.4322.

HTH
Rajesh MCSD.NET

Replacing MS FrontPage 2K3 with MS Expression Studio

2007-01-12T12:06:00.000-05:00

Microsoft has introduced their new version of Front Page ( though they claim it is totally a different product) for developing web & windows based application. Yes, this is an more advanced and sophisticated product than Front Page as it is a suite of tools for professional designers building web and Windows client applications and rich media content.

You can try the trial version on Windows XP sp2:

Windows XP SP2:

1. Uninstall all previous versions of Windows Presentation Foundation, Windows Communication Foundation, MSXML 6.0 and SDK, and Expression Blend (or Interactive Designer) using Add/Remove Programs in Control Panel.
2. Please be sure to install .NET Framework 3.0 first before attempting to install Expression Blend.
3. Download and install Expression Blend.

The product is expected to be out by June 2007. All you can try now is their trial version.

HTH
Rajesh MCSD.NET

ASP.NET SQL Membership provider error on the dev box

2007-01-09T17:30:00.000-05:00

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\MY DOCUMENTS\VISUAL STUDIO 2005\WEBSITES\WEBSITE1\APP_DATA\ASPNETDB_TMP.MDF' because it already exists. Change the file path or the file name, and retry the operation. Creating the ASPNETDB_xxxxxxxxxxxxxxxx database...

Solution:
---------
Under your APP_DATA folder delete the aspnetdb.mdf that has been created. Now, retry ASP.NET Web Administrator Tool again then you should be able to get this working.

Connection String problem with asp.net security web administration tool

2006-12-14T19:42:00.000-05:00

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

Solution:
---------
ON the web ccnfig of you web app add the following connection string

add name="ASPNetDB" connectionstring="server=serverName;database=aspnetdb;Trusted_Connection=True"

Your source control provider does not support checking out while disconnected from the server.

2006-10-04T11:21:00.000-04:00

One of the problem you may encounter is that sometimes your network drives are not mapped correctly. You may have been asked to work in disconnected mode for the code which is in source safe. The problem with this is that you have get it connected to the source safe once the network is available.

To do this you do the following in VS.NET:

File > Source Control > Change Source Control and check all the checkboxes in the Connected column

HTH
RAjesh MCSD.NET

Setup Project for Windows Service running under domain account

2006-10-03T09:00:00.000-04:00

I got this diverting error message.

"Unable to create an instance of the 'MyProjectInstaller' installer type. -> Exception has been thrown by the target of an invocation. -> Object reference not set to an instance of an object."

Solution:

If the Windows service is going to run under a domain account, add that account as an administrator of the machine first. Then run the installer msi.

Exposing .NET Components to COM Applications

2006-09-26T12:30:00.000-04:00

One of the important note that has to be considered is that OVERLOADING is not supported by COM Interface when you develope COM Callable Wrapper for your .NET component. For example:

*********************************************************
[Guid("E7EFEE62-2C34-4cc1-9898-ECAE5CE7A1F8")]
[InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
public interface _IWeightFinderInterface
{
[DispId(2)]
int GetWeight();

[DispId(1)]
int GetWeight(string ipAddress, int portNum);
}

[ClassInterface(ClassInterfaceType.None)]
[Guid("34AB57D8-87C4-4c46-8D52-7F9E1108BA27")]
[ProgId("LantronixWeightReceiver.WeightFinder")]
public class WeightFinder : _IWeightFinderInterface
{

**************************************************************

In the above snippet, you see only the GetWeight Method with arguments in the COM interface and the GetWeight Method with no argument is skipped. This is based on the minimum value of the DispId. The rest of the overloaded methods are skipped.

Only one instance of a ScriptManager can be added to the page.

2006-08-22T10:32:00.000-04:00

Reason:

Each Web page can contain only one ScriptManager control, either directly on the page itself or indirectly inside a nested component. ScriptManagerProxy enables you to add scripts and services to content pages and user controls, where the page they are on already has a ScriptManager control.

Solution:

Using the ScriptManagerProxy control, you can only add to (not remove) the scripts and services defined by the ScriptManager control. If you do not want to include specific scripts and services on every page that includes a particular ScriptManager control, remove them from the ScriptManager control and add them to individual pages using ScriptManagerProxy instead.

Note: The above is AS-IS from the Microsoft Atlas Pre-release documentation.

VS .NET 2005 - Custom Toolbox Items and tabs disappear after restarting VS .NET

2006-08-15T13:20:00.000-04:00

Go to:

C:\Document and Settings\MY ALIAS FOLDER NAME HERE\Local Settings\Application Data\Microsoft\VisualStudio\8.0, there should be four files with the extension .tbd.

Note: In case you are working with VS.NET 2003 then the path is same as above except replace 7.1 instead of 8.0.

In these files, the settings are overwritten everytime VS.NET is shutdown. So check the modified date on toolbox.tbd file. It should be modified every time when Visual studio is shutdown.

Solution:

Make sure Visual studio is not running. Check if the toolbox.tbd file modification date is less than the last time you shut down VS.NET. If so, delete all four files in the above mentioned folder and then restart VS.NET.

Happy Programming!

HTH
Rajesh MCSD.NET

ATLAS - Assertion Failed: Could not find an html element with ID "Panel4" for control type

2006-08-07T12:10:00.000-04:00

Here is the Assertion Message:
Assertion Failed: Could not find an HTML element with ID "Panel4" for control of type "Sys.UI.Control

Break into debugger?

Solution:

This is caused Panel4's Visible property is set to false.

HTH
Rajesh MCSD.NET

ATLAS control Toolkit - Warning Message - The 'requirePermission' attribute

2006-08-03T12:02:00.000-04:00

Warning Message:
The 'requirePermission' attribute is not declared.

Reporting on .NET Framework 2.0.50727.60406

Resolution:

In the webconfig file, you have to punch in the following in the configuration tag:

xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"

Leading Zeros stripped -off when opening CSV file in Excel

2006-07-28T10:06:00.000-04:00

This one got me off when I was automating CSV file generation when exporting data from the SQL Server tables. The problem was Excel upon opening the file strips-off the leading zeros. Then I have to use apostrophe preceding the leading zeros.
That fixed the issue.

There is a KBB on this:

http://support.microsoft.com/kb/214233

HTH
Rajesh MCSD.NET

UNC Paths are not supported. Defaulting to windows directory.

2006-07-25T13:55:00.000-04:00

Command run through command prompt (cmd.exe) does not support UNC path.
This got to happen with all the versions below:

• Microsoft Windows XP Home Edition
• Microsoft Windows XP Professional
• Microsoft Windows 2000 Server
• Microsoft Windows NT Workstation 4.0 Developer Edition
• Microsoft Windows NT Server 4.0 Standard Edition

A workaround is to edit the registry key DisableUNCCheck REG_DWORD suggested in the KBB:

http://support.microsoft.com/?kbid=156276

HTH
Rajesh MCSD.NET

Use prefix N when dealing with Unicode string constants SQL Server 7.0 - 2005

2006-06-12T10:14:00.000-04:00

See the link for more info:

http://support.microsoft.com/?kbid=239530

http://msdn2.microsoft.com/en-us/library/ms180059(SQL.90).aspx

This is very useful when using Sql Server to save spanish text etc.

changing the Default log files location in Reporting Services SQL 2005

2006-06-09T14:41:00.000-04:00

How to change the reporting services logfiles location from the default location:
The default location is :
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

The following configuration files have to be edited:

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\web.config,
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\web.config and
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\ReportingServicesService.exe.config

Add the following line in the RSTrace section of the above mentioned configuration files:

add name="Directory" value="D:\Wherever You Want"

We should document this in release documentation, if we are changing in production.

Because, this information will get wiped out, if we reinstall reporting services in production.

And E-Delivery should know where we are logging, incase we are debugging.

2006-06-07T08:43:00.000-04:00

What are Gadgets? Gadgets are a new category of mini-application designed to provide information, useful lookup, or enhance an application or service on your Windows PC or the Web.

Download Windows Live Gadgets SDK at:

http://microsoftgadgets.com/livesdk/index.htm

How to create a gadget for Windows Sidebar for use in Microsoft Windows Vista Beta 2?

http://microsoftgadgets.com/Sidebar/DevelopmentOverview.aspx

Like I said earlier, "Microsoft are good followers not innovators". How about their competitors say:

http://widgets.yahoo.com/
http://www.apple.com/downloads/dashboard/
http://www.desktopx.net

I just remember reading the article in mac daily news stating "Redmond, Start your photocopiers". see that:
http://macdailynews.com/index.php/weblog/comments/6887/

ASP.NET 2.0- Getting rid of DataGrid and bringing in Gridview

2006-06-07T08:01:00.000-04:00

Gridview has paved way for writting less and efficient code in ASP.NET 2.0. DataGrid can only bind to a data source object for the purpose of reading data. To actually modify the underlying data source, some user-defined code is still required. In contrast, the GridView control takes advantage of the capabilities of the underlying data source and automatically deletes or updates records. Note that the GridView control also supports the classic binding mechanism based on the DataSource property and the DataBind method. Although fully supported, this programming practice is discouraged.

Also, it is good to note that, we can render a grid inside another grid which I think is a cool feature to have.

For more information on this see:

http://msdn.microsoft.com/msdnmag/issues/04/08/GridView/

Difference between singleton & static class in C#

2006-05-31T22:34:00.000-04:00

In C#, Singleton class as the name implies creates only one instance of the class and its member, whereas, static class creates a new instance of the static members everytime it is being accessed. Follow the following link for more information:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpatterns/html/ImpSingletonInCsharp.asp

Data Driven Subscription in Sql Server 2005/2000 Reporting Services – bug or a feature?

2006-05-09T15:20:00.000-04:00

I had been recently working with the Reporting Services, Data Driven subscriptions. I wanted to users to subscribe the reports to a schedule and delivered it to their email address. What I saw was whenever the subscription query returned no row, email delivery failed with the following exception:

Failure sending mail: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.
This is because, data driven subscription is incapable of sending email with empty report.
So what is the workaround for this, as users expect reports delivered to them, say weekly.

One way, is to not to return empty rows. Possibly, the query can be written in a way that it returns a dummy row, warning that, “There is no row in the report blah blah blah…” Create a new dataset for the report, which will check the condition whether the query results is empty. Microsoft support’s workaround was to use to use SP_Start_Job to start the report from a stored procedure or a DTS in 2005 or a SQL Server Integration Services which is Microsoft's ETL platform.

Another, incapability I came across was that you can subscribe to or distribute only one report at a time. That means, we cannot create a subscription that delivers multiple reports in a single e-mail message.

Sql Server 2000 and 2005 side-by-side install without stepping on earlier version of reporting services

2006-04-27T08:59:00.000-04:00

This is common scenario in developement environment where you want to run both versions of reporting services (2000 and 2005) on the same machine. This can be done by creating a new named instance for SQL Server 2005, it doesn't use the MSSQLSERVER (one and only default instance) which comes with SQL 2000. In Sql 2005 you have the feature of running multiple-named instances of the 2005 server. So when you run the setup while installing SQL Server 2005 Specify a unique instance name on the Instance Name page( except default and MSSQLSERVER). After this,in the SQL Server Installation wizard, On the 'Report Server Installation Options' page select the 'Install but do not configure' option after specifying a file-only installation for the report server.

HTH
Rajesh Meenrajan MCSD.NET

QueryInterface for interface DTS.CustomTask failed"

2006-03-22T16:35:00.000-05:00

Resolution:

Apply Sql Server 2000 SP3a which will fix the problem. ( Sql Server 2K only)

HTH
Rajesh MCSD.NET

Build new dev machine created problem with Report Designer

2006-03-01T16:07:00.000-05:00

I was building a dev machine from scratch and the application was using Reporting Services. I created custom assembly for reporting services and I created a dll which I was referring in each one of the reports. I had the dll referenced under
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin folder and reporting services didn't like it. It started giving out error:

Error while loading code module: ‘MyDllNameHere, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: File or assembly name MyDllNameHere, or one of its dependencies, was not found.

How I made it to work:

I put an additional copy under
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer folder.

Voila, it worked like a charm afterward.
But, according to Microsoft documentation at:

http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_prog_rdl_8mue.asp

installing the dll under

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin folder should work. I donno what went wrong. If anyone who was facing the same
lemme know.

I have SQL 2K reporting services with SP1, installed on Windows XP Professional version with SP2.

Thatz about it!

Man Windows Vista look and feel like "Mac OS X"

2006-02-22T23:30:00.000-05:00

I'm unsure why Microsoft copycat Mac OS in many features. Best one is the sliders where you drag and drop shortcuts in Mac has been very well brought into windows Vista as well(;)). I love Microsoft but, sometimes Im little angry at them for being a followers and not a leader. Most of the time, Microsoft success is, their Market analysis of what goes well with the Market. Microsoft hires people who are innovative in their thinking( like they say, "think outta the box"). But, the end product doesn't seem to be of any innovation. Thatz my honest opinion.

Also, like how Apple gives codenames (feline names like panther, jaguar, tiger, cheetah) now Microsoft might follow some sort of codenames. And with Vista, they want to grab the attention of Users who is a big fan of MAC OS X which is far more reliable and stable than Microsofts OSs.

But I welcome Microsoft Next step in the world of computing!

See for more info about Windows Vista at:

http://www.microsoft.com/windowsvista/

DateTime and DBNULL.Value

2006-02-15T15:19:00.000-05:00

Problem:

An unhandled exception of type 'System.Data.SqlTypes.SqlTypeException'
occurred in system.data.dll

Additional information: SqlDateTime overflow. Must be between 1/1/1753
12:00:00 AM and 12/31/9999 11:59:59 PM

Solution:

You may be assigning null values in the datetime field. Try assigning DBNull.Value
to the datetime field. If this doesn't fixt it, you may have to see if the database table has the field set to allow null values.

HTH
Rajesh MCSD.NET

Logon failure: unknown user name or bad password.

2006-02-07T09:28:00.000-05:00

Logon failure: unknown user name or bad password.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.IOException: Logon failure: unknown user name or bad password.

Solution:

Your access to certain file path on the network would be based on the domain account.

You may have to set the identity impersonation property to true in your web or application config file.
Also, you can enable impersonation for specific identity.

For more info follow the rabbit:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconImpersonation.asp

HTH
Rajesh MCSD.NET

how to move reporting services database from one machine to another

2006-01-11T14:44:00.000-05:00

Follow the rabbit:

http://support.microsoft.com/default.aspx?scid=kb;en-us;842425

HTH
Rajesh MCSD.NET

Taskbar disabled - Enable it

2006-01-05T23:19:00.000-05:00

You may have to see if the registry entry is disabled(1).

In registry editor and make the value as 0:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies \System
Name: DisableTaskMgr
Type: REG_DWORD

HTH
Rajesh MCSD.NET

bug with multidimensional XML data (VS.NET) is bugging me!

2006-01-04T14:54:00.000-05:00

I was stumped with the error message:

The same table(NodeArgs) cannot be the child table in two nested relations.

.NET XML framework doesn't support XML 1.0 standard ( by W3C) completely.

Here is the microsoft support document:

http://support.microsoft.com/kb/325696/EN-US/

http://support.microsoft.com/default.aspx?scid=kb;en-us;325695

HTH
Rajesh MCSD.NET

Good links that take you to XAML

2005-12-29T16:04:00.000-05:00

XAMLON some nice examples how it works. Its really cool after you see the examples there:

http://www.xamlon.com/whatisxaml.aspx
http://www.xaml.net/
http://msdn.microsoft.com/msdnmag/issues/04/01/Avalon/
http://www.ondotnet.com/pub/a/dotnet/2004/01/19/longhorn.html

http://www.codeproject.com/dotnet/xamlresources.asp

Elegant Coding in C# - Tip Of the Day

2005-12-16T10:00:00.000-05:00

How to reset the controls? Most of the coders just make it empty like assigning empty string to the textboxes. Elegant way of doing this is to use GetType() method for controls in the form.

Here is the snippet:

Control myForm=Page.FindControl("YourFormNameGoesHere");//find controls in the active webform.
foreach(Control ctl in myForm.Controls)//loop thru' each control.
{
if(ctl.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))//Check whether it is a text box and clear if textbox.
((TextBox)ctl).Text="";
}

Thats my 2 cents of the day.....

HTH
Rajesh MCSD.Net

Sql server 2000 error message " does not match with a table name or alias name used in the query."

2005-12-15T11:51:00.000-05:00

This has been fixed in the latest service pack.

see
http://support.microsoft.com/kb/825019

HTH
Rajesh
MCSD.NET

WaitAll for multiple handles on an STA thread is not supported

2005-12-12T14:40:00.000-05:00

This error popped up when I writing a console application. I was using VS IDE for .net. The reason behind this is that my app main method is running under Single-threaded Apartment. VS IDE's putting the autogenerated code attribute on top of the main method.

The moment I removed that, I got it working :)

HTH
Rajesh

After Hyperthreading now intel pushes for Multi-core Processing

2005-12-08T10:19:00.000-05:00

A multi-core processor has two or more “execution cores,” or computational elements, within a single processor. The operating system perceives each of its execution cores as a discrete processor, with all of the associated execution resources. Intel multi-core architecture delivers—with appropriate software—fully parallel execution of multiple software threads.

More info at:

http://www.intel.com/cd/ids/developer/asmo-na/eng/strategy/multicore/index.htm

http://www.intel.com/business/bss/products/hyperthreading/index.htm

"Invalid mail attachment" at System.Web.Mail.MailAttachment.VerifyFile()

2005-12-06T10:56:00.000-05:00

Solution:

On your web page within the form set the attribute,

enctype = "Multipart/form-data"

HTH
Rajesh
MCSD.NET

"A potentially dangerous Request.Form value was detected from the client" error message with ASP.NET error message

2005-12-06T10:43:00.000-05:00

Solution:

At the page directive of your page insert validateRequest="false" so that it would affect only that page. If you apply it in web.config then the entire web application will be affected.

HTH

Reporting Services - Report Manager- Required Permissions cannot be acquired

2005-11-30T10:45:00.000-05:00

Solution:
This is for Custom security only.

This is mostly due to your IIS setting. Go to the virtual directory for Reports/Reportserver and set the anonymous access to true by checking it. (Right click context menu, select properties, select Directory security tab, edit authentication and access control).

Before that check whether you have installed SP1 for reporting services.

HTH
Rajesh
MCSD.NET

Reinstall Reporting Services problem

2005-11-29T11:41:00.000-05:00

I reinstalled reporting services on my machine and I have create a dummy database and then later on point it to the report server DB which was configured earlier using rsconfig file.

Then I got the following error:

The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.51'. The expected
version is 'C.0.6.43'. To continue, update the version of the report server
database and verify access rights. (rsInvalidReportServerDatabase)

Applying Reporting Services SP1 lead to:

The report server installation is not initialized. Check the documentation for more information.

Run the rsactivate utility to activate the report server. For more information about activating a report server and running this utility, see Books Online. Additional information is also available in Microsoft Knowledge Base article 834304.

If the error persists, ensure that the ReportServer Windows service is running and that the report server can connect to the report server database, and then activate the report server. You can further troubleshoot the problem by examining the reportserverservice.log files, located by default in the \Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles folder on the report server.

Run IISRESET.

Then

C:\>rskeymgmt -d

All data will be lost. Are you sure you want to delete all encrypted data from the report server database (Y/N)? y

Restarting the Report Server Windows service...

Restarting IIS...

The command completed successfully

C:\>iisreset

To reconfigure the keys:

Run rsconfig:

C:\>rsconfig -c -s -d reportserver -a windows
(or -a SQL if you're using SQL authentication)

VMWARE -Failed to obtain a write lock on the virtual machine's configuration file. This virtual machine may already be in use.

2005-11-25T10:54:00.000-05:00

Failed to obtain a write lock on the virtual machine's configuration file. This virtual machine may already be in use.

Solution:

The message information is obvious and mischievious. Most common issue would be the virtual machine is opened by some other VMWare Instance(prefered situation is to allow one UI to open and start the virtual machine. That mean you can have only one see it as one instance.).Suppose you open it in remote machine and the situation would become ugly. VMWare GSX boast to have this functionality though.

You can also look for *.vmx machine ( usually under the Virtual Machine folder where I have all the VMs served by the workstation) so that you see if someone else has opened the Main VM already.

The command for taking the console is “mstsc -v:MAINMACHINENAME/f –console”. The item in bold is server name from where you create VMs in the VM Farm. Refer to the
documentation for more information on this.

Good luck!

Sharepoint Services running on Windows 2003

2005-11-16T10:12:00.000-05:00

When you run sharepoint services on your virtual server with other website(s) then you may probably had to take a look at the following support page to correctly configure the trust level settings for your website(s).

Otherwise, it may lead to errors like:

"Debugging is not supported under current trust level settings"

The link is:

http://support.microsoft.com/?id=835248

Biztalk 2004 - MSMQ and MSMQT side by side install

2005-11-15T11:47:00.000-05:00

Follow the rabbit:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/operations/htm/ebiz_ops_adapt_file_lzrr.asp

Enterprise Single Sign on - y this problem with Biztalk 2004 -Event log

2005-11-14T14:38:00.000-05:00

The following event log error messages started appearing after I installed Biztalk 2004 developer edition on my machine:

The master secret has not been backed up. If you lose
the master secret all the information stored in the SSO
system will be lost permanently and your systems may fail
to work correctly. Please use the SSO admin tools to back
up your master secret

Reasons and solution:

The following is AS-IS from Microsoft Biztalk 2004 documentation:

**************************************************************

You can back up the master secret key from the master secret server onto an
NTFS system or removable media, such as a floppy disk.

You must be a Single Sign-On Administrator to perform this task. You will
be prompted for a password. To restore the secret later, you must specify
the same password.

Warning If the master secret server crashes and the key is lost, or if the
key becomes corrupted, you will not be able to retrieve the configuration
of adapters stored in the Credential database. You must back up the master
secret key, or you risk losing data from the credential database.

To back up the master secret key

1. On the Start menu, click Run.

2. In the Open box, type cmd, and then click OK.

3. At the command line, go to the Enterprise Single Sign-On
installation directory. The default installation directory is directory>:\Program Files\Common Files\Enterprise Single Sign-On.

4. Type the following syntax at the command prompt to backup
the master secret key:

ssoconfig -backupsecret

Note is the path and name of the file where the master
secret will be backed up. For example, A:\ssobackup.bak

Note You need to be a local administrator and an SSO Administrator to run
these ssoconfig commands Check the event log if they fail. These commands
can only be run on the master secret server.

*********************************************

sssshhh....Dont talk abt Biztalk...

2005-11-14T11:01:00.000-05:00

Error Message:
Orchestration '------'configuration cannot be changed since it is not in the unenlisted state.

Solution:

This means that you have to unenlist the orchestrations.

To fix it open the Biztalk Explorer ( from the Menu-bar View -> Biztalk Explorer)

I assume you are using database to configure biztalk.

Select Biztalk Configuration databases. Collapse it.

Do a Ctrl + alt + F5, I mean, refresh it.

Under the biztalk management database, Open Orchestrations folder.

You should see ur orchestration which you have to select and right click on it.

Then select stop from the context menu that appears.

You can now bind by right clicking again on the orchestration and edit the configuration there.

HTH
Rajesh Meenrajan

Windows 2003 - Remote Desktop FAQ

2005-11-11T15:43:00.000-05:00

To log on to this remote computer, you must be granted the Allow log on through Terminal Services right. By default, members of the Remote Desktop Users group have this right. If you are not a member of the Remote Desktop Users group or another group that has this right, or if the Remote Desktop User group does not have this right, you must be granted this right manually.

Solution:

1.Check if the Remote Desktop User groups has actually the rights to log on using terminal services:

2. From Start-> All Programs -> administrative tools -> local security policy -> local policies -> User rights assignments

3. Check if remote desktop users is added in the 'allow logon through terminal servers' right.

4. Add the specific users to this right and check if you can connect. No need to reboot;)

The Enterprise Single Sign-On Service and associated BizTalk Server 2004 services fail - Windows 2003 Server

2005-11-09T14:01:00.000-05:00

The following is applicable to install Windows XP Service Pack 2 (SP2), which worked for me on Win2003.

By default on your machine the Group Policy editor will have RPC Endpoint Mapper Client Authentication not configured. This has to be Enabled.

Follow the rabbit:

http://support.microsoft.com/default.aspx?scid=kb;en-us;841893

BTW, THIS IS MY 100TH POST! YEEHAA

HTH
Rajesh

I hate Biztalk 2004

2005-11-08T16:52:00.000-05:00

I hate the most of all the product.

1. Require Windows 2003 server even on dev environment.

2. Had to install lots of depend s/w apps like Windows Sharepoint services, MS XML 4.0, MS XML 3.0, Office XP tool: Web components, Sql Server 2000 Service pack 3a, Sql Analysis Services, IIS 5.1 or higher, MS SOAP toolkit 3.0 and MUCH MUCH more!

3. Note, you have to uninstall Frontpage Server extensions( but, had to install VS.net 2003 which requires this... what a crap!)

In order to install on multiple machines then you need MSMQ where BAS goes and MSMQT where Biztalk server goes.... good one microsoft ;)

After you do all this the end result might be sweet ....

AJAX - whatz that?

2005-11-07T16:55:00.000-05:00

AJAX - Asynchronous Javascript And XML. Compared to ASP.NET page Processing Model, AJAX do not postback to the web server very often. The model has been designed so that it solves the problem due to network traffic with page having lots and lots of controls, images, etc. The idea is to give server side resources from the client web browser.

AJAX.NET is a free .NET library which can be downloaded at:

http://ajax.schwarz-interactive.de/csharpsample/default.aspx

More information and tutorials can be found at:

http://en.wikipedia.org/wiki/AJAX
http://java.sun.com/developer/technicalArticles/J2EE/AJAX/
http://www.ajaxpatterns.org/AJAXFrameworks

Nice feature in ADO.NET 2.0

2005-11-01T16:12:00.000-05:00

Have u ever tried to run multiple queries/stored proc from a single connection? You would be ending up with the following error messages in ADO.NET 1.0:

"There is already an open DataReader associated with this connection which must be closed first"

MS has moved forwarded in 2.0 and you can do that using Multiple Active Result Sets (MARS). Note u need SQL Server 2005 to support this feature. In your connection string all you need is 'MultipleActiveResultSets=True'

Thatz my 2 cents of the day....

The custom form could not be opened. Outlook will use an Outlook form instead.

2005-10-27T13:24:00.000-04:00

The custom form could not be opened. Outlook will use an Outlook form instead.
The form required to display this message could not be opened.

Resolution:

See:

http://support.microsoft.com/default.aspx?scid=kb;en-us;836558

Inconsistency of foreach usage with DataView and DataTable - .NET Framework

2005-10-26T09:59:00.000-04:00

If u would have noticed there is some inconsistency in how to use foreach DataRow and DataRowView in DataTable and DataView:

Here is the sample for DataView:

DataView dv = (DataView) dataGrid1.DataSource;
// Set the filter to display only those rows that were modified.
dv.RowStateFilter=DataViewRowState.ModifiedCurrent;
// Change the value of the CompanyName column for each modified row.
foreach(DataRowView drv in dv){
Console.WriteLine(drv);}

Here is the sample code for DataTable:

foreach(DataRow myRow in thisTable.Rows){
foreach(DataColumn myCol in thisTable.Columns){
Console.WriteLine(myRow[myCol]);
}
}

If you have to parse through each row in a DataTable you have to use thisTable.Rows.
But, in case of, DataView, u you dont require Rows property....
It looks inconsistent to me.. What do uall think?

Writing better code in ADO.NET - DataTable

2005-10-21T15:04:00.000-04:00

There are scenarios in which datagrid is binded to DataTable. So in the grid you may add/delete/update data which might have to be captured in DataTable.

While u add:

objDataTable.Rows.Add(objDataRow);
objDataTable.AcceptChanges();

While u update:

objDataRow.BeginEdit();
.
.

objDataRow.EndEdit();

objDataTable.AcceptChanges();

When u delete:
objDataRow.Delete();
objDataTable.AcceptChanges();

Remember to Accept changes to the data table so that changes has been updated to the datatable.
or you may end up with error messages like:

deletedrowinaccessibleexception "deleted row information cannot be accessed through the row"

system.data.constraintexception "value is already present in datatable"
Thatz my tip of the day.....

Multi-column key in Dataview -ADO.NET feature

2005-10-20T10:16:00.000-04:00

How can I delete unique rows in a dataview when the view is based on 2 or more columns. For example AccountID column has duplicates and StoreID column has duplicates. Together these two columns are unique. In order to delete the correct row in datagrid we have to sort based on 2 objects( columns). Here is the example:

string SortColumns;
Object[] SortArray = new Object[2];

DataView dv= (DataView) Cache["objDataGrid_"+ CacheModelUser];
//Sort Columns by AccountID and StoreID
SortColumns = dv.Table.Columns[2].ColumnName + "," + dv.Table.Columns[4].ColumnName + " ASC";

dv.Sort = SortColumns;

SortArray[0] = AccountID ;
SortArray[1] = StoreID;

int RowNum = dv.Find(SortArray);
dv[RowNum].Delete();