Category Archives: General

Welcome to iCode Software

iCode was founded in 1989, and has had an incredible journey over the years with multiple successful hardware and software engineering ventures.   While the founders of iCode have all moved on to create many other successful ventures, this site’s purpose is is to serve as a repository and social hub for iCode fans.   Together we can discuss all kinds of awesome development projects, post general how to’s, tips/tricks, and any other technology related topics.

Lets see how this progresses and I have no doubt the iCode legacy will continue to live on.

MS SQL query to Find Columns or Fields in Database

If you need to locate a field in a large database and you don’t know what table the filed is or not really sure of the exact spelling of the field, you can use this simple query to search for fields names in a database.

SELECT t.name AS table_name, 
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%Your_Field_Name%'
ORDER BY schema_name, table_name

Inject onload javascript function for asp.net aspx pages with master page

1. Add reference to HtmlControls on top of your cs file

using System.Web.UI.HtmlControls;

2. In your Page_Load function of the .cs file add

((HtmlGenericControl) this.Page.Master.FindControl(“PageBody”)).Attributes.Add(“onload”, “load()”);

3. Make sure your master page BODY has the the matching id from above. in this case: ID=”PageBody” runat=”server”

4. In your aspx file, add you load function. something like:

Use SIP Client softphone with your Google Voice account – Free!

Since Google does not support SIP, what you need to do to get around the restriction is get an alternate SIP account, connect it to a 2nd phone number, and the forward your Google Voice to this number.

This is how you can do it for Free!

1. Get a SIP account from sip2sip.info

  • (Its free and just take a minute to create an account)

2. Get an IPKall phone number from ipkall.com

  • Create an account and use your sip2sip.info from step 1 and they will give you a USA phone number for free.

3. Get a Google voice number (if you don’t have one yet) and forward it to your new IPKall phone number from step 2.

4. Setup your softphone using your sip2sip.info account info.

  • I like the free client called Zoiper.  you can get it here.

Thats it!

Now your Google Voice inbound calls will ring on your SIP client!

enjoy!

document.getElementById in asp.net with Master Pages

Using JavaScript to locate controls in ASP.net pages that are linked to master pages can be tricky.  This is because the ASP.net reassigns control IDs dynamically and the names change.

A simple solution is to use asp.net inline Tags.

For Example:

Instead for using:

document.getElementById(“Label1″)

try using:

document.getElementById(“<%=Label1.ClientID%>”)