Monthly Archives: February 2012

double click to copy

Posted on February 29, 2012 by

In software development esp testing, you need to copy and past a lot of stuff. There is a firefox Addon that makes your life a lot easier. You simply select the text (that you want to copy) You hold doen … Continue reading →

Posted in Software Development | Leave a comment

Universal Printer Driver from HP

Posted on February 23, 2012 by

You can install HP Universable printer driver that works for any printer (not just HP). The beauty of it is that it can install network printers which may not be instally the regular way (using Add Printer and Find). To … Continue reading →

Posted in Troubeleshoot | Leave a comment

Adding Ajax to ASP.NET Visual Studio 2008

Posted on February 10, 2012 by

Ajax functionality for ASP.NET can be added by downloading and installing Ajax Toolkit. It is in the form a a DLL that needs to be added to every project, where you intend to use it. It is supplied by Microsoft … Continue reading →

Posted in Tutorials/Tips | Leave a comment

test code

Posted on February 7, 2012 by

        protected void GridView2_RowCreated(object sender, GridViewRowEventArgs e)         {             int m = e.Row.Cells.Count;             if (e.Row.RowType == DataControlRowType.Footer)             {                 for (int i = m – 1; i >= 1; i–)                 {                     e.Row.Cells.RemoveAt(i);                 }                                 e.Row.Cells[0].ColumnSpan = m;                 e.Row.Cells[0].Style.Add(“text-align”, “center”);                 e.Row.Cells[0].Text=“<a style=”text-align:center;” href=”updateContactIDs.asp”>Update Contact</a>”;             }           }  

Posted in Uncategorized | Leave a comment

One combined footer in GridView – ASP.NET

Posted on February 7, 2012 by

This link explains how to display the footer of a Gridview as one large cell rather than every cell has its own footer. I tried this solution but it did not work for me. I tweaked it and posted the … Continue reading →

Posted in Tutorials/Tips | Tagged | 2 Comments

Transpose in Excel 2007

Posted on February 3, 2012 by

You can convert rows in column and column in rows in Excel pretty easy using past special. However it did not work for me. I was copying my tables from SQL Server and paste special would not give me any … Continue reading →

Posted in Tutorials/Tips | Leave a comment

SQL Select * into from

Posted on February 2, 2012 by

If you want to copy or backup your table in the database, use the following SQL command. select * into newtable from oldtable The new table is created on the fly. You do not need to create it. A more … Continue reading →

Posted in SQL Server 2008 | Leave a comment