Monthly Archives: March 2015

SQL Server PIVOT tutorial

Posted on March 30, 2015 by

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

Posted on March 27, 2015 by

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

Posted on March 26, 2015 by

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

Posted on March 24, 2015 by

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

Posted on March 24, 2015 by

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

Posted on March 19, 2015 by

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

Posted on March 19, 2015 by

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