I suggest go through this page first
http://www.w3schools.com/ado/ado_ref_connection.asp
also MSDN itself is a great source to this topic.
Find some source code from the internet and burn your hands in trying to write a program with ADODB. Probably you will face some problems, then come up with the specific question.
Happy programming.