Hello,

 I'm having trouble with the example on pp570, where you add records to the database. The line:

'Parameter for the au_id column...
objCommand.Parameters.Add ("@au_id", BindingContext(objDataView).Current("au_id"))

wont run. I've tried downloading the project from this site and its the same code and same problem:

Additional information: au_id is neither a DataColumn nor a DataRelation for table authors.

In addition, when I look at the Intellisense help, there's no overridden method that accepts a string so something is definitely wrong here.

I'm using WindowsXP, SP2, all patches with VB.NET 2003, which is what the book is all about.

Any help is appreciated.

I'm digging deeper into the issue and found something strange.

 The current DataRowView for the DataSet has only four columns, which happen to be the four columns that are bound to controls. Me thinks there's some optimization going on here that the author may not have known about. It would *seem* that only those columns that are actually in use are maintained in the DataSet and DataView. Me thinks this is may be a bad thing but it would explain the error I'm getting.

OK, never mind. I found a typo in my SQL statement where I left out the au_id field.

Terribly sorry.