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’s original founder Ali Jani and 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.

Feel free to reach me at ali@icode.com

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

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%>”)