dewaMediashort . informative
Error: this.controller is null or not an object reportviewer
Report Viewer Control missing Header Icons In IIS 7, we need to make sure we configurate the ReportViewer handler. You can follow these steps: Open Internet Information Services (IIS) Manager and select your Web application. Under IIS area, double-click on Handler Mappings icon. At the Action pane on your right, click on Add Managed Handler. [...]
An ASP.NET setting has been detected that does not apply in the Integrated managed pipeline mode
After installing Telerik 2009 Q1 and run the application and got the following error: It said: “An ASP.NET setting has been detected that does not apply in the Integrated managed pipeline mode” A quick look on the IIS7 documentation, blogs, forums etc I ran the following command. %SystemRoot%\system32\inetsrv\appcmd migrate config “Default Web Site/”. I then [...]
Excel: Crack Sheet Password Protection
Challenge: Excel file has password protected and no one know what the password is. Solution: After searching the net, here is the solution. Thanks to http://www.theofficeexperts.com/VBASamples/Excel02.htm Create a backup file. Note: This routine provides a password to unprotect your worksheet. However, it may not give you the original password that was used. Open the workbook [...]
Split string in SQL Server 2005+ CLR vs. T-SQL
RT @LessThanDot Split string in SQL Server 2005+ CLR vs. T-SQL http://bit.ly/7X9fgV
Visual Studio 2008 and Reporting Service Component
Challenge: When trying to Add Data Source in Report section of Visual Studio 2008, we found the following issue: Could not load file or assemly ‘dewaCorp.EUC.TelcoDB.Data, Version=2009.4.1.1, Culture=neutral, PublicKeyToken=null’ or one of it’s dependencies. The system cannot find the file specified. Solution: There is no solution at this stage and it’s only work around. Here [...]
ASP.NET MVC
Challenge: I am exploring the ASP.NET MVC model. Solution: I found few interesting stumble blocks and here are some the link that might be usefull 1. http://www.mikesdotnetting.com/Article/109/ASP.NET-MVC-Entity-Framework-One-to-Many-and-Many-to-Many-INSERTS 2. …
Software Development for iPhone
Challenge: I had a discussion with people that is using iPhone and my phone is Blackberry. They said that you are developer right? Can you create this cool apps then? Solution: So I come back and explore the iPhone and here’s what I found so far: 1) 6 Tools for Beginning iPhone – http://idev4iphone.blogspot.com/2009/03/6-tools-for-beginning-iphone.html 2) [...]
Avoiding Cursor in TSQL
Challenge: People is asking me how to avoid the cursor. Solution: There are couple ways to avoid this: 1) Always use a natural power of SQL Language (join, sub query). 2) Use Common Table Expression (CTE) – http://msdn.microsoft.com/en-us/library/ms175972(SQL.90).aspx. 3) Utilise Merge statment (SQL 2K8) or http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html
CSR Parser
Challenge: I’ve been conversation with the GoDaddy technical support and asking to verify the locality on certificate. Solution: If you have a CSR, you ca go to the following url: www.csrparser.com to decode.
Object Oriented and Pattern
Challenge: When you’ve created an application, you tend to forget this fundamental syntax as well as other concept such as Pattern. Solution: Some useful of OO Concept and Pattern: 1. Abstract Class VS Interface – http://www.codeproject.com/KB/cs/abstractsvsinterfaces.aspx 2. Design Patterns in C#/VB.NET – http://www.dofactory.com/Patterns/Patterns.aspx 3. Strategy Pattern in C# – http://www.primaryobjects.com/CMS/Article70.aspx
