Melick's Blog

[COMException (0x80004005): The system cannot find the file specified.] This Error occurs when using crystal reports as web reporting. There are several reasons for this. Required DLL are missing in web setup Required Reports files are missing in web setup Access Permisions Required DLL and Reports are missing in web setup To over come this you can create web setup as below (VS2008) Go to Other Projects , Add Web Set up Project. Then Right Click the Project and goto Properties and then Prerequisites and select crystal Reports Basic for Visual Studio.. And add other files (sometimes reports files are not including please be careful) Note :- If your error is still occur use filemon (google it and get the first link) and monitor your files when browsing. it will give what is the actual cause of the error. Access Permission Give full permission to asp.net (give permissions in IIS , Windows/Temp, wwwroot )

Add App.config File Using Add New Item Open the Configuration File and add relevant Entries. Method 1 using System.Configuration; String Value=ConfigurationSettings.AppSettings.Get("SampleKey1"); int SampleInt = Convert.ToInt32(ConfigurationSettings.AppSettings.Get("SampleKey2"));

just two decimal places String.Format("{0:0.00}", 123.4567); // "123.46" String.Format("{0:0.00}", 123.4); // "123.40" String.Format("{0:0.00}", 123.0); // "123.00" max. two decimal places String .Format( "{0:0.##}" , 123.4567); // "123.46" String .Format( "{0:0.##}" , 123.4); // "123.4" String .Format( "{0:0.##}" , 123.0); // "123" at least two digits before decimal point String .Format( "{0:00.0}" , 123.4567); // "123.5" String .Format( "{0:00.0}" , 23.4567) ; // "23.5" String .Format( "{0:00.0}" , 3.4567); // "03.5" String .Format( "{0:00.0}" , -3.4567); // "-03.5" Thousand separator String .Format( ...

SELECT BenefitCd FROM SOQuoLifeBenifit WHERE (DependentGrp IN (SELECT DependentGrp FROM SOQuoLifeBenifit AS Tmp WHERE (BenefitCd = 'BASIC')) )