Wednesday, July 30, 2008

Invalid Report Source

The error message appears because the incorrect versions of the Crystal DLL files are referenced.

To correct this behavior reference the correct version of Crystal DLL files.


Adding the Correct References
-----------------------------

1. Open the VS .NET project.

2. In the 'Solution Explorer' window, right-click the 'References' folder and choose the 'Add Reference' command. The 'Add Reference' window appears.

3. Verify the References for all Crystal DLLs are version 9.1.5000. If they are not version 9.1.5000, select the 9.1.5000 version DLLs and click the 'Select' button.

4. Click the 'OK' button.

5. Save and run your application.


If running the application you find the DLLs revert to the version observed prior to your updates, complete the following steps:


Reverting DLLs Back to Version 9.1.5000
---------------------------------------

1. Right-click the project name in the solution explorer and select the 'Properties' command. The 'Properties' window appears.

2. Under the 'Common Properties' folder, select 'References Path'. The 'Reference Path' window appears.

3. Delete all entries in this window and click 'OK'.

4. Repeat steps 2 through 4 of the 'Steps to Add the Correct References Section'.

Upon completing the listed steps, the application runs and reflects the correct References.


she send me this thru my mail i have copied and pasted it here

so it may be helpful to other who visit this forum

Thanks a lot for all those who tried to solve this problem.

dont forget to rate my post

Monday, July 28, 2008

.NET ACCESS MODIFIERS

There are Five Access Modifiers available in .NET. Following are the functionalities of these Modifiers.


Term Used With… Visibility
Public Variables/Properties/Methods/Types Anywhere in or outside of a project


Private Variables/Properties/Methods/Types Only in the block where defined


Protected Variables/Properties/Methods Can be used in the class where defined. Can be used within any inherited class.


Friend Variables/Properties/Methods Can only be accessed by code in the same project/assembly.


ProtectedFriend Variables/Properties/Methods Combination of Protected and Friend

Sunday, July 27, 2008

HOW TOGET SECOND MINIMUM VALUES FROM TABLE IF VALUE HAVE MULTIPLE OCCURENCES.

I have build this query to get the 2nd minimum amount (salary) of employees no matter how much occurrences they have. I want to retrieve each occurrence of 2nd minimum amount. The following query gives me my desired result.


Select amount
From table2
where amount = ( Select distinct top 1 amount
from (Select top 2 amount
from table2
order by amount asc) a
order by amount desc )

Saturday, July 26, 2008

Class MSComCtl2.DTPicker of control was not a loaded control class.

Reason:
MSComCtl2.DTPicker dll is not registered.

Solution:
Just register the dll by using the following command.

regsvr32 path_where_file_stored/MSComCtl2.DTPicker

FAILED TO LOAD CRYSTL32.OCX

Description:
This error is displayed when you have used reports in your projects and your reports are builds in Crystal Reports 8.5.

Reason:
Error is because of Crystal Report Viewer.

Solution:
Install Crystal Report 8.5 and problem solved

Wednesday, July 23, 2008

BC30560: 'CrystalReportViewer' is ambiguous in the namespace 'CrystalDecisions.Web'.



This error drove me crazy but I found the fix if anyone is interested:

On the HTML Behind the Form there are duplicate declarations for the Prefix tag:
<%@ Register TagPrefix="cr" Namespace="CrystalDecisions.Web" Assembly="CrystalDecisions.Web, Version=10.0.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" %>

My error was caused by having one for version 10.x and this one for version 9.x
I deleted the one for version 10.x and the error went away.

Monday, July 14, 2008

What is a favicon?

What is a favicon?

Notice the red “Y!” symbol that appears in the left-most area of the address bar in Internet Explorer graphic below. Look familiar? Yep, that’s Yahoo’s favicon. These favicons (favorites icons), sometimes called “bookmark icons,” appear after adding a website with a favicon to the favorites menu in Internet Explorer and certain other browsers.

Favicon in IE address bar

Favicons also appear in the favorites menu after a page is added. Most anyone who’s roamed the Internet and bookmarked sites of interest has noticed favicons showing up in the favorites menu like this:

Favicons in favorites menu

They also often appear in the Windows Start menu after installing a program as shown here:

Favicons in Windows Start menu

Creating a favicon

A favicon should be 16 X 16 pixels with 16 colors and the file name should be favicon.ico. IconEdit32 is a good freeware program that allows you to create favicons as well as icons of other sizes and color depths. IrfanView is an excellent freeware image viewer that supports the icon (.ico) image format. You can use it to shrink one of your regular images to a 16 X 16 size, then decrease the colors to 16 and save as a “.ico” file. I like to use IrfanView to get an image down to specifications, then edit it with IconEdit32. Remember, if you don’t save it as “favicon.ico,” it won’t work. Also, don’t just shrink an image to icon size and rename it with a “.ico” file extension. That won’t work either because it’s not a real icon file.

Installing a favicon on your website

Simply upload the file, favicon.ico to the root web directory of your hosted website with your favorite FTP program, Microsoft FrontPage, Dreamweaver MX or whatever. Make sure your favicon file is named “favicon.ico.” When someone bookmarks your site with a browser that supports favicons, your favicon will appear. Alternatively, you can use this code between the <\head><\/head>(x)HTML tags:

<\head>
<\link rel="icon" href="favicon.ico" type="image/x-icon" >
<\link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />
<\title>abc<\/title>
<\/head>

NOTE: PLEASE REMOVE FORWARD SLASHES (\) FROM HTML TAGS. IF YOU DON'T REMOVE THEM THE CODE WILL NOT WORK.


WISH YOU ALL THE BEST.