how do i use ADO in visual basic?

Answer 1

See the Microsoft MSDN site for good answers. You will find plenty of examples at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadocodeexamplesinvisualbasic.asp