This stored procedure retrieves all the columns of each table in every database. create procedure SP_GetAllColumnsFromAllDB/*———————————————————————- Procedure to retrieve columns of all the databases– Usage : exec SP_GetAllColumnsFromAllDB– Logic is:
Building a reusable AJAX class can help you eliminate some of the headaches when you’re starting out: Open a new file called connection.js and type the following lines in to
This algorithm converts column numbers (1-x) to Excel column names. It works for any number and does not have a limit. ‘————————————————–‘ Columns can be any number from 1 to
icrosoft first publicly demonstrated Avalon way back in 2003 at the Professional Developers’ Conference (PDC) in Los Angeles. They touted Avalon as the next generation in user interface methodology, and
isplaying data in a table is everyday work for Web application developers. In this 10-minute solution, you will learn how to quickly create feature-rich tables for your JSP pages using
any developers would love to leverage the rich UI, high performance, and offline capability offered by smart client applications; however, they’ve been turned off by the high TCO caused by
isual Basic programmers who do networking programming will no doubt be familiar with the MSCOMM control in VB6. For those of us who followed VB’s progression to VB.NET, it was
s a J2EE developer you might sometimes be interested in comparing a modified XML document with the pre-modified version of that document. Or you might want to compare two XML
To retrieve the required field from the table based on the supplied condition, use the following code: Function GetQueryResults(strSql As String, Optional ReadOnly As Boolean = True) _As Recordset Dim
To run Tomcat with a security manager, you must add your own policy lines to the catalina.policy file?like when you build a SecurityManager. The catalina.policy file can be found here:
To find a SQL Server object, such as a user table, query the sysobjects system table in the local database. If the database name is unknown, use the following query:
atabase performance is one of the most critical characteristics of almost any application, and for the developer or DBA it usually depends on how fast they can retrieve data. Hence,
he Tablet PC SDK makes it easy to get Ink onto your Web page, but then what? This article walks you through the easy part and then dives into some
ave you heard about Ruby? It seems to be a popular topic in software development circles today. This language came to my attention at a Java conference last spring, where
hould you use DataGrid or GridView in ASP.NET 2.0? Is SqlDataSource perhaps more appropriate than ObjectDataSource for building a data access layer? Are cookies evil or is a cookieless solution
DO .NET provides many rich features that can be used to retrieve and display data in a number of ways, but even given such flexibility, sometimes developers find themselves repeating
oice command interfaces may be the next big thing. In this article, I’ll walk you through the process of using the Microsoft Speech Server SDK to create a voice-command interface
++ has about 10 distinct integral datatypes and three more floating point datatypes. Each datatype has different numeric properties such as the numeric range, the maximum number of digits it
Suppose you have imported both java.util and java.sql packages into your program and you wish to use a Date class. This would create a conflict because both the packages have
Use this code to clear all the controls in a form. ‘ Inputs : Frm – Form to clear’ All – If False, then only those controls whose TAGFIXED will
Suppose you want to search for the strings com, comment, and comments in your code. Press Ctrl + I and start typing. The .NET IDE will start searching as you
ython is a stable general-purpose programming language used in nearly all application domains by companies such as Yahoo and Industrial Light and Magic. Python Essential Reference, 3rd Edition, is a
aps are not only very useful, but they are also cool! In recent months, we have seen a lot of innovation in the area of online maps. Today we are
eing able to take handwritten notes or annotations is nice, but the real power of Tablet PCs comes from the ability to analyze and recognize handwriting written in digital Ink.
ack in 2000 while taking a walk in downtown Houston, I was approached by a couple of Astros baseball fans who asked me to join them in testing the plumbing
ou can transfer information between systems using ASP.NET in multiple ways; however, many are cumbersome, complicated, or insecure. For example, many data transfer methods pass information in plain text, which
When you use JavaScript’s window.print to print a Web page in IE, by default, it prompts IE’s printer dialog box. To avoid this, use the following JavaScript code: if (navigator.appName
Most “memory leaks” in Java are caused by references to objects that are no longer needed?if an object is still being referenced, then it cannot be finalized, and the memory
Suppose you want to select records from a table (say orders from a Northwind database), before and after a certain value (orderid). For instance, one order before and after 10250.
f you’ve ever tried to find classes in the .NET Framework that allow you to play audio and video, you may have noticed the gaping hole where this functionality should