Microsoft Report Viewer generates An error occurred during local report processing

This Works spent a lot of of my work time to figure out what the real prob was. Here are the steps to resolve this.

1. click on it to download Microsoft Report Viewer Redistributable 2008  from http://www.microsoft.com/downloads/details.aspx?FamilyID=CC96C246-61E5-4D9E-BB5F-416D75A1B9EF&displaylang=en
2. In command prompt Type “Cd windows\assembly\gac_msil\Microsoft.ReportViewer.pro*” and press enter
3. To list directory contents type dir and press enter. You will see the two versions 8 and 9
4. Type cd 9*
5. Type copy * c:\ . Then the file will be copied in you root directory of C drive
6. Add the Reference in to your BIN folder and put it on Server 

Cheers
Happy coding
samitha

ASP.NET caching with Web services

In ASP.NET 2.0, the HTTP method of the test page has changed from GET to POST. However, POSTs are not ordinarily cached. Implementing proper caching in your web services can increase scalability and performance. One of the easiest ways to implement caching systems is with the CacheDuration property of the WebMethod attribute.

Eg.
[WebMethod(CacheDuration=100)]


public string GetCacheEntryTime(string Name)

{

StringBuilder sb = new StringBuilder("Hi ");

sb.Append(Name);

sb.Append(", the Cache entry was made at ");

sb.Append(System.DateTime.Now.ToString());



return(sb.ToString());

}

Cannot resolve collation conflict for column 2 in SELECT statement

In MS SQL SERVER, the collation can be set in column level. When compared 2 different collation column in the query, this error comes up. Following article gives you details on fixing the collation problems.

http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/

In addition select statement can also be a cause for the above problem

E.g.
SELECT  P.ID,P.PASSENGER_NAME  +' '+ISNULL(P.LAST_NAME,'')  [PASSENGER_NAME],P.BAG_COUNT 
    FROM am.PASSENGER P

In the above table both PASSENGER_NAME and LAST_NAME columns has datatype of nvarchar(50). When I ran the above query the collation conflict error occured and following way I was able to fix it.


SELECT  P.ID,
P.PASSENGER_NAME  +' '+ISNULL(P.LAST_NAME,'')  COLLATE DATABASE_DEFAULT [PASSENGER_NAME],
P.BAG_COUNT 
    FROM am.PASSENGER P

cheers
Happy coding
samitha (MCTS)

SharePoint 2010 For Developers

English | WMV3 1024 x768 | MP3 48 Kbps | 363 MB
Genre: eLearning

Over the past several months, we’ve shared several introductory features about new assets for developers in SharePoint 2010. As Microsoft launches Office 2010 and SharePoint 2010 to businesses this week, we now bring you a real-world example of how developers can harness and capitalize upon the enhancements of the new version.

Download
http://hotfile.com/dl/47466839/714426c/SP2010FD.part1.rar.html
http://hotfile.com/dl/47466843/1607fc5/SP2010FD.part2.rar.html
http://hotfile.com/dl/47466841/e173e92/SP2010FD.part3.rar.html
http://hotfile.com/dl/47466842/28fe075/SP2010FD.part4.rar.html


cheers,
Happy coding,
Samitha

Writing a Debugger Visualizer in WPF

A good one to start with. Have a look

http://www.codeguru.com/csharp/.net/net_debugging/article.php/c17429

cheers
happy coding
samitha

Preventing Users From Copying Text From and Pasting It Into TextBoxes

Many websites that support user accounts require users to enter an email address as part of the registration process. This email address is then used as the primary communication channel with the user. For instance, if the user forgets her password a new one can be generated and emailed to the address on file. But what if, when registering, a user enters an incorrect email address? Perhaps the user meant to enter me@example.com, but accidentally transposed the first two letters, entering em@example.com. How can such typos be prevented?

Read more at http://www.4guysfromrolla.com/articles/060910-1.aspx

Cheers,
Samitha

New Features in Windows Communication Foundation (WCF) 4.0

Take a look at the new features and an introduction to WCF 4.0 framework.

Read More at WCF 4.0 Features

Cheers,

Samitha