AJAX Guestbook

Unobtrusive AJAX Guestbook.XML is easy to use ajax and php guestbook application. Guestbook.XML is crossbrower, skinnable guestbook and web 2.0 script Read More

SharePoint 2010 Videos Reveal Development Experience

If you are curious what the development experience will be in SharePoint 2010, there are now 10 modules with multiple videos per module that go through the details of using Visual Studio 2010 to customize your SharePoint solution.

Read More

Log on to Internet explorer as a different user

Here is a script that you can use to logon to Internet Explorer as a user that is not the same as the logged in user.

This script is a dos command --
runas /noprofile /user:domain\user "c:\program files\internet explorer\iexplore.exe"

This is particularly useful when you have limited user licences on a web based application.

Making speedometers in Excel

I was wanting to create a speedometer gauge in excel and started researching on the internet. Here are the links that I came with...

Interesting article titled Make Excel Charts interactive with sliders, gauge, dials and more by Ashish Mohta

There are several add-ins available that can be used to create speedometers in excel. The one that I liked the most was at Mrexcel.com

The link that I most found useful was this -- Hack together a Gauge Chart in Excel without sweat

Project Gemini gets a new Name........

Microsoft has now given a new name for Project Gemini. It is called Power Pivot.

The official blurb about it is: "PowerPivot provides business users with BI at their fingertips while enabling organizations to efficiently monitor and manage collaboration using Microsoft SharePoint 2010 and SQL Server 2008 based management tools"

You can find more information at the powerpivot site.

Getting rid of overtype mode in word 2007

I had a very annoying 10 min. with Word 2007 today where the Insert key did not disable the insert mode.

Here are the steps I followed to get it back to working.


Click the Microsoft Office button
click Word Options.
Select Advanced.
Click the option to Use Insert key to control overtype mode.
Make sure the Use Overtyp mode is unticked.
Click OK.

Flade (Flash Dynamics Engine) is an open source actionscript 2.0 library for simulating 2D physics using Verlet integration. It currently features rectangular, circular, & wheel primitives, spring & angular constraints, and surfaces composed of line segments, circles, & rectangles. Read More

Creating a scorecard using Performance Point Server 2007

Microsoft is offering Performance Point SErver as part of its Sharepoint Enterprise edition 2007.

This is a very handy application to create some nice dashboards and scorecards for a company.

Here is a link from mssqltips.com that provides a step by step guide to create a scorecard using Performance Point Server 2007.

Scrum 101

Yesterday I attended the Girl Geeks Dinner in Auckland. There were 2 presenters Carolyn Sanders and Sarah both on Agile Development.

Presentation 1:
Carolyn Sanders. The core of the practice of Agile is the delivery of individual projects; it's where most practitioners start out and it fundamentally changes the way a project team works together and works with their stakeholders. Scrum is one of the most popular Agile delivery approaches at the moment. In this presentation, Carolyn Sanders uses one of her recent projects as a way to illustrate each facet of Scrum and how it panned out in real life, from start to finish. This talk is directed at developers, testers, project managers, PMO managers and CIOs - who are relatively new to Scrum and want to explore the practical detail at the day-to-day level of a single project. The session will end with a Q&A to allow you to explore how Scrum integrates with other parts of the practice of Agile, or dig deeper into how it worked for one team.

Presentation 2:
Sarah Fairbairn. Sarah is a senior developer who has worked on Agile projects in the past and is currently working on an Agile project. Sarah will give a presentation about development in an Agile environment, the pros & cons and pitfalls to look out for based upon real world examples.


I have embeded the link of Carolyn's presentation here

APN Auckland Event 9 - Scrum 101, Unleashing the Theory

View more presentations from Carolyn Sanders.

Some interesting Sharepoint web parts

Here is a good link I found today while surfing for sharepoint web parts.

Delete all data from a database

I had a requirement today to delete all data from a sqlser ver database. This database has about 350 tables with a lot constraints. I manually started identifying the order of deletion absed on the constraints and realsied that this can't be done in a day. So I hit the good old google for help.

Here I found a very detailed explanation of how to easily achieve this by Susan Sales Harkins. Read More

Tips for resizing an image in photoshop

I was having a problem resizing an image yesterday. When I did a search, I found this great article that retains the quality of the image. Read More

Converting DTS to SSIS in SQL SERVER 2005

The easiest way to convert your SLQ SERVER 2000 DTS packages to SSIS is to use a tool called 'DTS xChange' that is available for download here

Here is link to the webcast by Brian Knight of Pragmatic works explaining in detail as to how to proceed with the DTS xChange tool.

One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach.

Also, this information can be used to shrink data files as needed if there is a lot of free space in the files. In this tip from MSSQLTIPS they take a look at a few ways to find the current free space within a database, so you can better manage your database files.... Read More

Project Gemini

Project Gemini is a powerful data analysis tool. Here is the link for the sneak preview of Project Gemini.

Building a dashboard using SSRS

Here is a tip from MSSQLTips I found useful on how to create a dashboard using Sql Server Reporting Services.

Read More

Introduction to AJAX

This is an excerpt of Chapter 1 from the book, ASP.NET 3.5 AJAX Unleashed, authored by Rob Foster.

Here is the link that was posted on codeguru

CSS Forums

If you are intermediate in CSS and looking to enhance your CSS knowledge then this post going to help you. By joining any of the following CSS forums will help you to boost your CSS knowledge.

Read More

Browsercap.ini update for IE 8

As soon as the Internet Explorer 8.0 was released and our customers have updated to IE 8.0 I started having queries about crystal reports compatibility with IE 8.0

The fist step I took was to update the browsercap.ini The code I used to update is as follows:

[code]
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; IE 8.0

[IE 8.0]
parent=IE 7.0
version=8
majorver=8
minorver=0

[*(*MSIE 8.*Mac*)*]
parent=IE 8.0
platform=Mac

[*(*MSIE 8.*Win 1*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win 2*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win 3*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win 9*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win N*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win X*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows 1*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows 2*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows 3*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows 9*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows N*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows X*)*]
parent=IE 8.0
platform=Win





[/code]

How Ajax works

AJAX has gotten more and more popular over the years, and has allowed web applications to act more and more like desktop applications. AJAX can provide a lot of additional functionality that could not be accomplished any other way.

Read More

Substring syntax in sql

Yesterday I was trying to get a part of a string from a field where the first comma occurs.

For example there is a field named 'Descriptor' which is a combination of "full name, Date of birth, unique number of the record" in that order. I wanted to get the full name using a select statement.

Here is the syntax I used.


select substring(descriptor,1,charindex(',', descriptor)-1) as [fullname]
from contacts

CSS Bubble Tooltips

Avoid cross-browser javascript when you can use css to make tooltips with less code. Honestly you were going to use css to style your tooltips anyway right? Your probably already have most of this code in your css already too. You can hover over meThis is my Bubble Tooltip with CSS to see how well these bubble tooltips work. Besides that if you have an advanced site in the first place you probably have enought javascript already.

For more info click here

Coding a Clean Web 2.0 Style Web Design from Photoshop

Here is a tutorial link for creating a clean web 2.0 style web design in photoshop.

Read More

20 best tutorials to convert Psd to Html/CSS

Here is a list of 20 best tutorials to convert Psd to Html/CSS. These tutorials should help you learn how to find the best way to code it.

Read More

Getting started with Sql Server Analysis Services

Here is a tutorial from MSSQL Tips on SQL SERVER Analysis Services.


Read more

In most organizations today, business critical and confidential data resides in some type of database, increasingly, SQL Server. As a result, SQL Server database security and compliance have become critical issues that must be effectively addressed to ensure an organization’s overall security. The goal is simple - minimize business risk, data theft, and data losses through good security practices. This whitepaper gives an overview of 10 key areas you need to focus on in order to ensure SQL Server security, and avoid finding your company in the headlines.

Click here to download the whitepaper

7 Free Resources for Eye-Popping Graphics and Animation

A picture will always be worth a thousand words. The good news is that in the open source world, there are many excellent, free graphics and animation tools, plus free resources for getting started with them right away.

read more | digg story

7 Free Resources for Eye-Popping Graphics and Animation

A picture will always be worth a thousand words. The good news is that in the open source world, there are many excellent, free graphics and animation tools, plus free resources for getting started with them right away.

read more | digg story

Paper+Color+Concept=40 Creative & Inspirational Piece of Art

40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attention and effectively convey the message.

read more | digg story

Paper+Color+Concept=40 Creative & Inspirational Piece of Art

40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attention and effectively convey the message.

read more | digg story

7 Fresh and Simple Ways to Test Cross-Browser Compatibility

This post is written for designer, developers, or anyone else who has struggled with testing their websites across multiple browsers.

read more | digg story

10 Steps To The Perfect Portfolio Website

You may have a personal portfolio website for a number of reasons. If you’re a freelancer, then you’d need one to showcase your work and allow people to contact you. If you’re a student (or unemployed), then you’d need one to show prospective employers how good you are and what you can do, so that they might hire you.

read more | digg story

Paper+Color+Concept=40 Creative & Inspirational Piece of Art

40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attention and effectively convey the message.

read more | digg story

13 Most Desirable Collection Of Free Resources For Designers

Here are countless free stuffs available for designers which everyone should review at least once. In this post, I have collected 13 Most Desirable Collection Of Free Resources For Every Designer.

read more | digg story

How to use Icons to Support Content in Web Design

This article showcases beautiful examples and best practices of using icons to support content in web design. Please feel free to take a look at the showcases of navigation menus, search boxes, blockquotes and web forms.

read more | digg story

How to use Icons to Support Content in Web Design

This article showcases beautiful examples and best practices of using icons to support content in web design. Please feel free to take a look at the showcases of navigation menus, search boxes, blockquotes and web forms.

read more | digg story

Problems connecting to SSAS 2005 from Excel 2003

Today I was trying to connect to SSAS 2005 cube from Excel 2003 and I was not able to do so using the exisitng OLAP 8.0.

I had to download the folowing to resolve the problem.

1. Microsoft Core XML Services (MSXML) 6.0 SP1
2. Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

I have followed the article on Microsoft downloads http://support.microsoft.com/kb/940167

and that solved my problem !

Internal Domain Redirects with ASP.net and C# (C-sharp)

An extremely useful article explaining how to issue internal domain redirects in ASP.net, through modifying global.asax.

read more |

Terminate User processes in SQL Server

This article illustrates how to create a simple procedure to kill many sessions at the same time, kill a range of sessions and kill all of the sessions connecting to a database.

read more |

Custom Error Handling in ASP.net C# (C-Sharp)

An article offering a nice solution on how to properly set up custom error handling in ASP.net.

read more |

CopyFileEx With Progress Callback in 20C

This article will show you how to call unmanaged DLL functions from C#. It will specifically walk through how to call CopyFileEx with a callback to report progress.

read more |

Flash vs Silverlight: Laser Orbit

A stunning effect with a laser orbiting around the mouse! In this example, it demonstrated the difference in dispatching Event between AS3 and C#.It included both Flash and Silverlight versions with complete source codes.

read more |

Creating 3D and 2D Interactive Web Content

Learn and read more about this 3D platform, that is web-based (supports most common browsers)!

read more |

Collections of Internet Resources for Software Developers

As a software developer, you need to constantly update your knowledge on new software technologies and new career opportunities for your own career development. This requires you spending time on search and find information on software technologies and career opportunities. This collection of Internet resources will help your to locate the informat

read more |

How To Watch YouTube Videos In High Quality

The technique to view youtube videos in higher quality is extremley simple and can be applied to any youtube video, it will however only work directly on the youtube website and only for some videos reportedly all after 2006.

read more |

Flash Quiz - Create your own free quiz

Want to create a quiz for your website but don't have the skills? This free software lets you quickly create and customise your very own multiple choice quiz. Just download the software and use the step-by-step wizard.

read more |

Grade your website

Website Grader is a free tool that measures the marketing effectiveness of a web site. The tool provides a score that incorporates elements such as web site traffic, SEO, social popularity, and other technical factors. This is a great tool when it comes to gaining an idea about what's working well and what could be improved on your site.

Scheduling a SSAS backup on SQL Server 2005

Today I had a requirement to schedule a backup on SQL Server Analysis Services. Here is the link that I found very useful for me. SSIS package to backup SSAS databases

Copying records from database into another -- SQL

I had this requirement today where I had to copy from a table in one database into a similar table in another database.

the code I have used in

[code]
insert into database1.dbo.table1 select * from database2.dbo.table1 where xxxxx
[/code]

where xxxx is the criteria that you need to add.

Precautions you have to tak before you do this.

Backup the database into which you are copying the record so that you can restore if something goes wrong.
Copy contents when there are no other transactions being entered into the database1

Amazing Free Website Template, Table less Website

Free table less or div template of Website Brewers... Cool website layouts with psd files, ie6 and firefox compatible. Ready to used to CMS template such as Wordpress or Joomla. Other templates includes Flash Slideshow and FLA File. You can also used on static pages... CSS Style Sheet have description and comments. The images are optimize by 80%.

read more |

Water Text Photoshop Tutorial

Learn how to create a text with "water" effects.

read more |

20+ Ways to Make Money Creating Online Cartoons

Various methods of using animation to make money, a few I am sure you expect and perhaps a couple you haven’t yet considered.

read more |

Learn, discuss and explore the realm of Graphic Design

Useful resource for designers. Interesting articles.

read more |

Mastering Visual C# .NET

Mastering Visual C# .NET is the best resource for getting everything you can out of the new C# language and the .NET Framework. You'll master C# language essentials, quickly taking advantage of the many improvements it offers over C++ and see tons of examples that show you all the ways that .NET can make your programming more efficient !I have already downloaded it.

read more |

XML in 10 points

If you are new to XML, it may be hard to know where to begin. This summary in 10 points attempts to capture enough of the basic concepts to enable a beginner to see the forest through the trees.

read more |

Open Book Tutorial

In ten simple steps, this tutorial teaches you how to design a simple but an effect open book design that can be used either for your flash autobiography or as a splash page for your website. This tutorial can even be accomplished by beginners so go ahead and give it a try!

read more |

Flower Photoshop Brushes

Free for download at gfxfever.com

read more |

Filemail - Email Large Files

Filemail is a nice online service,which allow you to send 2GB email attachments

read more |

7 Incredibly Useful Tools for Evaluating a Web Design

If you are interested in analyzing and optimizing your page layout - here are some extremely useful tools that you can use to help.

read more |

15 Watercolour Photoshop Brushes

A great collection of 15 watercolor photoshop brushes

read more |

Tutorial Photoshop: Reflection

A new Photoshop tutorial explaining you how to create this reflection effect on a text.

read more

List of SQL Server database users and permissions

Today I was doing some research as to how to list the database users and the permissions they have and came across this article which is very useful.

http://www.mssqltips.com/tip.asp?tip=1071

Test you site in different browsers...

If you are interested to test your website in different browsers then Browsershots is very helpful for you. Browsershots shows how your website looks in different browsers. It is very easy to use. Just go to Browsershots site and then submit

read more | digg story

Introduction to C++ Programming and Graphics: Download ebook

Introduction to C++ Programming and Graphics offers a venue for rapidly learning the language by concisely revealing its grammar, syntax and main features, and by explaining the key ideas behind object oriented programming (OOP), with emphasis on scientific computing. The book reviews elemental concepts of computers and computing..

read more

Photoshop Videos Search Results at macromedia.com

Search results for Photoshop videos. Lots of good Photoshop information, tips, tricks and techniques.

read more

Adobe Photoshop Tutorials - Best Of

An overview of professional step-by-step tutorials which can enrich your design skills and improve the quality of your works.

read more

Excel to Word mailmerge problem

Today there was this small thing that took my time. A date field in excel was formatted correctly but when the field was used in the mailmerge with Word. The format in the excel was not being reflected in word.

So I used the following steps to correct this in Word.

Step 1. Right click on the field name
Step 2. Click on the ‘Toggle Field Codes’ option For eg., { MERGEFIELD “AFinish” }
Step 3. Edit the field to include \@ “dd-MM-yyyy” e.g. { MERGEFIELD “AFinish” \@ “dd-MM-yyyy” }
Step 4. Right click and click update field.


You can see the date format as 17-08-2008

Viewing DTS scheduled jobs

I wanted to view the scheduled DTS jobs. So obvious way I thought was to do view it where I created. But for some reason, the schedule has been reset. So there is no way we can view the scheduled jobs of DTS here.

If you want to view these jobs, you have to access the SQL SERver Agent as these jobs are run by SQL SERVER Agent. So follow these steps to ciew your scheduled jobs on SQL server.

Go to SQL SERVER Enterprise Manager -- Management folder
Then click on SQL SERVER AGENT -- Jobs

Here you can see the job name status etc.

Automatic processing of SSAS cubes

I needed to automate the process of refreshing my Sql Server Analysis Services Cubes. My SQL server is 2000 and Analysis Services is SP4.

The approach I followed today is as follows:

I created a package in DTS of SQL Server 2000

Step 1 Created a SSAS task and pointed the Dimension (Rebuild the dimension) that needs to be updated.

Step 2 Then I created another task to refreshh all cubes.

Step 3 I created a On Success workflow between the above two tasks.

I saved this package and scheduled it to run monthly.

Displaying Temporary Internet Files folder in Windows Explorer

I am so used to browse the temporary internet files folder for internet exploer but I was not able to do this since I upgraded my Internet Exploer to 7. I finally found a way to do this. Microsoft has made the temporary internet files folder a 'Protected operating system folder'. That is the reason we cannot view that folder even when we check on the option 'Show hidden files and folders'.

All we have to do is Go to Windows Explorer -- Tools -- Folder options -- View tab
Untick the 'Hide protected system files and folders'

And you can see the Temporary internet files' folder in C:\Documents and Settings\User\Local Settings\ folder.

Java based math course includes problem-solving lessons and tests

Visual and interactive way to thorough understanding and mastering Trigonometry without getting wearied on the very first chapter! Java- and web-based math course includes theoretical

read more

Concatenate values from two text box and populate the value in another text box

Today I had to create a function to concatenate two values from a text box and populate the output in another text box. This I did to inmprove the usability of the form for inputing the credit card data.

This is what I wrote



function conc()
{
var mon;
var yy;

yy=document.getElementById("Texty").value;
mon=document.getElementById("Textm").value;
document.getElementById("Texte").value=yy+mon;
}

Web Photo Gallery with Photoshop

Today I was googling for some CSS photo gallery that I want to use for my website. I found quite interesting ones as follows:

Library of CSS Stylesheets
Joshuaink Photo Gallery Template
http://www.cssplay.co.uk/menu/lightbox.html

The one that suited me was described in this chapter on Techrepublic.

As I was about to call off my search, I found this easy way of creating a photogallery using Photoshop CS2 which is really handy if you have to create a photo gallery out of many photos.

How to Create an "Invisible" Folder for Your, um, "Private" Files

You ever have a folder on your computer that you really dont want any one to find? You can make this folder hidden but then you have to un-hide all the folders when ever you want to find it. So how can you make a folder truly invisible? Follow these simple steps and your unmentionables will stay that way

read more

My first project in c# ASP.net

Today for the first time I created a project in ASP.net. All this while I was doing some modifications for SQL code and reports for existing .NET projects. I wanted to recreate the functionality described here

When I did exactly what was said and tried to access the webpage, I got the error "Code not parsed...." When I googled for this error, then only I realised that I did not build the solution. So the error was fixed when I compiled the project.

Problems with connecting to proxy

Wayne, our systems Administrator contributed this:

Having problems with a user who cannot connect to our proxy server because their Internet Explorer keeps using a manually entered username and password, instead of their domain username and password. Even typing in the correct username and password doesn't work. Tried resetting IE settings, changing authentication options, with no success. Finally found instructions on removing the saved passwords, and that fixed the problem.

Windows XP does not offer a very easy way to review or remove the saved passwords though. If you follow the steps below though you can access a graphical interface to add, remove or edit the saved passwords on a given system.

1. Click Start and select Run

2. In the Open field type "rundll32.exe keymgr.dll, KRShowKeyMgr"

3. Once the Stored Usernames and Passwords interface opens you can select any of the entries and select Properties to view the existing information

4. To remove a saved password you can select one of the entries and select Remove. A confirmation screen will appear. Click on OK and the account will be removed

5. You can add additional saved passwords as well by clicking on the Add button and entering the appropriate information

6. Repeat the steps above as needed to add, remove or edit saved passwords

7. When you are done using the interface click the Close button

Thanks Wayne, for your contribution.

12 Ways to Make Better Use of Your Footer

Great list of ways to use an extended footer on a blog, and why you should move stuff down there as opposed to cluttering up your sidebar.

read more

Lists: To Do vs Action vs Next Action

Here is an interesting article on how to make your To Do list that works. Read More

Use SQL subselects to consolidate queries

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

read more | digg story

Messy Code? Stumped? Submit it to be refactored @ refactormycode.com

Have you got a method that you're dying to simplify? A class that's growing out of control? Or an algorithm that you just can't get working? Submit it to the new, awesome web app Refactor My Code, and have it refactored.

read more

The Flash Blog - Some great examples of Flash UI development

It seems as though Lee Brimelow is from Adobe. He is somehow connected to gotoandlearn.com, which has a lot of awesome tutorials on how these sites are made. Good site to check out if you're into flash UI dev. Cool stuff, check it out.

read more

Prompt for downloading word documents

I have created a functionality that will allow the users to download a pdf or a word document. The download was working fine when I used it, but on another machine I noticed that the prompt for download that asks the user whether to open or save the word file was not appearing.

These are the steps you need to follow when you are faced with this problem.

Go to the windows explorer,
Choose Tools-- Folder options
Click on File Types tab
Choose file type 'DOC' for word, 'PPT' for Powerpoint etc.
Click on the Advanced botton
Make sure that the "confirm open to download" checkbox is ticked.

Hope you enjoy it.

Wondershare Flash Album Studio v1.8.0

Looking for a new exciting way to show off your photos? Amaze your friends by taking them into the stunning flash photo galleries with Wondershare Flash Album Studio.

read more

Flash Effect Maker Pro v3.5 w / 578 Templates

Flash effect Maker is the great Flash effect tool to help webmaster design animated Flash intros, Flash banners, Flash ads, and any other Flash. With Flash effect Maker you can place your own photos as font front ground and page background. And then combine them with animated text, background effect to create fun Flash movies, all in just minutes.

read more

Mp3Resizer v1.8.3

Mp3Resizer is created to optimize the capacity of your portable music player by reducing the size of mp3 files. This is especially useful when listening to MP3 files or MP3 Audio books on a mobile phone, MP3 player, Pocket PC, etc.

read more |

Ajax Utilities

Here are more than 150 ajax utitlity with full description about each utility

read more

Unable to enlist in the transaction

Today after about a month again I was facing a similar problem of unable to enlist a transaction. I took half a day, to realise that this is the problem as there was no error when I was using the web interface but the results were not coming up. Then I slowly started looking at the event viewer and only then I noticed the "Unable to enlist a transaction error". I didnot expect the reason for this until I read this article, When I disconnected the firewall everything seems working well. I have now switched the firewall back on by allowing the port for MSDTC as 3372.

document.getElementId() has no properties

Today I was getting this error, in Firefox even though the Javascript code that I wrote was working fine.

I had a feeling that my javascript code was not working, and concentrated to work on that.

But the error was not in the javascript code but in the xsl code.

To solve these kind of errors in FF give your elements IDs instead of names and reference them with

document.getElementById("id")

IE seems to be a bit relaxed even though you have a name defined and not the Id.

Adding lines on a stacked column chart

Today I had a need to do a graph in Excel where it need to display a stacked column chart and also a line in the same graph.

The data for this is as follows for three years

2008 2009 2010
12000 14000 16000
1000 1000 1000
170000 180000 200000

I wanted a stacked column with the first two rows and a line with the last row. But when I chose the normal 2d column chart, it was showing all three rows as one stacked column.

To get the desired results, I followed the following steps

First, include all three rows in the series part of the chart data and choose the 2d stacked column chart

Next, right-click on the colored part of the bar that corresponds to the year and choose "Chart Type". Then select the first Line graph. Click Ok

Finally, right click on the graph and choose chart options and tick the 'Value Y Axis' tick box under the secondary axis lable of the 'Axes' tab

You should now have the first two rows displayed as a stacked column chart and the third row displayed as a line graph above your columns.

Convert VBscript to Javascript

I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful

Beware that this tool does not work in firefox though.

New transaction cannot enlist in the specified transaction coordinator

I was faced with this error when I was trying to configure a web application and trying enter a transaction through the virtual website. Thanks to the internet, I found a lot of information on the internet.

Here are the steps I followed to correct this:

Start the Component Services administrative tool. To do this, click Start, click Run, type dcomcnfg.exe, and then click OK.
In the console tree of the Component Services administrative tool, expand Component Services, expand Computers, right-click My Computer, and then click Properties.
Click the MSDTC tab, and then click Security Configuration.

Turn on the Network DTC Access
Allow Inbound
Allow Outbound
Enable XA Transactions
Choose No Authentication required

Save these settings and reboot your system.

The error is fixed.

In Windows Server 2003 SP1 and in Windows XP SP2, the Distributed Transaction Coordinator service gives you more control over the network communication between computers. By default, all network communication is disabled. The Distributed Transaction Coordinator Security Configuration dialog box has been enhanced so that you can manage these communication settings.

Animations using Javascript and jQuery

How to do animations using Javascript and jQuery. It's easy and can stand in Flash!!

read more

101 Ways To Know Your Software Project Is Doomed

Here's a handy little guide to point you in the right direction...

read more

Understanding the C in CSS

This simple tutorial explains the cascading feature of CSS. Useful for those starting out with CSS or if you need a refresher.

read more

Creating Excel Spreadsheets from VB.NET

This nice tutorial walks you through step by step creating an Excel spreadsheet with multiple worksheets. This nice introduction includes full source code and detailed instructions to help you get started.

read more

Is your site well designed?

Simple guide on how to tell if your website was poorly designed by an amateur.

read more

Top Ten of Programming Advice NOT to Follow

A top programmer examines a number of the top items of programming advice commonly given, and makes a great case for why they should NOT be followed. Some interesting food for thought for any programmer.

read more

Ten CSS tricks you may not know

Cascading Style Sheets are the foundation on which many of the best websites are built. Using CSS allows developers to describe the common style for the website, in terms of colours, fonts and layouts. In this tutorial, Trenton Moss of Webcredible shares some of his top tips to help you get the most from your CSS.

read more

Online JPG to HTML Converter

Probably how the "Crazy guy can draw using HTML!!!"A table is created which is filled with large numbers of 1x1 cells. Each cell has a background colour of the corresponding pixel in the image. That's all it is; just a massive grid of coloured table cells. View the source to see the details.

read more

Inspiration Package: 60+ Usable & Elegant Designs

Over 60 elegant, usable and impressive designs with a well thought-out color scheme, typography and visual structure. Their beauty lies in the way both information is presented. Their usability lies in the way they communicate presented data. That's what make them different.

read more