Click here to Skip to main content

Articles by Manjuke Fernando (Technical Blogs: 25)

Technical Blogs: 25

RSS Feed
No articles have been posted.

Average blogs rating: 4.69

Dialogs and Windows
General
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 14,460   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Design forms beyond the size of our development machine's screen resolution.
Windows 2000 Styles
Posted: 15 May 2011   Updated: 15 May 2011   Views: 30,755   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
How to deploy Windows applications using ClickOnce (Visual Studio 2008)
Files and Folders
File System
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 24,305   Rating: 4.50/5    Votes: 4   Popularity: 2.61
Licence: The Code Project Open License (CPOL)      Bookmarked: 23   Downloaded: 0
There are times that we need to monitor multiple directories and if any changes are available, invoke a given method.
Grid & Data Controls
General
Posted: 5 Aug 2011   Updated: 5 Aug 2011   Views: 47,000   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
A view can be defined as a virtual table or a stored query and the data accessible through a view is not stored in the database as a distinct object. Only the select statement is stored on the database instead. How ever views can be used and perform DML operations (Insert, Update & Delete) also. Co
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 14,621   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
If you have used InfoPath in your development, you might have come across the issue of filtering data using a date range, after the data is received by the form. To illustrate the issue, I will use a sample InfoPath form.
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 11,675   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
How to display distinct data from a duplicated data source in an InfoPath form
PropertyGrid
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 13,044   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
How to show properties of a class on a PropertyGrid.
ATL Server
General
Posted: 28 Jul 2011   Updated: 28 Jul 2011   Views: 30,628   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Using Update Cursors in SQL Server
Charts, Graphs and Images
Images and multimedia
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 29,699   Rating: 4.75/5    Votes: 3   Popularity: 2.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
How to show an image saved in a SQL Server table on an ASP.NET Image control.
Site & Server Management
General
Posted: 20 Sep 2012   Updated: 20 Sep 2012   Views: 12,829   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Briefly describing the features in SQL Server Data Tools.
Database
General
Posted: 19 Oct 2011   Updated: 19 Oct 2011   Views: 16,563   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
This is a common issue that development teams face when reports are being deployed to the production environment.
Posted: 16 Jan 2012   Updated: 19 Oct 2012   Views: 51,771   Rating: 4.81/5    Votes: 10   Popularity: 4.79
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 0
How to resolve this iisue.
SQL
Posted: 6 Nov 2012   Updated: 6 Nov 2012   Views: 22,746   Rating: 4.33/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Create a Cursor using dynamic SQL query.
SQL Server
Posted: 31 Jul 2011   Updated: 31 Jul 2011   Views: 13,142   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Using the new MERGE statement feature in SQL Server 2008.
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 19,546   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
How to save an image to a SQL Server table.
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 20,080   Rating: 4.38/5    Votes: 6   Popularity: 3.24
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
How to repeat a SQL row based on a value in a different column.
Posted: 8 Mar 2012   Updated: 8 Mar 2012   Views: 36,068   Rating: 4.94/5    Votes: 15   Popularity: 5.81
Licence: The Code Project Open License (CPOL)      Bookmarked: 22   Downloaded: 0
Locks and duration of transactions in SQL Server.
Posted: 3 Sep 2012   Updated: 3 Sep 2012   Views: 16,946   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
How to install SQL Server Data Tools.
SQL Reporting Services
General
Posted: 27 Jul 2011   Updated: 27 Jul 2011   Views: 9,092   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
    If you try to install/add feature SQL 2008 Business Intelligence Studio, to a machine with VS2008 having installed to a different location than the default, you will most probably get the following error : In order to install BI Studio 2008 properly, please do the following : Find the folder wh
Posted: 25 Nov 2011   Updated: 25 Nov 2011   Views: 12,538   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Why use CLR?Before using CLR, you should question ‘Why’. When using CLR functions within T-SQL, you have to maintain two different programming environments, unless what you gain worth more than having it.We need to use the CLR functions when occasions such as:When we have to access system resources
Posted: 26 Nov 2011   Updated: 26 Nov 2011   Views: 21,703   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL
C#
General
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 31,698   Rating: 4.38/5    Votes: 6   Popularity: 3.50
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Constructor Chaining is an approach where a constructor calls another constructor in the same or base class.
Reporting
Posted: 8 Aug 2011   Updated: 8 Aug 2011   Views: 20,584   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
How to invoke a method in our client application when the print button of the report viewer is clicked.
Uncategorised Technical Blogs
General
Posted: 21 Jul 2011   Updated: 21 Jul 2011   Views: 3,942   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
                                             As name implies extension methods allow existing classes to be extended without using inheritance or changing class’s source code.Some important points when using extension methods:•    You cannot use extension methods to override existing methods•    An
Posted: 21 Jul 2011   Updated: 21 Jul 2011   Views: 4,574   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
                                             What's a delegate A delegate is a type that safely wraps/encapsulate a  method. It is similar to 'function pointers' in C/C++, but it's type safe.   When to use a delegate Use a delegate when : An eventing design pattern is used. It is desirable to enca
No tips have been posted.
No reference articles have been posted.

Manjuke Fernando
Technical Lead Air Liquide Industrial Services (Singapore)
Singapore Singapore
I have been in software industry for more than 8 years. I have developed different type of software using different languages. Many of them are database related (both web & window based), SQL being as the back end most of the time. Up-to-date I have knowledge in languages such as C#, VB.Net, T-SQL, JAVA, VB6 & C++, making C# the most proficient of all. Also I have worked using different technologies like ASP.Net, SharePoint, Crystal Reports (But I really hate designing reports) & MS SQL Server and have involved in designing & developing software for major companies like FedEx, Softlogic Holdings, IronOne Technologies & Brandix. Currently I am working as a Tech Lead in Singapore.
Follow on   Twitter   LinkedIn


Advertise | Privacy | Mobile
Web01 | 2.8.140821.2 | Last Updated 23 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid