Gayani's Blog

NetSuite or SalesForce.com; what is out there?

noreply@blogger.com (Unknown) — Tue, 07 Aug 2012 15:14:00 +0000

NetSuite and SalesForce.com are both cloud based CRM solutions. NetSuite is not just a CRM but also an ERP. However, why does SalesForce.com out there in the market so much? I starting wondering about this ever since I started working with both products. In terms of the product features and capabilities I find NetSuite being in front than SalesForce.com but it was quite an amazing to note that so many companies moving in to SalesFore.com

Could it be the marketing? It kind of reminds me of the Novel vs Microsoft situation though Novel was a technical advanced product, Microsoft captured the market by brining in user friendly easy to use products rather then technical advanced, seeing SalesForce.com and NetSuite CRM reminds of a similar marketing atmosphere, but cannot exactly compare Novel-Microsoft scenario as the focus of the product (technology focused or customer focused ) were different at that time.

It is interesting to note that what are the focus areas of these two companies in terms of marketing their products. User Friendly, Ease of use, external API exposure, On call support all these matters and also a good complete product matters too.

Attacked by Live Security Platinum

noreply@blogger.com (Unknown) — Tue, 07 Aug 2012 14:55:00 +0000

I thought it was well worth publishing this link as it helped me to get rid of Live Security Platinum virus, http://trojan-killer.net/live-security-platinum-virus-delete-us/

Thank you so much!

Speech #3

noreply@blogger.com (Unknown) — Fri, 14 Oct 2011 14:24:00 +0000

It is all we have...

SDNUG October Meeting - 2009

noreply@blogger.com (Unknown) — Sat, 03 Oct 2009 00:56:00 +0000

Last Thursday the 1st of October I attended the Sydney Deep .NET User Group meeting. This was the first time I attended an Australian user group meeting after my arrival in Australia and it was a great experience for me.

The session was about ASP.NET V4 - New Features by Paul Glavich. It was a very informative session which he introduced the new features of ASP.NET V4 in terms of Core Services, AJAX, Web Forms, MVC, Dynamic Data, Design Improvements and Web App development in VS 2010.

I gained a lot insight to ASP.NET V4 and thank you very much.

May to October

noreply@blogger.com (Unknown) — Wed, 30 Sep 2009 01:44:00 +0000

My blog has been pretty quite for a while, so let me fill in the gaps with some of the shots I've captured :)

May .NET User Group Meeting - 2009

noreply@blogger.com (Unknown) — Sat, 09 May 2009 15:11:00 +0000

Colombo .NET User Group (CDNUG) meeting took place last Thursday the 7th May and Chandana did the first session on Windows Azure Services Platform.

The next session was take by me. My presentation was on 'LINQ to SQL to build your Data Access Layer.' On this session I talked about how to build a DAL using LINQ to SQL for a disconnected environment and highlighted some points to gain better performance as well. The full explanation and the code downloads can be found here.

It was interesting to see questions coming up from the audience and their enthusiasm on the subject. Hope it was useful and do feel free to buzz me if you find any thing interesting on this or have any queries.

Microsoft ISV Training on Dynamic Data

noreply@blogger.com (Unknown) — Thu, 23 Apr 2009 18:32:00 +0000

Yesterday I did a training program for ISVs on ASP.NET Dynamic Data. Apart from the setting up and customization, I talked and demo a bit on the very latest concept of using a Domain Service with Dynamic Data. So in other words it opens up a way to take more control on your data, in DD.

It was pretty interesting to see various queries from different aspects. And I hope it was an informative and a useful session for all of you. By the way, some one asked me to post all the references in my blog. So here they are...

Dynamic Data Official Site

Dynamic Data - MSDN

Dynamic Data - CodePlex

Dynamic Data - Forum

April .NET User Group Meeting - 2009

noreply@blogger.com (Unknown) — Fri, 03 Apr 2009 02:19:00 +0000

I did my very first presentation at Colombo .NET User Group (CDNUG) yesterday on Dynamic Data titled as 'Building Data-Driven Web Applications using Dynamic Data'.

The session touched the key areas of Dynamic Data customization apart from setting up and configuration. I was so happy to see the audience coming up questions :) I enjoyed doing the session a lot and do feel free to buzz me if you come up with any problems or something interesting on Dynamic Data.

By the way, there are couple of snap shots..and will be posting them once I receive them.

Here are they are..

Designing A Data Access Layer in LINQ to SQL

noreply@blogger.com (Unknown) — Wed, 04 Mar 2009 16:59:00 +0000

I wrote an article on Designing A Data Access Layer in LINQ to SQL It discusses how LINQ to SQL can be used to design a data access layer and lists some best practices that can help to improve the performance of the application. The complete source code is available for download with my article.

Dynamic Data Templates in ASP.NET 3.5

noreply@blogger.com (Unknown) — Wed, 26 Nov 2008 18:49:00 +0000

My Article on Dynamic Data Templates in ASP.NET 3.5 was published in Simple Talk web site on 17th Nov' 2008.

This article gives an introduction to Dynamic Data Templates in ASP.NET 3.5 and explains how one can save a great deal of time and effort when building data-driven web sites by using them and highlights some of the ways of customizing DDT to suit the industry needs.

This was released in the Simple Talk Newsletter as a feature article on the 26th Nov 2008 Edition.

Some thing I really enjoyed...

noreply@blogger.com (Unknown) — Tue, 07 Oct 2008 17:15:00 +0000

Today I did a presentation on LINQ at my office for my technical colleagues. It basically focused on giving an insight to LINQ and brief intro to LINQ to SQL, LINQ to Entity & LINQ to XML. Of course I was bombarded with all kinds of questions but end of the day it turned out to be a productive session.I simply love it.

Extracting XML and Insert Bulk Data using LINQ to XML and LINQ to SQL in .NET 3.5

noreply@blogger.com (Unknown) — Sat, 04 Oct 2008 13:36:00 +0000

Today I published an article in CodeProject, I am so excited about it because its the first time I published some thing outside my Blog.

Mainly this article focuses on how to read XML content and insert bulk data to the database using LINQ to XML, LINQ to SQL & LINQ and discusses the significance of LINQ.

You can find the article here : http://www.codeproject.com/KB/dotnet/LINQ_FOR_OPERATIONS.aspx

Enhancements in C# Code Editor in VS 2008

noreply@blogger.com (Unknown) — Sat, 30 Aug 2008 09:52:00 +0000

Explicit compilation was often needed to Identify the semantic errors in C# code in Visual Studio 2005 and earlier versions. For instance if we declare and use an unknown data type in C# code, it required compilation for identification of the errors.

Now with the Visual Studio 2008 SP1 C# code editor instantly identifies and mark these errors with squiggles in red with out the need of explicit compilation.

This adds up value to the developer experience plus saves the building time.

Exciting Tools

noreply@blogger.com (Unknown) — Thu, 12 Jun 2008 16:50:00 +0000

Recently, I came across with some interesting free tools that makes your life easy, especially if you are in to web development.

Color Pix

An exciting cute little color picker that identifies the pixel by the movement of the mouse and converts the pined color in to various different color formats.

JavaScript Editor

An Editor that basically supports intelligence, built-in-previews, syntax highlighting and a lot more.

Yes it definitely excited me and that’s why I thought to write about these two tools in my Blog. Enjoy scripting and color picking…

Dynamically Generating Images using ASP.NET Handlers

noreply@blogger.com (Unknown) — Sat, 07 Jun 2008 12:46:00 +0000

Introduction

Dynamic image generation in web applications are expensive tasks. More often we tend to access images from a location in a web server, or the regularly accessed images are often stored in cache objects. In some cases we need to draw images dynamically.

In any of these cases, more the resource are consumed the performance of the application reduces. There fore it is vital to use techniques that will improve the application performance. This article introduces the HttpHander and how it can be used to dynamically generate images providing a better performance to the application.

The HttpHander

It’s all to do with how the IIS handles a request. When the web application receives a request, it checks with its ISAPI filter. Internet Server Application Program Interface (ASPNET_ISAPI.DLL). This is responsible for getting the control on http requests. So when we have configured the application to handle the image types we require it will process them.

In this example jpeg is used. The configuration in the IIS will be explained later in this article.

Common Class to Handle Images

We need a class that will basically handle the images in our application. First we need to make this class, process the request that we get from the web page.

There fore, let us create a class that implements IhttpHandler. From the IhttpHandler implement the default members namely, the IsReusable and ProcessRequest. IsReusable method is responsible of indicating whether this particular instance can be used by another request or not, so here we will specify return false, as to indicate that it will be used by a single request. ProcessRequest is basically responsible of processing the http web request. So in this example I will transmit a particular person’s image based on the person’s name.

Utilizing the Common Class

Let us create a web page with a RadioButtonList control specifying the values (a,b,c) and text (person names) and a Panel control to load the images. Our objective is to display the person's image for selecting the name from the RadioButtonList control. And for this let us use the created class above.

Image control is created and the required ImageUrl is constructed and assigned to the ImageUrl property of the Image control before adding the control to the panel. Here, image URL is pointed to Test.jpg image, which actually does not exists in the solution.

So, how does this actually work? Let us dive deep to this and see what happens inside. When passing the selected value as the query string to the Test.jpg, the IIS identifies that it is an image to be processed of type jpeg and then the ImageHandler class will response with the relevant image.

Setting the Web.config

For our application to inform that .jpg file types are handled by the HttpHandlers, a tag is added to the <httpHandlers> section specifying the path as *.jpg and verb as * to handle any jpg request and by using the class ImageHandler which is specified in the type.

Configuring IIS

As we mentioned earlier, to make IIS identify the images, an application mapping for the .jpg (The file Type) that is handled by HttpHander needs to be configured in IIS. Follow are the steps for configuration.

· Open the IIS.

· Right Click on the Web Site.

· Properties -> Configuration -> Application Configuration-> Mapping

· Click Add

· Browse the aspnet_isapi .dll, type the extension as .jpg,

. Click on “Check that file exists” option.

Note (Only for Windows XP Professional Edition users) : In a Windows XP Professional Edition, OK button is disabled in this configuration. To overcome this, Once you select the dll, just bring your cursor to that field and make it focused. You must click on the Executable field and you must click on the Detention fields. And then OK will be enabled.

After configuring the application let us run at application. And here is how it appears.

Performance Evaluation

The following performance report depicts the most called functions and functions with more work.

Conclusion

Loading images dynamically using the handlers are much faster and less memory consuming compared to other techniques. Further, from a coding perspective it reduces the lines of code and keep things more clean and neat, from a performance perspective it improving the overall web application performance.

References

http://support.microsoft.com/kb/317948

70-551

noreply@blogger.com (Unknown) — Mon, 02 Jun 2008 17:26:00 +0000

After attempting for 4 times, I finally passed the exam 70-551. So thought to share some significant areas of interests and where more questions were targeted.

As you know, this exam consists of 3 parts. The order, which part comes first is random and here is a glance on the content. There are questions from all the chapters but here are some highlights of which most questioned are asked.

For Web Application related :

Mobile applications
Web Parts & Personalization
Deploying Tools
Custom Controls such as Wizard control, Login Control.

For the Application Foundation related :

Compression Techniques
Application Security
Serialization

For Application Design related :

Deploying Applications
Testing Applications
WMI, WSAT
Design Evaluation

One thing I noticed was that the exam content updates so fast, and it always comprises of latest changes.

Glimpse on LINQ TO SQL

noreply@blogger.com (Unknown) — Sun, 18 May 2008 13:31:00 +0000

What is Linq to SQL Server

So far all this time we have been using the ADO.NET to communicate with the Database, extracting and manipulating data. Linq to SQL opens a new window to do non other than the same thing. Linq to SQL provides ways of extracting and manipulating data on SQL Server Databases only.

How does it do it?

So, how does LINQ do it? The concept behind it is, it converts a Linq Expression to a SQL query at the backstage. But it’s not straight forward as such.

In Linq, first will look how it querys SQL data? Obviously, the DB structure should be mapped to some format understandable by linq. And that is done using the Linq to SQL class. I assume that application is already connected to some datasource.

Add a Linq to SQL Class to your solution; this class automatically creates necessary functionality to work with the table in the DB.
Open the server explores, connect to your DB and add some tables to this class; when tables are added a Linq to SQL Class which in this example the ContactDBDataContext is updated with the necessary functionality to deal with the DB.
Take a look at the code below.

ContactDBDataContext context = new ContactDBDataContext();
var contactData = from Course in context.Courses
select new { Course.Name, Course.Certification };

ContactDBDataContext is the Linq to SQL Class I added. Course is the table I added to that class. It references the course table as Courses. I’ve written a linq expression to get all the course names and certification names from the course table.

When you add your table to that class, it makes that added table identified as a System.Data.Linq.Table<TypeOfTable> and this is accessible from the Linq expression. Ok, now linq is aware of what tables to work with. Now how does it fetch the data? When linq expression is run on a Table<T> it returns an object of type System.Data.Linq.DataQuery, which has all the details to fetch the data you want. Even the SQL statement preview could be viewed by called the ‘ToString()’ on the particular DataQuery object.

This object of type System.Data.Linq.DataQuery implements the IEnumerable interface allowing it to traverse through its items using a ‘for’ loop. This object contains all the data you need to access, in this sample.

- This is just a surface of an ocean to dive in.

LINQ in Brief

noreply@blogger.com (Unknown) — Sun, 11 May 2008 19:29:00 +0000

What is LINQ?

LINQ stands for Language INtegrated Query. Basically this presents a mechanism for retrieving, sorting, manipulating data which are in various sources. As LINQ is new to .NET so as the syntax.

List<int> Prices = new List<int> {456,789,235,723 };

var myPriceList = from p in Prices orderby p descending select p

In the above line of code, from the Prices List<int>, p is specified as a representation of an item in the collection, saying to get p which are in Prices List<int> based on the ordering clause and finally selecting the item.

Difference between LINQ & SQL, .NET 3.5

Seeing LINQ in .NET 3.5 suddenly made me guess whether it operates like SQL too? Linq uses similar syntax as in SQL but its functionality is totally different to SQL.

SQL basically operates on tables, while LINQ could be operated on collections, and other datasources such as databases or xml. Unlike dealing with rows in a table, these collections could be manipulated using LINQ, whether they have values in them or even objects. Let’s look at some interesting features in LINQ.

Some Interesting Features in LINQ

A collection could be modified retaining the initial values of the collection as it is. For an example, let’s say you retrieve prices and you want to add the currency symbol to the prices. In spite of LINQ, if we were to retrieve the values and add the currency symbol to it, may require traversing through the collection. But LINQ does it simply as this.

private static void GetPriceList()

{

List<int> Prices = new List<int> {456,789,235,723 };

var myPriceList = from p in Prices orderby p descending select p.ToString("C");

foreach (string i in myPriceList)
{
Console.WriteLine(i);

}

}

Not only that, calculations too could be performed on them. Let’s say in the above list you want to get the average price. Here is how to get it.

Console.WriteLine("The average is {0:F2}", Prices.Average());

The important point here is that, method Average() is not a method of the List. It’s available due to LINQ. Such methods are called extension methods. That is basically used to extend the functionality of List in this example. Saving the manipulated collection to an array, dictionary or a list is also possible by the extension methods such as ToArray(), ToDictionary(), ToList().

For a programmer using .net 2.0 for and the previous versions for some time LINQ might seem a bit odd and alien. But when you look deep in to it, it does cuts off lot of code and thinking which you would invest to do some complex work out. For example a simple selection from a list, will require you to traverse through a loop and then check for a condition and extract the data.Linq makes this task easy by giving a whole new look in to the Visual Studio 2008 environment, giving the new key words and a lot of functionality to what you want to achieve.

Solution to Dynamic Length Arrays in C#

noreply@blogger.com (Unknown) — Fri, 25 Apr 2008 18:03:00 +0000

Creating dynamic length arrays is often a requirement, but arrays do have a limitation in this point. C# allows you to create dynamic length arrays as follows.

int[] intAry = new int[] { 1, 2, 3 };

If your requirement is simple as this, then fine. But what if you want to create an array based on the elements you add and specify the length accordingly.

You could use : Array.Resize<int>(ref intAry, 2); to resize. But again you may have to traverse through the array or use another array to copy the elements.

Arrays do have a limitation where you cannot make it grow dynamically. Collections on the other hand grows dynamically. Here's a solution to the dynamic length arrays.

List<int> oNumList = new List<int>(); //Haven't specified the size

oNumList.Add(1123); //Add items to the list

int[] oNums = new int[oNumList.Count]; //Create an int Array

oNums = oNumList.ToArray(); //Convert the List to an Array

C# List<> allows you to create a List<T> specifying the type in T. So, create a List<int> of type int and add the items to it, with out specifying the count of the List. Then convert it back to an Array. There could be other solutions to this as well..

Validate DataTypes using the CompareValidator

noreply@blogger.com (Unknown) — Sun, 03 Feb 2008 13:54:00 +0000

Tiny tip on Validation. CompareValidator in ASP.NET, could be used in an effective way such as to validate inputs for either Integer, Double, Date or Currency. Here is how you could do so.

In the CompareValidator, set the ControlToValidate to the input control and set the Type to the expected data type you need to validate, and then set the Operator to the DataTypeCheck. And just leave the ControlToCompare property empty.

<asp:CompareValidator ID="CompareValidator1" runat="server" ControlToValidate="TextBox1" Display="Dynamic" Operator="DataTypeCheck" Type="Date">InValid Date</asp:CompareValidator>

Significant point to note here is, that this validates the Type and not the format of the type. There fore if you expect to specify a format for example, number of decimal points for a double value or specific date format for the date this is not the ideal validation control to go for. (rather uses default date format to check)

But if you need to validate the specific Data Type only, I think this is a quick and clean way.

Resource Saving Dynamic Word Doc Generation.

noreply@blogger.com (Unknown) — Sat, 03 Nov 2007 19:07:00 +0000

Most often in web development we may require to export web content or contents of a database query to some other media such as word. Creating a word document, writing the content and saving it in the web server and downloading at demand is often time and resource consuming. Here is a quick way to dynamically generate the word document using the Http Response.

To start with, lets assume you already have some content ready to write to a word doc as a response to a button click event of your web page.

Response.Clear();

Response.Charset = "";

Response.AppendHeader("Content-Type", "application/msword");

Response.AddHeader("Content-Disposition", "attachment; filename=" + "MyWord.doc");

Response.AddHeader("Content-Length", sb.ToString().Length.ToString());

Response.Write(sb.ToString());

Response.End();

Response.Flush();

/* section (A) */

Here is a way to add a little formatting to the word document. Lets assume you need to make the page orientation to landscape and want to view in the Print View with the zoom 75%. Here is how you do it.

StringBuilder sb = new StringBuilder();

sb.Append("<html xmlns:o='urn:schemas-microsoft-com:office:office' " +

"xmlns:w='urn:schemas-microsoft-com:office:word'" +

"xmlns='http://www.w3.org/TR/REC-html40'>" +

"<head><title>My Title</title>") ;

string sStyle = "<!--[if gte mso 9]><xml>" +

"<w:WordDocument>" +

"<w:View>Print</w:View>" +

"<w:Zoom>75</w:Zoom>" +

"<w:DoNotOptimizeForBrowser/>" +

"</w:WordDocument></xml><![endif]-->";

sb.Append(sStyle);

sb.Append("<style>" +

"<!-- /* Style Definitions */" +

"@page Section1" +

" {size:841.9pt 595.3pt; " +

" mso-page-orientation:landscape; " +

" margin:.5in 1.0in 1.0in .5in ; " +

" mso-header-margin:.5in; " +

" mso-footer-margin:.5in; mso-paper-source:0; }" +

" div.Section1" +

" {page:Section1;}" +

"-->" +

"</style></head>");

sb.Append("<body lang=EN-US style='tab-interval:.5in'><div class=Section1>" );

/*Now append the content to be written to the word document.*/

sb.Append("<b>Sample Test <b>");

sb.Append("<div></body></html>");

And use Response.Write() section (section (A) )mentioned in the above to obtain the response as a word document.

As an overview, this is more useful when you want to extract large amount of information in a predefined word format. Such as extracting transaction information from the online bank statement for example.

Think Different

noreply@blogger.com (Unknown) — Sat, 06 Oct 2007 14:54:00 +0000

Found this great article, with some interesting tips for those who wish to become a supper star in their career.

Aim to be a superstar so that you can have more options in your career for creating a life you want. Here are things to think about while planning your path to superstardom.... Brazen Careerist: Five Ways To Make Yourself A Workplace Superstar

Efficient way of combining Strings using StringBuilder Class

noreply@blogger.com (Unknown) — Sun, 16 Sep 2007 15:23:00 +0000

In C#.NET, when combining strings, we often tend to combine as follows. This article discusses an efficient way of doing it.

public string createContent()
{
string sMessage = string.Empty;
sMessage += "Introduction.. ";
sMessage += "Welcome to Strings.. ";
sMessage += "This is a demo.. ";
return sMessage;
}

As you know String is a refernce type, and each time sMessage will be assigned by a value, but we only use the last assigned value. The others will be disposed by the GC. To avoid unneccasary garbage collection we could use StringBuilder. This is how we could use it.

public string createNextContent()
{
StringBuilder sbTest = new StringBuilder();
sbTest.Append("Introduction.. ");
sbTest.Append("Welcome to Strings.. ");
sbTest.Append("This is a demo.. ");
return sbTest.ToString();
}

StringBuilder creates a buffer of 16bytes long by default and grows as needed. It is possible to specify the initial size and the maximum size as well.

How to upgrade a DotNetNuke web site in version 3.2.x to version 4.4.1

noreply@blogger.com (Unknown) — Fri, 08 Jun 2007 07:37:00 +0000

Upgrading web sites that was created in DNN 3.2 or older versions to newer versions has become a common need today, due to the latest browsers and upcoming features that new versions provide. For example the IE7.0 does not display the tool bar of the FreeTextBox of the site created in DNN3.2 or later versions.

So here are the steps to follow to convert a DNN 3.2 web site to DNN 4.4. First, test this in a QA environment rather than trying on the production server.

Backup the web site database and the web sites folder that contain all the files.
Unzip the DNN 4.x installation package to any of the folders, then open up the web.config file.
And do the following changes, and use the web sites web.config file as the source to obtain the following details.
Set the
- Database name
- Machine Validation key value.
- DecryptionKey value.
- Database Owner
- ObjectQualifier

as same as the web.config file of the web site. Also make sure you copy any other settings you have made in the web sites web.config file.

Now that you have done the necessary changes; copy the dnn4 folder contents to the web sites folder contents, this process will over ride the web config as well a so other files.
Now go to IIS and select the folder that you have set this site to run and change the DotNet engine to 2.0 version.
Now our web.config file will still be pointed to the production database of the test machine. Once we browse this site; what happens is that the contents for a DNN4 database will be installed on top of your production database through the application. And it will show up an upgrading screen in the portal. Once it is success it will create a link to browse the site.

If you check the database; some of the existing tables will now appear with additional fields. Further, during the upgrading if there was any problems it will be logged and the log will be pointed for you knowledge.

The process of converting is very straight forward, but its always advisable to get a back up of your files and convert the site.

Its often the case where some of the custom modules you've created, may give problems during a site upgrading. One solution to this would be to uninstall the module and convert that particular module to DotNet 2.0 and then re-install.

DotNetNuke upgrading allows you to retain your data as it is and upgrade the web site successfully.

Briefing on Installing DotNetNuke 4.x

noreply@blogger.com (Unknown) — Fri, 08 Jun 2007 07:36:00 +0000

Thought to share a tiny sereat, since its a bit messy to figure out the process of installing DNN4. Well, its basically same as DotNetNuke 3.x but rather you should have .NET Framework 2.0 already installed as a prerequisite.

First visit the site DotNetNuke and download the latest version of DotNetNuke source. Now, there are two files to download, but select based on your requirements for example if you are developing your own nuke modules, its advisable to install the source, or else go for the general installation.

One significant point about nuke is that; its so easy to mess unless you don't know what to be done. For a simple example, if you unzip the downloaded source to a folder name you desire then you are in trouble. Just extract to the contents to a folder that creates by default in the same driver. Then go to C:\DotNetNuke_4.4.1_Source\Website\Documentation\Readme.txt path and you will find a read me text document; which explains every step to follow. In simple terms it goes as follows.

Now that you have un-zip the folder, and now create a virtual directory in IIS. Now If you open the folder of the contents you will come across with the Website folder, Library folder and the solution file, just point the virtual directory path to the Website folder since it has the project file.

If you already have dnn3 installed; there is nothing to bother since you will be installing this to a completely different folder and we will be mapping to a new database.

Once you create the virtual directory, make default.aspx as the top and make the Dotnet version to 2.0xxx Now go back to your folder and properties and make sure you have given the permission for the Network services user and as well as aspnet user, full control. Now open up Sqlserver 2000 or 2005. and create a database by any name.

once that is done, go back to the folder and rename the release.config to web.config and change the connection string properties. In Nuke version 4.x it the database connection is specified in two places. So it needs to be changed accordingly.

Now open the IE and browse http://localhost/VirtualFolderName and there you go the DotNetNuke4.x will be installed nice and smoothly.