OK, I had enough of VB 2005's pathetic data capabilities. They suck!

I ended up spending the last 20 minutes completing the adding, editing & updating, and deleting of records in VB.NET 2003. And guess what, it works beautifully.

Lesson learnt:
next time I want to do any manipulation of database related stuff, I will do it in VB 2003, and definitely not in VB 2005.

Thanx anyways!