Google Brother Up

2008/10/31

Paging Code Behind

protected void gvColumnList_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {        
        gvColumnList.PageIndex = e.NewPageIndex;
        gvColumnList.DataSource = ViewState["vsGridView"];
        gvColumnList.DataBind();                        
    }


106 unique visitors

2008/10/27

All Databases and All Tables

  • Select All Databases from a Server (this is a system stored procedure)
sp_databases

  • Select All Tables from a Particular Database

select name from sysobjects WHERE type = 'U'

106 unique visitors

Drop Down List

1. http://www.janetsystems.co.uk/Articles/NetArticles/tabid/74/itemid/161/modid/449/Default.aspx