devxlogo

Tip Bank

How to Display ASP.NET DataGrid Data in Excel

Suppose you have a DataGrid with several columns full of data. The DataGrid contains several pages. You can disable paging and export all the data to Excel using the RenderControl

Display Table Information

This script displays all your table names&#151along with their column names, data types, data lengths, and null/not null information in a database. SELECT Sysobjects.name AS TABLE_NAME, syscolumns.Id, syscolumns.name AS COLUMN_NAME,systypes.name

The Purpose of the GO Statement

Although GO is not a T-SQL statement, it is often used in T-SQL code and unless you know what it is it can be a mystery. So what is its

Implementing a Proxy Selector in the Tiger Release of Tiger

Use this code to implement a proxy selector class in the Tiger release of Tiger: import java.net.*;import java.util.*;import java.io.*;public class MyProxySelector extends ProxySelector{ //implement the select method public List select(URI

Dealing with Wildcard Characters in Oracle

Developers generally tend to use characters such as % as a delimiter for storing data in an Oracle database. But because Oracle views the % character as a Wildcard character,