Category Archives: DataView

Selecting a random database record with SQL

Here’s a “quick and dirty” way of selecting a database record at random. This can be used for things like showing a featured product or a random advert. Continue reading

Posted in ASP.NET, DataRowView, DataView, NEWID(), SQL, TOP, Uncategorized, VB.NET | Tagged , , , , , , , , , | Comments Off on Selecting a random database record with SQL

Returning a Record Count using VB.net

When websites feature a text search and a table or list of results you will sometimes see something like: 73 records matched your search or 128 matches found. This is actually very easy to do but incredibly hard to find … Continue reading

Posted in ASP.NET, DataView, VB.NET | Tagged , , , , , | 2 Comments

Setting the page title dynamically in ASP.NET

With a database driven site it’s very useful if pages giving details of a specific product have that product name in the page title. Continue reading

Posted in ASP.NET, DataRowView, DataView, MasterPage, Page.Header.Title, VB.NET | Tagged , , , , , , , | 2 Comments