dewaMediashort . informative
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
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
Telerik Reporting: The Exploration
Challenge: I am pretty much ok with Telerik ASP.NET or ASP.NET AJAX but I have no nothing about this Telerik Reporting. Solution: 1) How to Chart Binded from ObjectDataSource plus utilising ItemDataBinding: http://kure256.wordpress.com/2009/03/15/telerik-reporting-report-with-subreports-and-chart-binded-from-objectdatasource/ 2) Couple web code: Telerik.Reporting.Report report = new EUCTVIReports.ConsolidatedReport(); (report as EUCTVIReports.ConsolidatedReport).pctrbxdtlMain.Value = imageURL; this.rprtvwrGraph.Report = report; Note: The modifier of pctrbxdtlMain [...]
.NET Transaction Exception – The operation is not valid for the state of the transaction
Challenge: When debugging the TransactionScope for processing multiple data insert, there is error coming randomly. Solution: It seems that there is timeout issue that needs to be address: The solution turned out to be editing the transaction timeout value in the machine.config file. This is achieved by going to your .Net 2.0 folder and editing [...]
.NET Type or NameSpace name ‘ ProfileCommon’ Could not found
Challenge: We have a code that utilise the ProfileCommon and originally sits under App_Code of the web application. This peace of code is running well. But due to moving this code a centralise class that we have, we have the following error: NameSpace name ‘ProfileCommon’ Could not found. Solution: Explore this and we found this [...]
TSQL: Executing Stored Procedure/Function with Synonym
Challenge: We have an issue on executing the stored procedure/function with synonym (Error: Procedure or function expects parameter which was not supplied). We’ve created the synonym using GUI. Solution: Not sure what is causing on the GUI but if you run through a TSQL command, it works. USE EUCTelcoDB_DEV_2 CREATE SYNONYM syn_aspnet_UsersInRoles_GetRolesForUser FOR EUCAccountService_DEV.dbo.aspnet_UsersInRoles_GetRolesForUser;
Pivoting using STUFF and XML Path in SQL
Challenge: I have these 3 simple tables 1) Users: UserID INT, Username VARCHAR(32) 2) UserInRoles: UserID INT, RoleID INT 3) Roles: RoleID INT, RoleName VARCHAR(32) So if I joinining these 3 tables I might end up with for instance: UserID, Username; RoleName: 1; ‘test’; ‘Administrators’ 1; ‘test’; ‘Mobile Users’ 2; ‘test1′; ‘Administrators’ As you can [...]
