C#

<br />
 DataSet tpoDataSet = new DataSet();<br />
 command.Transaction = transaction;<br />
 command.CommandText = psSqlStatement;<br />
 command.Connection = ipoConnection;<br />
 adapter = dbProvider.CreateDataAdapter();<br />
 adapter.SelectCommand = command;<br />
 adapter.Fill(tpoDataSet);<br />
            <br />
return tpoDataSet;<br />

<br />
"SELECT column_name as colname ,data_type as datatype, " + <br />
"character_maximum_length as CharLen,numeric_precision, " +<br />
"numeric_scale, column_default as defaultvalue , " + <br />
"CASE WHEN COLUMNPROPERTY(object_id(table_name),column_name,'IsIdentity') =1 THEN " +<br />
"'YES' ELSE 'NO' END " +<br />
"as 'IsIdentity', " +<br />
"is_nullable as IsNullable " +<br />
"FROM [" + psTargetDb + "].INFORMATION_SCHEMA.COLUMNS " +<br />
"WHERE TABLE_SCHEMA = 'dbo' " +<br />
"AND table_name <> 'utSqlLog' " +<br />
"AND table_name = '" + tpsTableName + "'";<br />

<br />
"CASE WHEN COLUMNPROPERTY(object_id(table_name),column_name,'IsIdentity') =1 THEN " +<br />
"'YES' ELSE 'NO' END "<br />

[DefaultProperty("Text")]
[ParseChildren(true), PersistChildren(false)]
        
public class MyGrid : GridView
{        
    //... Some variable declarations

    protected SizeItemCollection _PageSizeItems;
    [Category("Paging")]        
    [Editor(typeof(CollectionEditor), typeof(System.Drawing.Design.UITypeEditor))]
    [PersistenceMode(PersistenceMode.InnerDefaultProperty), MergableProperty(false)]
    [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
    [Description("Items list for the PageSize selector DropDownList")]
    public SizeItemCollection PageSizeItems
    {
        get
        {
            return (_PageSizeItems != null ? _PageSizeItems : new SizeItemCollection());
        }
    }
    protected override void InitializePager(GridViewRow row, int columnSpan, PagedDataSource pagedDataSource)
    {
        //Here I create the pager row and added the DropDownList with the values in PageSiZeItems
    }
	
    //... some more code ...
        
}

public class SizeItem : Component
{
    private int _size;
    public SizeItem() { }
    public SizeItem(int size)
    {
        _size = size;
    }
    public int Size
    {
        get { return _size; }
        set { _size = value; }
    }             
}

public class SizeItemCollection : CollectionBase
{
    //Here I implemented Add(), Insert(), Remove(), Contains(), IndexOf() and CopyTo()
    //for my SizeItem class
}