How to implement Data Access Layer

Question

Hi Guys!

I am newbie to .net.  How can I implement Data Access Layer? Let suppose, I want to search a city information using stored procedure.

I would appreciate your valueable suggestion.
Thanks!

Uttu