I am failry new to Visula basic...

Im writting a visual basic project for school. I need to create a connection to a database in access and search it using sql. I have used ADODC but i was wondering how i could create the connection in the code its self on a command button....can you tell me the best way to do this

cheers