by Jason Prahl | Jul 6, 2010 | Blog, Programming

I spent a fair amount of time nailing this one down so I figured I’d better record it for future reference.
From within your gridview section add your columns and change one of the columns to a template then you can manipulate what shows up for that column.
<asp:HyperLink ID=”HyperLink1″ runat=”server” Font-Underline=”True”
NavigateUrl=<%# String.Format(“javascript:void(window.open(‘http://intranet/somepage.aspx?parameter1=” & Eval(“gridviewColumnName1”) & “¶meter2=” & Eval(“gridviewColumnName2”) &
“‘,’_blank’,’width=750,height=700,toolbar=no,status=yes,scrollbars=yes,resizable=no’))”, Eval(“gridviewColumnName1”)) %>
Text='<%# Bind(“gridviewColumnName1”) %>’></asp:HyperLink>
What you end up with is a hyperlink that looks something like this:
javascript:void(window.open(‘http://intranet/somepage.aspx?parameter1=gridviewresults1¶meter2=gridviewresults2′,’_blank’,’width=750,height=700,toolbar=no,status=yes,scrollbars=yes,resizable=no’))
So the hyperlink will popup a window and take you to your specified page and passes 2 parameters to the page that can then be acted upon.
Hopefully this makes sense. It does to me right now, but who knows when I come back to it later! :)
Note: many times when you copy and paste this sort of code into your environment you’ll have to change the apostrophes because they get replaced with a backwards apostrophe which will cause problems.
by Jason Prahl | Jul 6, 2010 | Blog, SQL Server

I couldn’t find an easy way to search for a column across all tables in SQL Server 2008 like I could in 2003.
After some poking around on the internet I found the following on this blog:
Select O.name objectName, C.name ColumnName
from sys.columns C inner join sys.objects O ON C.object_id=O.object_id
where C.name like ‘%NameOfColumnHere%’ order by O.name,C.name
Note: Sometimes when you copy and paste the apostrophes get changed surrounding the name of the column you are looking for so you might need to delete them and put them back in.
Update:
The following is for finding stored procedures:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ‘%NameOfStoredProcedureHere%’
AND ROUTINE_TYPE=’procedure’
by Jason Prahl | Jun 25, 2010 | Blog, Computer Tips

sudo pmset hibernatemode 0
Reboot then:
sudo rm /var/vm/sleepimage
sudo pmset lidwake 0
Check power settings:
sudo pmset -g
Bios settings:
Enabled EDB. Disabled Legacy USB Support. Enabled USB S3 Wake-Up
Brightness Mode Control – User Control
by Jason Prahl | May 31, 2010 | Blog, Quotes

Those who hope to survive with any measure of emotional sanity and mental stability must have a solid diet of sound biblical theology, clearly understood, consistently digested, regularly put into action.
– Chuck Swindoll
by Jason Prahl | May 29, 2010 | Blog, Quotes

To see in color is a delight for the eye but to see in black and white is a delight for the soul.
~ Andri Cauldwell
by Jason Prahl | May 13, 2010 | Blog, Quotes

Often worship is interupted by words.
~ Chuck Swindoll
by Jason Prahl | May 8, 2010 | Blog, Quotes

Safe exploding is good exploding.
~ Jamie Hyneman
by Jason Prahl | May 1, 2010 | Blog, iOS Tips
I’m loving the iPad to say the least. One of the things I use it for is remote desktop session into my server at home or into servers at work. Since the iPad is from the Apple world sometimes navigating Windows machines using remote desktop can be challenging. The iPad’s on screen keyboard lacks function keys and arrow keys.
I found out that when in a remote desktop session it’s really easy to bring up the Windows on screen keyboard to help things out.
This has been tested on Windows 7 and Server 2003. Click on start then run. Type osk and hit enter. Now you should have the on screen keyboard along with function keys and arrow keys.