System.Data.DataSetExtensions

System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.DataSetExtensions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
File name: 'System.Data.DataSetExtensions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'

Hi friend

above is the error comes up in one of my current project. This is a particular problem comes when we convert our 1.1 or 2.0 framework application to 3.5 framework. In my project my client is having problem while installing our application on the 64 bit machine. I have started in the intention that i will just install the application and that's it. But it took half an hour or so to just install the application with one fatal error 1603.  This error occur because of three reason given by MSDN

•	The folder that you are trying to install the Windows Installer package to is encrypted.
•	The drive that contains the folder that you are trying to install the Windows Installer package to is accessed as a substitute drive.
•	The SYSTEM account does not have Full Control permissions on the folder that you are trying to install the Windows Installer package to. You notice the error message because the Windows Installer service uses the SYSTEM account to install software. But i was just happy to ignore this error as my application was installed even after this error.  Now the only problem left with the reports. when ever i am try to create the reports it give me error like above. While checking for the solution i come to know that the client don't have the hot fix for the 3.5 framework. In the above image you can see the properties. There is a red color circle which shows the version as 3.5.0.0 But the client system has only run time of the 3.5 and in the run time this particular .dll file is not present. I am getting this error as i am using this .dll file for the Type Data set.  Solution. Just download the framework 3.5 http://www.microsoft.com/downloads/details.aspx?FamilyId=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en and run it on the system. that's it.

   

Login Error in subreports with Crystal Reports

I am a fan of crystal reports. When ever it is feasible i want to use the Crystal report in my .net application whether it is window or web application. 

While working with one of my window application i got this weird error. It ask me for login in the database. That also happened with my reports which i changed recently.  The reports were working good till they were on my development system. It started giving problem when they are deployed on client machine. 

My client enviourment we have VS 2008 IDE too. So i opened the Report and went in the Dataset and check if it is pointing to correct XSD or not. I am using XSD (Type data set) in  all my crystal reports. Now when i click on the verify database the message came up "Data base is up to Date" . But after that the message box came up for selecting the XSD. I have selected the XSD and then the report start working as expected. 

With all these exercise i came to know that there is some problem with the XSD. The only way to find out the problem is this way

1) Open the .rpt file

2) Go to field Explorer

3) Right Click on database field and then Database Expert

4) Create New connection 

5) Click On ADO.net 

6) It will ask you to select the class

7) If you have some table already  selected then you can just right click the table and see the properties. if Visual Studio Data Class name  is set for the Local directory something like c:\project..

that is the root of the problem. So you have to make it from the project not from the local directory.