There’s a good article by Scott Guthrie here that describes the basics. Just scroll down to Tutorial 5 for the INSERT specific bit – it is pretty straightforward and there is no point my repeating it here.
One point to note, however, and why I wrote this particular post. The key step in getting this working [...]
Entries Tagged as 'ASP2'
Tips for returning IDENTITY values from INSERT
January 14th, 2007 · No Comments · ASP2, SQL
Tags: programming·tips
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 [...]
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 NUnit [...]
Adding ASP Role tables to your own database
December 29th, 2006 · No Comments · .net, ASP2, SQL
This is still work in progress, but I want to incorporate the user role management tables within my own database, as the concept of users and their distinct roles ties right in with the core business model of the new site.
The following link explains the standalone tool to create the tables:
ASP.NET SQL Server Registration Tool
Invoking [...]
Tags: programming
Gotcha on setting up a data connection
December 29th, 2006 · No Comments · ASP2, Software Development
This one gets me every time. When you set up a new data connection to a database running on a local copy of Sql Server Express, in the “Add Connection” dialog you need to prefix your machine name to the defaulted value of “SQLEXPRESS”. E.g. if the network name of your PC is called “devpc”, [...]