Monthly Archives: March 2015

SQL Server PIVOT tutorial

Pivot can be a little tricky to use. I will explain with the help of example — Create Table First create table student( id int not null primary key identity, rno int not null, subject varchar(30), score int, outof int) … Continue reading

Posted in SQL Server 2008 | Tagged , , | Leave a comment

Redirect in PHP not working

header(“Location: http://www.website.com/”); is generally enough to redirect your page but most of the time it does not work because it requires that no data should be sent to the client before the header, or rather header should be the first … Continue reading

Posted in Tutorials/Tips, Uncategorized | Leave a comment

Looping through gridview in C# always return empty

I had a gridview which was bounded to a datasource (datatable in my case) in code behind in C#. Code was something like this foreach (GridViewRow Row in GV_Items.Rows) { string str = Row.Cells[0].Text; } This was always returning empty … Continue reading

Posted in Tutorials/Tips | Tagged , | Leave a comment

excel add title to chart

Tutorial on how to add title to Excel Chart 1. Click on Excel Chart 2. Chart Tool appears in the ribbon bar. 3. In the “Design” TAB, “Chart Layout” group, select the first one which contains title. 4. Title will … Continue reading

Posted in Tutorials/Tips | Tagged , | Leave a comment

print 4 charts one page excel

This is really simple. Create four charts as you would normally do Create a new sheet Copy and past the 4 charts to the new page. Place them (and resize them) so that they appear one page. Do print preview … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

IMAP vs POP3

There are two main protocol for accessing your emails via client. IMAP and POP3. The following are the main differences [table] IMAP, POP3 IMAP coordinates with the server, POP3 does not coordinates with the server Email synched via IMAP are … Continue reading

Posted in Tutorials/Tips | Leave a comment

windows cannot print due to a problem with the current printer setup

This is a work around for the above problem, your printer cannot print because of margin set in the printer setting. A quick work around is as follows: 1. Print to PDF Printer (If you don’t have one, install one. … Continue reading

Posted in Tutorials/Tips, Uncategorized | Tagged | Leave a comment