Pushing Pixels

Computing and Digital Imaging

Pushing Pixels random header image

Entries Tagged as 'c#'

Determining row counts for all tables in a database

January 11th, 2007 · No Comments · ASP2, SQL

Here is a usful snippet if you want a way to get the number of rows in each table in your database. I use this in an admin-only page of the web application to provide some at-a-glance statistics. It is also really useful in unit tests for checking the correctness of business logic that may [...]

[Read more →]

Tags: ···

Useful CSV reader

January 10th, 2007 · No Comments · .net, Software Development

To aid my unit testing I needed to populate a database with a load of test data. This data needs to be generated by some of the less technical guys on the project and so exporting CSV (Comma Separated Values) files from Excel seemed a sensible approach. So I then cast around for any existing [...]

[Read more →]

Tags: ··

Don’t believe NUnit

January 5th, 2007 · No Comments · .net, ASP2

Just a quick note about a little problem I found using Nunit (2.2.9, but affects earlier revisions too). After a bunch of edits to my project, I suddenly started getting messages from NUnit GUI “could not load file or assembly nunit.core”. Try as I could, this would not go away. This included everything from reinstalling [...]

[Read more →]

Tags: ···