Duh, I just found it.

Seems I thought I was creating all my SQL command param objects up in sub Main but turns out I wasnt so when I went to...

Ah, OK.

I wrapped the offending line with Try-catch and here's what I caught:

Try

objDataAdapter.Fill(objDataSet, "ExpenseReport")

Catch ex As Exception

Console.WriteLine(ex.Message)

End...

OK, let me describe what I'm trying to do a little better...

This is a VB.Net 2003 app that talks to MS SQL server using ADO.NET and bound controls.

Its an expense...

Yea, I tried those....

 Basically, I tried the following dataset methods...

dataset.table("tablename").clear()

dataset.table("tablename").reset()

dataset.table.remove("tablename")

I'm still stumped...  The really odd thing is that when I look at the dataset in the debugger I can see...

Thanks, it did.

The tricky part was understanding that you only need to add parameters once when the example in the book added them every time.  Of course, the book example...

Ah, I C said the programmer.  😉

So what you're telling me is that unlike other DBs like mySQL, and Access, which have their own seperate user security system totally seperate...

This is a cookie cutter example from O'Reilly's "Transact-SQL Programming" book.

bcp pubs..authors out authors.txt -Usa -P -Slocalhost -c

Its supposed to copy the contents of the authors table from the pubs...