Category Archives: SelectCommand

Showing only present and future dates using SelectCommand in ASP.NET

Where you have a database of events you can easily exclude those which have gone by leaving only current and future events. However, getting the SelectCommand syntax right is not obvious. Continue reading

Posted in ASP.NET, SelectCommand, SQL | Tagged , , , | 1 Comment

Category links with record count in ASP.NET

Here’s how to show a list of links with the number of records shown in brackets. This is actually very simple but you can really get tied up in knots if you don’t get the SQL SelectCommand right. Continue reading

Posted in AccessDataSource, ASP.NET, DataList, SelectCommand, SQL | Tagged , , , | Comments Off on Category links with record count in ASP.NET