-
Recent Posts
Recent Comments
Archives
- December 2020
- May 2018
- April 2018
- January 2018
- October 2017
- April 2017
- February 2017
- January 2017
- November 2016
- September 2016
- August 2016
- July 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- December 2015
- November 2015
- October 2015
- September 2015
- August 2015
- July 2015
- June 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- November 2011
- October 2011
- September 2011
- August 2011
- May 2011
- April 2011
Categories
Meta
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
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
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
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
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
Getting RAW Data in LIMTON TIS Time Management System
I had to pull raw data of an employee who hare marked his/her attendance more than 2 times (probably thinking to trick the system or otherwise), the regular table HRTAttendance show only In and Out time. In case of multiple … Continue reading
Get No of Sundays in a month SQL Server
The following stored procedure returns number of sundays in given month. It takes date as parameter. Month and year is extract from the date. CREATE FUNCTION GetSundays (@giveDate DATETIME) RETURNS INT AS BEGIN DECLARE @firstday DATETIME, @lastday DATETIME SELECT @firstday … Continue reading
SQL Condition in WHERE Clause
How would you set a condition in where clause in SQL Server? For example you have a parameter @ProjectID. If @ProjectID is 1, then select all employee with EmployeeNo 1000. If @ProjectID=2 then select all employee with employeeNo betweeen 1000 … Continue reading