DataGridView add, update, delete via SqlClient data provider vb.net

Developers just starting out with working with a DataGridView look for easy methods to add, update and remove data from a table in a database but as with anything new it's difficult to figure out how to implement these methods when working data without using Visual Studio IDE data wizards and are working with SQL-Server database. The sample code here shows how to implement add, update and remove.

Please note this is but one method and will not fit everyone's needs.

MSDN Code Example and C# version